HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: INF4.1 -1 ERROR ?? problem
Reply-To: shemminga@cix.compulink.co.uk
Date: Tue, 29 Dec 1992 21:40:00 +0000


TITLE: Re: INF4.1 -1 ERROR ?? problem

In <1992Dec28.183425.12622@informix.com> David Kosenko writes:

[Stuff deleted]

>>Surely this should be user informix?
> 
> Why?  First of all, when you install Informix products, you do so as root,
> not informix (informix would not allow setting up the permissions needed
> on some of the files, which require root ownership with suid).  Second of
> all, as the original poster  stated, they are using a package-installation-
> script, which I doubt would be run as informix, more likely root or
> install.

I'll shut up 'cos I'm at home and can't check, but I'd've been
willing to bet real money that my installation instructions said,
"Create a user/group informix, log in as user informix, install
software..."

I'll be back! 8-)

| I'm not bad, I'm just drawn that way -- Jessica Rabbit     |
|------------------------------------------------------------|     
| Stuart Hemming       | shemminga@cix.compulink.co.uk       |
| Tudor Labels Ltd     | uunet!cix.compulink.co.uk!shemminga |
| Roman Bank Bourne    | Tel :  (+44) 778 426444             |
| Lincs PE10 9LQ. UK.  | Fax :  (+44) 778 421862             |


Stuart
|8-)
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Improvements to I4GL
Date: 22 Dec 1992 20:53:07 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: dave.snyder@snide.com (Dave Snyder)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1733>

Quoting dominic alston...
} 
} obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler) writes:
} >
} >Dear Paul,
} >
} >The following items are on my wishlist for I4GL, over and above the INPUT
} >ARRAY stuff which has already been supplied by other people.
} > . . ..
}  
} 	How about making it object oriented.
} 
Look for 4GL++ out soon (I hope!)

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: Start values for serial columns
Date: 31 Dec 92 16:57:48 GMT
Organization: Informix Software, Inc.

In article <725749037snz@prickle.demon.co.uk.demon.co.uk> malcolm@prickle.demon.co.uk writes:
>Thanks for the advice guys - I'll give up trying and encourage people
>to document the system properly.

the people you want to encourage read, file, and later make use of
email sent to:  doc@informix.com .

Whenever you find a shortcoming/oversight/error in any manual, please
fire off a message to that address.
From: Mark_Sherman@transarc.com
Newsgroups: comp.databases.informix
Subject: parameters as host variables
Date: 24 Dec 92 18:32:38 GMT
Organization: Carnegie Mellon, Pittsburgh, PA

I think I must be missing something obvious, but I can not seem to let
procedure parameters be used as host variables in esql programs, e.g.,

    void foo(a,b)
        EXEC SQL BEGIN DECLARE SECTION;
        long int a;
        long int b;
        EXEC SQL END DECLARE SECTION;
    {
        EXEC SQL
            UPDATE mytable
            SET mycolumn = :a
            WHERE myindex = :b;
    }

This seems to work fine if I make everything a local variable:

    void foo(a,b)
        long int a;
        long int b;
    {
        EXEC SQL BEGIN DECLARE SECTION;
        long int locala = a;
        long int localb = b;
        EXEC SQL END DECLARE SECTION;

        EXEC SQL
            UPDATE mytable
            SET mycolumn = :locala
            WHERE myindex = :localb;
    }

Am I missing something obvious? Thanks.
	-Mark (mss@transarc.com)
Newsgroups: comp.databases.informix
From: clawton@tfs.com (Chris Lawton)
Subject: Transactions
Organization: TRW Financial Systems
Date: Thu, 24 Dec 1992 02:09:30 GMT

	We're running Informix Turbo 3.5 here and we discovered a
process that leaves an open transaction for an extreemly long time.
(It's a Print Job manager that sleeps when there's nothing to do.)

	The question is:  Are there any know side effects of the open
transaction even if nothing has been done in the transaction?

Please respond to net or mail to me.

Chris Lawton
Oakland, CA
clawton@tfs.com
From: lei@mtcdev.MEDIATECH.COM (Charles Lei)
Newsgroups: comp.databases.informix
Subject: A few Questions
Date: 23 Dec 1992 13:13:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: lei@mtcdev.MEDIATECH.COM (Charles Lei)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1736>

