HDTenEightyP/NetNews huggingface dataset:
From: Cheryl@redriverad-emh1.army.mil
Newsgroups: comp.databases.informix
Subject: Conversion from 2.10 SE Informix to 4.1 and ESQLC
Date: 1 Sep 92 23:03:06 GMT
Reply-To: Cheryl@redriverad-emh1.army.mil
X-Informix-List-ID: <list.1419>

We are having some problems with converting some ESQL/C programs from
our old Informix to the new 4.1 version.

We were using 2.10 SE Informix on the PLEXUS Unix 5.2 Systems and
our code ran fine.  Now we are attempting to convert to a 600G AT&T
running Unix 5.3 and 4.1 SE Informix.  

We are having some problems with defined variables.

Here is a piece of our code:

$ select pres_rmks2 into $p_rmks2_in from new_stkno where
   n_stkno = $stkno_input;

The variable $p_rmks2_in is defined above main. 
as:
$ p_rmks2_in[71];

(This works in 2.1 on the Plexus Unix 5.2 system)

Yet when trying to compile we get this error.

esqlc: file program.ec, line ????: Host object 'p_rmks2_in' not declared

If the program compiles the program will run, acts like nothing is wrong
but will  not put the data in the form or database as the .ec program did
on the old system.

We are using .per's with calls to the ESQL/C functions and pf_getval
and pf_putval.  Can't we still do this in 4.1?  Please don't tell us
to use 4GL.  We have so many programs and so few people and time that
we must LIVE with what we have (at least we thing we do) until we can
learn to SPEAK 4GL fluently.

Has anyone experienced anything like this?  What are we doing wrong?
We have A LOT of programs with this type of code (2.10 running good) on
our old systems.  We are in a conversion to the new systems and must
migrate SOON.  

We have called informix Case # 181835 and haven't heard back from them
yet. Hopefully if NO one out there has an answer Informix will have it 
in the morning.

Would appreciate any information.

Thanks in advance,

Cheryl Gross
Red River Army Depot
Texarkana, Texas
(903) 334-3518
      334-3822
From: suffron@informix.com (Nancy Suffron)
Newsgroups: comp.databases.informix
Subject: Re: Informix Phone Numbers
Date: 3 Sep 92 22:06:23 GMT
Organization: Informix Software, Inc.

In article <9447@emory.mathcs.emory.edu> @emory.mathcs.emory.edu writes:
>As of:  Nov 29  1989  which is the last date we updated these phone numbers:
>            INFORMIX 
>  TECH SUPPORT    1-800-274-8184
>           FAX    1-415-926-6626
>
>You must have a valid serial number and maintenance agreement to get a 
>response.
>
>These numbers may not be valid now.

According to the Directory of Services pull-out in the latest issue of
Informix Times, the current phone numbers for Technical Support are:
     SUPPORT LINES           PHONE            FAX
     Product Registration    913-492-2086     913-599-8590
       and Product Updates
     Database Support        415-926-6300     415-926-6626


Nancy Suffron
Informix Software
Lenexa CSE
From: ronl@pdact.pd.necisa.oz.au (Ron Lees)
Newsgroups: comp.databases.informix
Subject: Re: Informix vs. Oracle
Date: 1 Sep 92 13:48:04 GMT
Reply-To: ronl@pdact.pd.necisa.oz.au (Ron Lees)
X-Informix-List-ID: <list.1417>