Hello Netland:

We just installed On-Line 4.1 UD3 on our SCO 3.2.4 box.  On-Line has
been initialized fine (we think) and everything seems to run O.K.

The problem is that we're having a heck of a time getting our main 
database transfered from the SE engine to the On-Line engine.

This is what we use to dbexport:

   dbexport -c -t /dev/rct0 -b 20 -s 2000000 -f standard.sql standard

This is what we use to dbimport:

   dbimport -c -d uss1dbs -t /dev/rct0 -b 20 -s 2000000 -f standard.sql standard

We've bcheck'ed our SE database before the dbexport and it comes out fine.
The problem is that the import craps out with errors like:

    create table mtxsecrd 
      (
        login_id char(8),
        access_level smallint
      );
    revoke all on mtxsecrd from "public";

    *** load table ***
    Load file has different number of columns than table

We've checked the data in mtxsecrd and there are no "|" symbols 
anywhere.  In addition, the same tape is dying at different places during
different dbimport attempts.  We've tried using a different tape and
the problem just moves to a different table.

What are we doing wrong?

Thanks in advance for any replies...

Charles Lei
Mediatech, Inc.
E-Mail: lei@mediatech.com
Voice: (312) 828-9223 x.202
Newsgroups: comp.databases.informix
From: sjanney@baron.uucp (Sam Janney)
Subject: Any experience with Grafsman especially with Informix
Keywords: Informix, Grafsman
Date: Fri, 1 Jan 1993 00:07:08 GMT

We are considering the purchase of Grafsman to produce charts and
graphs from Informix databases and would like to hear from those
with experience both good and bad.

Currently we are attempting to develop using:

	SunOs
	Motif
	Informix
	Wingz

We are finding Wingz to be limited in the Motif environment without
having to invole the poor user ie: would like it to do its magic
without user intervention.

Grafsman and Tactician by Soft-tek International looks like it might
be the ticket.?!

Please e-mail and I will summarize back to the list.

		Thanks..... Sam Janney

------------------------------------------------------------------------
	sjanney@satsys.san.mrms.navy.mil
	DSR, Inc (619) 695-8220



Newsgroups: comp.databases.informix
From: n2976@cray.com (Andrew T. Rodnite)
Subject: INFORMIX DB BENCHMARKS and LOCATION of FAQ
Reply-To: n2976@cray.com
Organization: Cray Research, Inc.
Date: 28 Dec 92 20:40:15 CST

Hi,

	Are there any standardized benchmarks available for INFORMIX? These bench-
	marks would be used for the performance tuning of INFORMIX On-Line as well
	as the UNIX kernal?

	Is there a FAQ for this news group and where would it be located?

							Andrew Rodnite
							rodnite@clancy.cray.com
							(715) 726-5574
From: trinac@informix.com (Trina Clickner)
Newsgroups: comp.databases.informix
Subject: Re: What is INFORMIX-LINK?
Date: 23 Dec 92 18:01:04 GMT
Organization: Informix Software, Inc.

In article <1gin85INN8e4@emory.mathcs.emory.edu> tstar!verbus@psds.attmail.com writes:
>Hi,
>
>Could someone please tell us what INFORMIX-LINK is?
>

 - - - - - - -

Thanks for the opportunity to tell you about InformixLink, something that 
it near and dear to my heart!  ;)

In a nutshell, InformixLink is a dial-up information service containing 
electronic bulletin boards, full-text search databases and e-mail.  
Informix provides this on-line service to Informix Basic 
Maintenance/Assurance and Standard Support/OpenLine customers 
worldwide.  

A limited view is provided with each Maintenance/Assurance and 
Support/OpenLine contract, and an expanded, full-view is available on a
subscription basis from Informix.  The fees range somewhere between 
$500 and $4000 depending upon how many hours you subscribe to and 
where in the world you are.  For more information, you should 
contact your Informix rep.  In the US, call 1-800-438-7627.

Here's a quick overview of what's on there once you get your 
modem connected:

Information Resources      Source of Information     Update Frequency
------------------------   ---------------------     ------------------
Technical tips and hints   TechInfo databse          As required
Bugs database and lists    PTS                       Weekly 
Available Ports            PRS                       Weekly 
Marketing Info Sheets      Marcomm Infocenter        As required
Discussion areas           All Informix users        It's up to you!
User Group Listings        User Groups               As required 
Vendor Catalogs            Vendors/Partners          Annually

We believe that it provides a powerful vehicle to improve 
communications and information flow to, from, and among customers.  It's 
available 24-hours a day at up to 9600 baud from most places throughout 
the world, and provides a forum for sharing information on Informix 
products and services and for getting support.

As a central source of information on Informix products & services, 
it is my goal to ensure that the information we make available 
provides you with helpful independent investigating and 
problem solving tools.  Feel free to contact me at
trinac@informix.com.  It would be nice to hear from those of you
who are InformixLink users as well!

HAPPY HOLIDAYS!
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: ESQL C problem with sqlerrd[2]
Date: 17 Dec 92 17:21:50 GMT
Organization: Informix Software, Inc.

Kristen Altman writes:
>In my application, I am using ESQL C 4.1 and formatting 
>dynamic SQL statements.
>
>I have found the following problem/possible bug:
>
>After the first fetch the number of rows returned in sqlerrd[2]
>is 0, but the sqlca.sqlcode = 0 also.  If I understand this correctly,
>the sqlerrd[2] says there are no rows, but the sqlcode says there are rows.  


When fetching data with a cursor, sqlerrd[2] will not be set until the
last bufferfull of rows are selected into by the server (primarily because
you can't know how many rows there will be until that point).  To put
it more simply, on selects with cursors, do not expect sqlerrd[2] to be
filled in until the last row has been fetched (there are ways around
this, such as using a scroll cursor and fetching last).

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
Newsgroups: comp.databases.informix
From: aburt@mnemosyne.cs.du.edu (Andrew Burt)
Subject: Re: Display array highlist
Organization: University of Denver, Dept. of Math & Comp. Sci.
Date: Tue, 29 Dec 92 06:18:14 GMT

In <cortesi.725577273@helium> cortesi@informix.com (David Cortesi) writes:

>shemminga@cix.compulink.co.uk (Stuart Hemming) writes:

>>In-Reply-To: <1992Dec21.175031.11266@informix.com> cortesi@informix.com (David Cortesi)

>>I think a better way would be to arrange to have the report generated
>>to a file with the programmer responsible for line and page length.
>>Then Informix need only provide a file viewer in a window. The logic
						^^^^^^^^^^^
						!!!!!!!!!!!
>>for this could (should?) be very simple.

>>If this idea where implemented along with the dynamic report
>>definitions (variables for output target, line and page length) then
>>reports could be set up in apps to print on 60 line paper pages, in full
>>screen and windowed views.

(I can't believe this hasn't been in there for years!)

>>How does that grab you?

>The latter (ability to use variables in the OUTPUT section) is
>generally accepted as a Good Idea, I think.  As to the file viewer
>window, why do you want Informix to reinvent the browser
>that exists on every platform already (and probably do it wrong :)
>when you could just, for example, RUN "less /tmp/report.01"

I must have missed something really fundamental here, but how does
run "less ..." work IN A WINDOW???

It takes over the whole screen, right?  I want it IN A WINDOW.  IN A WINDOW.
Repeat after me, IN A WINDOW.

>Or under a GUI,
>	RUN "/usr/openwin/bin/textedit /tmp/report.01" WITHOUT WAITING
>You could even pass -Geometry arguments...  that should impress the troops...

Yes, especially on vt100 terminals :-)
-- 

Andrew Burt 		   					  aburt@du.edu

"But if he was dying he wouldn't bother to carve "Aaaaargh", he'd just say it."
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Corrupted Index
Date: 30 Dec 1992 22:13:17 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: dave.snyder@snide.com (Dave Snyder)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1746>

Quoting Bharat Shah...
} 
} Using tbcheck -cI we found that one of the index was bad.
} 
} My options are to:
} 
}    1. Let tbcheck repair the index
}    2. Drop the index and recreate it
} 
} What are the tradeoffs involved in deciding between the two ?
} 
Isn't that one of the primary things tbcheck is supposed to do?