donb@pdx.csd.mot.com (Don Bolton) writes:

}	Their forms package does NOT communicate to their report writing package
} 	Their "procedural" SQL cannot be used for OUTPUT, only program variables
}          or TABLE data.
}
}	Outwardly, that "simple, ez to use, etc" forms package looks *slick*
}          now try a *real* task with it and spend a lifetime debugging your
}          triggers. And oh yeah you'll need a *seperate* set of screens to
}          drive those reports. 
}
}        Orifice controls a lot of things for the developer transparently which
}          seems neat until you realize what its doing is absolutely bass-ack-
}          wards to what you need to do. (conditional depending..)
}
}        Orifice *does* have a *superb* set of extensions to their SQL 
}          implementation, a lot of reporting can be run from straight sql
}          scripts, but if you need something procedural in nature your
}          hosed without doing a bunch of temp tables first and then doing
}          reporting.
}
}Informix, to the Oracle bigot, seems crude, but in reality is a far easier
}environment in which to get *real* tasks done, can be written to do nearly
}anything concievable (4gl) by anyone who has ever used any kind of a
}programming
}language. Thats not to say one couldn't do a lot in Orifice too, but,,,, its
}sold as an environment requiring *less* technical people and in reality thats
}just not true.
}

My experience of the forms package confirms what Don says. Although
development by form is novel to start with, for a large project it rapidly
becomes very tedious and slow. Especially if you want to make small
changes.

}These opinions are mine although I have found them to be shared by many deve-
}lopers who have worked with both products. They do not nessicarily represent
}the opinions of my company.
}

Having worked with both Oracle and Informix also, I agree with Don's
sentiments. However, I have to admit I haven't used Oracle for a couple
of years, having switched to Informix with my current employer.

}UNLESS Oracle has changed DRASTICLY in the past 6 months, its an overcomplex
}menagerie of dis-associated products..
}

This may be the sticking point. My understanding is that with the release
of V7.0, Oracle HAS changed drasticly and that reviewers in the literature
who were previously anti-Oracle are now raving about it.

Any Oracle 7.0 users like to comment on this?

+-------------------------------------------------------------------------+
Ron Lees                                        rlees@pdact.pd.necisa.oz.au
Software Development Centre (Canberra)                 Voice: +61-6-2516411
NEC Information Systems Australia Pty Ltd                Fax: +61-6-2516947
PO Box 244, Belconnen ACT 2616, AUSTRALIA                  A.C.N. 002068546
+-------------------------------------------------------------------------+
From: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re: Question - Window
Date: 26 Aug 92 14:23:08 GMT
Article-I.D.: emory.9400
Reply-To: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
X-Informix-List-ID: <list.1403>

}From: Dave Snyder <uunet!snide.com!dave.snyder>
}Subject: Re: Question - Window
}Date: Fri, 21 Aug 92 15:02:57 EDT
}X-Informix-List-Id: <list.1391>
}
}Quoting Ruchi Patel...
}> Hi! I am displaying the data in a window. INFORMIX-4GL allows you to scroll
}> page-up (using F3) and page-down (using F4 key). Is there anyway I can
}> change these keys so user can use the Page Up and Page Down keys instead?

}This is sick but it should work...
}  1) Determine the escape sequences for your PageUp and PageDown keys.
}     (on a SCO Unix console they are "\E[I" and "\E[G" respectivly)
}  2) Tweek the informix termcap file so that it recognises these sequences.
}     I added the following to the "ansi" entry...
}       :kE=\E[I:kF=\E[G:
}     (this tells 4GL that F15 and F16 sequences are identical to the PAGE keys)
}  3) In the 4GL code add the following two lines some place BEFORE array access.
}       OPTIONS PREVIOUS KEY F15
}       OPTIONS NEXT KEY F16
}I picked F15 and F16 because the SCO Unix console only has 12 function keys.
}These ideas have not been tested but I see no reason why they shouldn't work.
}Comments? Suggestions? Flames?

Comment: yes its sick, but its also the only way to do it.
Suggestions: you might  prefer to use F35 and F36 instead of F15 and F16.
Flames: not from me.

Yours,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: bob@worms-emh2.army.mil (Bob Kane)
Newsgroups: comp.databases.informix
Subject: 4GL, Make & SCCS
Date: 4 Sep 92 09:48:11 GMT
Reply-To: bob@worms-emh2.army.mil (Bob Kane)
X-Informix-List-ID: <list.1429>