Personally, I wouldn't do step number 2 until I've tried step number 1 first.

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: lei@mtcdev.MEDIATECH.COM (Charles Lei)
Newsgroups: comp.databases.informix
Subject: I-Net Question
Date: 23 Dec 1992 13:43:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: lei@mtcdev.MEDIATECH.COM (Charles Lei)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1737>

We purchased I-Net and On-Line last summer and its been sitting on
the shelves since.  We dusted off the On-Line and we've installed it,
but we've been told that the I-Net will not work because of a 
version incompatibility.

Can anyone tell me if I-Net 4.1 UD2 
                                  ^
                                  |

will work correctly with On-Line 4.1 UD3
                                       ^
                                       |

I'm in the process of talking to my rep to get an exchange so that
the minor revision number will be the same.  Is this really necessary?

Charles Lei
Mediatech, Inc.

E-Mail: lei@mediatech.com
Voice: (312) 828-9223 x.202

Newsgroups: comp.databases.informix
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Managing array/matrix data?
Organization: U.S Dept. of Transportation
Distribution: comp
Date: Tue, 22 Dec 1992 10:17:38 GMT

I'd be interested in hearing from anyone who has used Informix to
manage array- or matrix-structured data.  I am researching DBMSes
to manage a large collection of time-series data, which can be
thought of as one-dimensional arrays, and other multi-dimenstional
data structures.

Thanks,

			Seth Grimes, grimes@oecd.fr
From: markf@sequoia.sequoia.com (Mark R. Friedman)
Newsgroups: comp.databases.informix
Subject: C-ISAM to Informix rdb conversion utilities
Date: 29 Dec 1992 15:23:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: markf@sequoia.sequoia.com (Mark R. Friedman)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1743>

What utilities/tools exist to ease moving data from (Informix) C-ISAM files
over to a series of Informix databases? We've recently acquired a suite of 
'replacement' applications and would like to move the existing data over to 
the new apps, but our software vendor claims the only way to do so is by 
writing a suite of C programs (for which he'll charge us a mere arm and leg).
Is there a better way? We have access to what I believe to be the full range
of Informix products, and I _want_ to assume that there's a cleaner and
easier approach. Many thanks for any ideas or pointers...
-- 
|---------------------------------------------------------------|
| Mark R. Friedman    |                                         |
| markf@sequoia.com   |                                         |
|---------------------------------------------------------------|
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: ESQL C and sqlerrd[2]
Date: 21 Dec 92 17:32:03 GMT
Organization: Informix Software, Inc.

Kristen Altman writes:
>I am receiving replies to my original message about fetch
>returning 0 in sqlerrd[2] while sqlcode = 0.  The messages 
>all say that sqlerrd[2] does not return the number of rows.
>
>I am using ESQL/C version 4.1 and sqlerrd[2] DOES return the
>number of rows in the active set.  This application I have
>written works 99% of the time with sqlerrd[2] returning the
>number of rows.  In fact, I got the idea to look at that 
>variable for the number of rows from Dave Snyder (and I believe
>he knows what he is talking about).  
>
>In the ESQL/C manual it saya:
>	...
>	sqlerrd[2] is the number of rows processed.
>	...
>
>Therefore, does anyone have any idea what's going on with
>this??

I thought we had covered this, but I guess not.  It does indeed contain
the number of rows processed.  The question is, when does it get
filled in?  When you use a cursor, a bufferfull of rows are gathered by
your server, and sent to the client when requested by a fetch.  If all
the rows in your set will fit in the buffer, then the entire number of
rows returned is known, and sqlerrd[2] is filled in.  If the buffer will
NOT hold the entire set, then only a bufferfull is retrieved, and the total
number of rows in the set is not known.  When the last bufferfull is
retrieved from the db, the number will be known and sqlerrd[2] will be
filled in.

SO 99% of the time, you are getting all your rows in the first bufferfull.
The remaining 1% of the time require more than a single buffers worth.  In
those cases sqlerrd[2] will be filled in after the fetch that causes the
last bufferfull to be retrieved.

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
Newsgroups: comp.databases.informix
From: bossert@thalatta.com (John Bossert)
Subject: Error 208 - Memory Allocation
Organization: Thalatta Corporation, Bellevue WA
Distribution: na
Date: Sat, 26 Dec 1992 21:08:07 GMT

Environment:

4GL - 4.10.UD1
OnLine - 5.00.UC3

Sparcstation IPX, SunOS 4.1.3

When I try to run an application (that ran fine under 2.10.03 :-( )
I get:

#208 - Memory allocation failed during query processing.

Finderr says to talk to the system administrator, but I talk to myself
enough as it is! :-)

OnLine is running fine (for queries) so I think shared memory is ok.

Anybody got a suggestion?

-- 

In-Real-Life: John Bossert, Thalatta Corporation, (+1 206.455.9838)
Domain: bossert@thalatta.com   Path: ...!sun!sunup!thebes!bossert
From: unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah)
Newsgroups: comp.databases.informix
Subject: Corrupted Index
Date: 30 Dec 1992 16:08:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1745>