If anyone out is currently using Unix Make files to compile 4GL programs that
are maintained by SCCS (Source Code Control System) I would appreciate some
pointers.  I am trying to set this up for all of our systems, but I am not
terribly familar with SCCS and how to make the proper calls to it from the
makefile.  For example, 4GL modules that use a specific globals file require
that the globals source file (the 4GL code) be available and readable at
compile time.  If you are using the makefile to compile a single module that
you have changed, it would appear that you have to check out a copy of the
globals file from SCCS before the compile.  This means that each rule for
a 4GL has to check out a copy of the globals file, and unget it when it is
finished, so it is availble for the next module.  Or is my logic faulty?

Example of the rules I have set up is below:

	module.o :
		$(GET) -e s.globals.4gl
		$(GET) -e s.module.4gl
		c4gl -c module.4gl
		unget s.globals.4gl
		unget s.module.4gl

-----------------------------------------------------------------------------
Bob Kane                   Internet: bob@worms-emh2.army.mil (IP 134.235.9.2)
TechDyn Systems               Voice: (049) 6241-487304   (WORMS, GERMANY)
CMR 421, BOX 706                Fax: (049) 6241-74530
APO AE 09056                    CIS: 71054,2661
From: kurt@sdd.hp.com (Kurt Andersen)
Newsgroups: comp.databases.informix
Subject: Re: buggy ROWID
Date: 1 Sep 1992 07:45:23 -0700
Organization: Hewlett Packard, San Diego Division
NNTP-Posting-Host: hpsdde.sdd.hp.com
Summary: Yet another result

On the other hand, using 4.1 ISQL and the 5.0 SE engine on HP 9000/series 300
I found the following behaviour:

> select a.rowid arow, b.rowid brow, a.k ak, b.k bk from b, a where a.k = b.k
> select a.rowid arow, b.rowid brow, a.k ak, b.k bk from a, b where a.k = b.k
both generated:
    arow   brow  ak  bk
     3      3    1   1
     3      3    3   3

The only way to get the expected result was to use "b, outer a" in the 
table specification.

Cheers,
  Kurt
-- 
                          kurt@hpsdid.sdd.hp.com
                  619/592-4373 (voice); 619/592-8191 (FAX)
             16399 W. Bernardo Dr. MS 61U65/San Diego, CA 92127
-----Standard disclaimer stuff applies for all of the standard reasons-----
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Conversion from 2.10 SE Informix to 4.1 and ESQLC
Date: 2 Sep 92 01:03:06 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1420>

Quoting Cheryl@redriverad-emh1.army.mil...
} 
} We are having some problems with converting some ESQL/C programs from
} our old Informix to the new 4.1 version.
} 
} We were using 2.10 SE Informix on the PLEXUS Unix 5.2 Systems and
} our code ran fine.  Now we are attempting to convert to a 600G AT&T
} running Unix 5.3 and 4.1 SE Informix.  
} 
} We are having some problems with defined variables.
} 
} Here is a piece of our code:
} 
} $ select pres_rmks2 into $p_rmks2_in from new_stkno where
}    n_stkno = $stkno_input;
} 
} The variable $p_rmks2_in is defined above main. 
} as:
} $ p_rmks2_in[71];
} 
Well if the above declaration is really that way in the code, that's your
problem.  I think what you want to do is this...

$ char p_rmks2_in[71];

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  ESQL/C Application-Interface Library Documentation
Date: 28 Aug 92 11:18:05 GMT
Reply-To: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
X-Informix-List-ID: <list.1407>

>From: uunet!esd.dl.nec.com!forney (Elizabeth (Liz) J. Forney)
>Subject: ESQL/C Application-Interface Library Documentation
>Date: 26 Aug 92 21:23:43 GMT
>X-Informix-List-Id: <news.1713>
>
>A while back the function prototypes for the OnLine Engine interface
>library was posted to the net.  Is there documentation available for the
>engine interface routines?  Any help locating documentation for these
>routines (such as _iqinsput, iqpopen, etc.) will be greatly appreciated.

Absolutely not!  The interface changes regularly.  It doesn't affect
you because the ESQL/C compiler generates the code and uses the
current set of routines withthe current set of arguments.  There is no
way Informix would distribute information on this interface, because
it would unnecessarily tie the developer's hands.

This is my view -- and just conceivably Informix's too.

Yours emphatically,
Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: message mystery
Date: 31 Aug 92 08:50:19 GMT
Organization: Enterprise Technology Center, Informix Software, Inc.

In article <1992Aug28.174738.21439@bradley.bradley.edu> larry@bradley.bradley.edu (L. D. Stratton) writes:
>
> I've tried about everything I can think of to correct this situation 
> but haven't found a solution yet.
>
>   After the 'screen record' statement, the following error appears:
>
>#  Screen record array "s_plan" has component sizes which either differ
># from the specified dimension of teh array or differ among themselves.
># See error number -2029.
>
>   Anyone with an idea???????
>
>   screen record s_plan[8](pln_line_no, pln_obj_text, pln_prior, pln_who,
>                           pln_line_no, pln_how_text, pln_start, pln_comp,
>                            pln_resource, pln_status)
>####  ERROR OCCURS HERE, SEE TEXT ABOVE

I would guess that it doesn't like you mentioning the same field twice within 
the screen record.  Try deleting the second occurrence of "pln_line_no" in
your screen record (and the program record in the 4GL program) and see if 
that compiles OK.  If you still can't get the desired effect, try turning the
second occurrence of pln_line_no into a formonly field and give it a different
field tag.

Hope this helps.

--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

I'm Pro-Anarchy...   and I Vote!
Newsgroups: comp.databases.informix
From: mikep@adaclabs.com (Mike Pechner)
Subject: dbexport permissions
Originator: mikep@slinky
Organization: Adac Labratories, Milpitas Ca
Distribution: ba
Date: Tue, 25 Aug 1992 23:53:23 GMT

I am having a problems with  dbexport.

I am running it on a machine that has the informix development
 NFS  mounted.

 My real user id is mike
 My effective userid is informix (user 162)

 the dbexport program is owned by root, and has not suid bits set.

 Why os the <db>.exp directory being created as being owned by nobody.

 That should only happen if I
 try to run dbexport as root.

 What is dbexport doing?

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

Newsgroups: comp.databases.informix
From: amby <amby@mixcom.mixcom.com>
Subject: Re: 4GL, Make & SCCS - we use CVS and GNU Make
Organization: Milwaukee Internet Xchange BBS, Milwaukee, WI U.S.A.
Distribution: usa
Date: Fri, 04 Sep 1992 14:45:27 GMT

In <9468@emory.mathcs.emory.edu> bob@worms-emh2.army.mil (Bob Kane) writes:

>If anyone out is currently using Unix Make files to compile 4GL programs that
>are maintained by SCCS (Source Code Control System) I would appreciate some
>pointers.

	We are using CVS (Concurrent Versions System), which makes use of RCS
	for version control.  All of our makefiles are designed to assume the
	necessary files are in the working directory.  You must have already
	checked out all the sources (via cvs checkout) before you invoke make.

	Having make do the checkout is fine for the latest version, on the
	main line of descent (for revisions).  We need to be able to build past
	versions of anything from sources.  This seems to work fine, so far.
-- 
Donald E. Amby
    don@amby.mixcom.com   (for short mail)        (414)797-6713 (voice)
    amby@eisner.decus.org (for lengthy mail)      (414)797-6533 (FAX)
    Harnischfeger Engineers, Inc., P.O.Box 1512, Milwaukee, WI 53201-1512