Hi,

We use OnLine 4.00 on SCO box.

Using tbcheck -cI we found that one of the index was bad.

My options are to:

   1. Let tbcheck repair the index
   2. Drop the index and recreate it

What are the tradeoffs involved in deciding between the two ?

Thanks in advance for the response.

========================================================================
Bharat Shah                                      Voice: (508)-663-7570
Unifi Communications Corp.                         Fax: (508)-663-7543
4 Federal St, Billerica, Mass 01821, USA      Internet: bharat@unifi.com
========================================================================
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: making isql output horizon
Reply-To: shemminga@cix.compulink.co.uk
Date: Sat, 2 Jan 1993 00:20:00 +0000


TITLE: making isql output horizontal

In <1992Dec31.210423.20141@informix.com> David Cortesi writes:

> Since I first posted this, at least two people have posted requests
> for solutions to the problem of "flattening" ISQL output.  For a long
> time I couldn't find this file, but finally it turned up.  So here it
> is, maybe Walt can stow it safely in his archive at Emory U?

[Code deleted]

I guess gawk is GNU awk right? Will this work under NAWK?


| I'm not bad, I'm just drawn that way -- Jessica Rabbit     |
|------------------------------------------------------------|     
| Stuart Hemming       | shemminga@cix.compulink.co.uk       |
| Tudor Labels Ltd     | uunet!cix.compulink.co.uk!shemminga |
| Roman Bank Bourne    | Tel :  (+44) 778 426444             |
| Lincs PE10 9LQ. UK.  | Fax :  (+44) 778 421862             |


Stuart
|8-)
From: martinez@no1.irs.gov (Deborah Martinez)
Newsgroups: comp.databases.informix
Subject: Inventory System Info
Date: 28 Dec 1992 10:28:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: martinez@no1.irs.gov (Deborah Martinez)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1740>

Interested in obtaining information concerning asset tracking systems
currently in use (either off-the-shelf or in-house developed); UNIX
environment, PC or minicomputer based.  

Particularly interested in applications geared to ADP equipment and software
or any being used in government operations.  Need the capability to track
items from acquisition to disposal as well as capture financial data.

Please email or contact me directly....thanks!

--------------------------------------------------------------------
Name:     Deb Martinez               Internet: martinez@no1.irs.gov    
Address:  1111 Constitution Ave NW      Phone: (202) 501-2726       
          ATTN: ISM:S:A:R                 Fax: (202) 501-3116
                810 7th St
          Washington DC  20001      
--------------------------------------------------------------------

Newsgroups: comp.databases.informix
From: mikep@.adaclabs.com (Mike Pechner)
Subject: 4.0 to 5.01 migration ?
Originator: mikep@slinky
Organization: Adac Laboratories, Milpitas Ca
Date: Tue, 22 Dec 1992 02:34:57 GMT

I am going to be moving from Informix 4.0 to informix 5.0.

We use On-line engine, ESQL for C , and Rapid developemnt 4GL
on Sun's.

Any one have any problems?

Any hints?

Is there an FAQ?


-- 
mikep@adaclabs.com (Michael Pechner)  | Pizza Probably The Worlds Most
Adac Labs                             | Perfect Food.
Milpitas, Ca                          | Carbo, Meat, Dairy, And Veggie