Newsgroups: comp.databases.informix
From: john@elsouth.uucp (John White)
Subject: WANTED: DOS based report writer for dummies
Summary: WANTED: DOS based report writer for dummies
Organization: Electrical South Inc
Distribution: na
Date: Tue, 25 Aug 1992 15:59:18 GMT

I've got a stack of computer illiterate users that are constantly
wanting reports that take 2 minutes to write in ace, but ace is
too intense for them. They need a point and shoot interface. I've
got SQL, 4GL, and I-NET/PC for them, but they need a really cute
GUI. I've heard of some products from Natural Languages, and IQ
Software, but haven't had the time to review them. Anyone have
any suggestions for products like this?

Thanks in advance, John White (john%elsouth@mcnc.org)

PS: I prefer Email, I'm bad about keeping up with the net.
    (Too many fires locally and otherwise)
Newsgroups: comp.databases.informix
From: ashaw@cbnewsg.cb.att.com (andrew.shaw)
Subject: Online Performance Degradation
Keywords: select prepare sun
Organization: AT&T
Date: Tue, 1 Sep 1992 17:43:28 GMT

I hope someone can help with a performance mystery with an ESQL-C program.
We are using Online 4.0 on a Sun 690 w 4 processors, 128M, etc.  The
process starts up and begins doing transactions from a file (adding data,
with lookups) to an empty database.  The performance data looks like this:

Elapsed minutes:   1    2    3 ... 10  ... 35  ... 50
# of transaction: 220  210  200    150     100     50

If you plot the number of transactions possible against elapsed time you get
what looks like a log N graph, ie plotted on log paper you get a downward
sloping straight line.  I should point out that since we are doing adds,
the elapsed time reflects the database getting continuously larger, albeit
at a slowing rate.

So, the question is: why would performance be falling off in such a drastic
and sterotyped fashion?  The logN nature must surely be a clue, but I can't
fathom OnLine internals.  The performance fall-off slows, but since this
program is supposed to run briskly over time, I am concerned that the
performance might be asymptotic to zero transactions per minute.

All of the ESQL-C statements are $prepared the first time they are run,
and their cursors $declared.  There are hardly any joins (if any at all).
There is a table with a combination (2 ints) index.

Any help would be most appreciated.

	Thanks,
		Andrew Shaw
		AT&T Bell Labs
From: bochner@das.harvard.edu (Harry Bochner)
Newsgroups: comp.databases.informix
Subject: Re: WORDWRAP [COMPRESS]
Date: 31 Aug 92 21:12:13 GMT
Article-I.D.: das.1992Aug31.211213.6994
Organization: Aiken Computation Lab, Harvard University

In article <1992Aug27.210820.7728@das.harvard.edu>, I wrote:
|> it seems to me at I want WORDWRAP without COMPRESS
...
|> I.e. it visually compresses the blanks on screen, even though they're there in
|> the database! This ruins the correspondence between what's on screen on what's
|> in  the report :-(
|> Is this a bug, or am I missing something?

It turns out this is Bug #10166, mentioned in the release notes. The work around
(for my case) is to use WORDWRAP COMPRESS, and then in the report use

print longfield WORDWRAP RIGHT MARGIN xyz

(When I posted my query, I had forgotten about the new wordwrap function, so I
couldn't see any way to get the effect I wanted ...)

-- 
Harry Bochner
bochner@das.harvard.edu
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: Informix I-Net problem
Reply-To: shemminga@cix.compulink.co.uk
Date: Wed, 26 Aug 1992 10:51:48 +0000



In <memo.572497@cix.compulink.co.uk> I wrote:

> Can anyone help me? We're running a small net of 386/486 boxes. On
> the 486 machine we've got Informix SE installed along with SQL and
> I-Net. On the other 2 machines we've go SQL and I-Net.
> 
> We also have a number of Informix 4GL programs running. The problem
> is that when a number of sqlexec processes are started the system
> reports the following error messages if someone tries to start
> another one:
> 
>         -932 : Error on network connection, t_open system call failed
>           28 : No space left on device
> 
> The message appears on the client terminals, the server doesn't seem
> to be getting upset about it. I don't know however, whether it's the
> client or the server that's generating the error message.

In the replies that followed it was suggested that the kernel
parameter NQUEUE was set wrong. I've since re-tuned the kernel on
both the server and the clients. Using crash it would appear that the
kernel resources are adequate (at least there are no failures).

I've discovered that the error occurs if there are 8 remotely started
sqlexec processes started on the server.

This may seem like a dumb question but I understand the entry that is
made in /etc/services is to allow tcp/ip to make connections. Would
having more than one entry mean that I could have more connections?

TIA

--------------------------------------------------------------
| Who cares whos opinions these are?!                        |
| Send me mail and I'll love you forever (Maybe)             |
|------------------------------------------------------------|     
| Stuart Hemming             | shemminga@cix.compulink.co.uk |
| Tudor Labels Ltd           |                               |
| Roman Bank Bourne          | Tel :  (+44) 778 426444       |
| Lincs PE10 9LQ. UK.        | Fax :  (+44) 778 421862       |
--------------------------------------------------------------


Stuart
|8-)
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: memory allocation under AIX 3.2
Date: 2 Sep 92 23:01:22 GMT
Reply-To: cortesi@informix.com
Organization: Informix Software, Inc.

In article <9448@emory.mathcs.emory.edu> mm@ssf.pt (Manuel Monteiro) writes:
> I have several ec functions similar to
> 
> f(fgl_pcnt)
>      int fgl_pcnt;
> {
>   ...;
>   char *x = malloc(...);        /* x size is not known in compile time */
>   
>   ...;                          /* calculates x value */
>   
>   /* RETURN x */
>   pushquote(x, strlen(x));
>   doretalloc(1);
>   free( x );                    /* must free x space before returning */
>   return(1);
> }


There is a retquote() function (also retint, retdub, etc etc)
for precisely this purpose -- it copies the value to the 4GL stack
instead of merely pushing the pointer.

In the 4GL 4.1 Supplement manual there is an extensive discussion
of the C-to-4GL API and these functions are documented there.
From: alex@lucas.MREC.AR (Alejandra Perez Weiss)
Newsgroups: comp.databases.informix
Subject: Problems with distributes tables
Date: 3 Sep 92 17:08:05 GMT
Reply-To: alex@lucas.MREC.AR (Alejandra Perez Weiss)
X-Informix-List-ID: <list.1425>

I have a problem trying to access a view which selects from tables
in a remote hosts.

The scenario:
------------

At machine host_1:

	For database db_A
    	user dba_B has select permission with grant option on tab_x and tab_y
    	user usr_C has select permission on the same tables

	Both users have "host_2.mrec.ar" in their .rhosts


At machine host_2:

	For database db_B
		user dba_B is the dba
		user usr_C has connect permission

		user dba_B creates a view 
			the_view as select x.*, y.* 
			from db_A@host_1:tab_x x, db_A@hosts_1:tab_y y
			where x.c1 = y.c1
		and gives select permission to public

	Both users have "host_1.mrec.ar" in their .rhosts


The problem
-----------

When I am user dba_B on host_2, I can select from the view OK
but ...
	when I am user usr_C on host_2, I get the message:

		918 Unexpected data received from remote system

	the manual says "... run your network diagnostics ..."

	I did, and everything seems to be right.
and ...
	a core file corresponding to sqlturbo appears in the home
	directory of usr_C on host_1


Any ideas ?

---
Maria Alejandra Perez Weiss              alex@lucas.mrec.ar
PNUD - Min.Rel.Ext. y Culto              alex%lucas.mrec.ar@uunet.uu.net
Buenos Aires - Argentina                 ...!uunet!atina!lucas!alex
Newsgroups: comp.databases.informix