Threads from 1991
Re: C-ISAM error -22
>I am executing the following sql statement: > > select transaction,serial_no > from oldflow > where trans_date >"91.08.31" > into temp t1 > >and getting the following error after selecting approximately 15 MB of >data: > > -246: Could not do an indexed read to get the …
Error in sql
Ellen, I may be the only one listening today, and the what I'm saying you may have already researched. But here goes.... Have you changed the ulimit parameter? The ulimit parameter could be preventing you from accessing/writing a file larger then 15MB. See ulimit in your syst…
C-ISAM error -22
I am executing the following sql statement: select transaction,serial_no from oldflow where trans_date >"91.08.31" into temp t1 and getting the following error after selecting approximately 15 MB of data: -246: Could not do an indexed read to get the next row. …
Re: Some Miscellaneous Questions on 4GL
Path: emory!europa.asd.contel.com!darwin.sura.net!jvnc.net!yale.edu!think.com!sdd.hp.com!hplabs!pyramid!infmx!jacob From: jacob@informix.com (Jacob Salomon) Newsgroups: comp.databases.informix Keywords: informix scroll cursor Message-ID: <1991Dec26.205827.14561@informix.com> Date…
Re: 589 error
>> From: "Scott F. Ford" <uunet!oregon.wvus.org!sford> >> To: informix-list@rmy.emory.edu >> Subject: 589 error >> Cc: sford@mark.wvus.org >> X-Informix-List-Id: <list.722> >> >> Here's another one gang.. >> >> ever heard of a -589 error? This isn't in any book I've ever seen. >…
589 error
Here's another one gang.. ever heard of a -589 error? This isn't in any book I've ever seen. We're on a Unisys 6000/70, /80 TCP-IP network utilizing ISTAR. We get this when trying to update a remote engine's data base (4.1 online). Thanks in advance for any info leading to th…
Some Miscellaneous Questions on 4GL
Path: emory!att!cbnews!mvctm From: mvctm@cbnews.cb.att.com (carl.t.mosley) Newsgroups: comp.databases.informix Keywords: informix Message-ID: <1991Dec26.161921.9278@cbnews.cb.att.com> Date: 26 Dec 91 16:19:21 GMT Organization: AT&T Bell Laboratories I have some questions on writ…
Overlays for MS-DOS Informix
Path: emory!sol.ctr.columbia.edu!zaphod.mps.ohio-state.edu!hobbes.physics.uiowa.edu!news.iastate.edu!sharkey!wyn386!wybbs!daver From: daver@wybbs.mi.org (David Rutkowski) Newsgroups: comp.databases.informix Message-ID: <1991Dec25.121653.23213@wybbs.mi.org> Date: 25 Dec 91 12:16:5…
Re: DOS/MS-Windows 4GL front ends
Path: emory!samsung!think.com!zaphod.mps.ohio-state.edu!uwm.edu!psuvax1!rutgers!ub!dsinc!gvlf3.gvl.unisys.com!lgnp1.ls.com!candle!root From: root@candle.uucp (Bruce Momjian) Newsgroups: comp.databases.informix Message-ID: <1991Dec24.202544.690@candle.uucp> Date: 24 Dec 91 20:25:4…
Passing information from INFORMIX/SQL forms to variable
I am running the INFORMIX/SQL forms from 4GL program as follows. This form is used to find the information from inventory program. Once the user exits from this form then I would like to store some information into a variable that I would like to display in the 4gl form. Is this …
Handling interrupts in INFORMIX/4GL reports
I am printing reports on screen using 4GL reports. I used the PAUSE command to continue to next page. How would I handle the interrupts (CTRL-C) in reports? Thanks in advance. Ruchi.…
decimal type in informix.
Path: emory!swrinde!elroy.jpl.nasa.gov!ucla-cs!ucla-ma!luna!edward From: edward@luna.math.ucla.edu (Edward Dergharapetian) Newsgroups: comp.databases.informix Message-ID: <1991Dec23.223347.21304@math.ucla.edu> Date: 23 Dec 91 22:33:47 GMT Sender: news@math.ucla.edu Organization: …
Re: START REPORT TO PIPE
Quoting John Baker, Lex-Blue Grass Army Depot... > > 1) There is a known bug with 4GL version 4.00 involving the output of a > report routine to the MORE command (you get double spacing). If you > try coding "START REPORT rpt_name TO PIPE more", the output will be all > …
Re: Direct Unload to Tape Drives
jkwajee@gmuvax2.gmu.edu (James A. Kolodziej) writes - > we need to unload large database tables to perform various system admin > functions. We usually can go to disk then reload from the disk file later. > > However, some of our tables are too big to dump to the available disk…
START REPORT TO PIPE
Hello, HELP! I need answers to two questions regarding the report routine of 4GL: 1) There is a known bug with 4GL version 4.00 involving the output of a report routine to the MORE command (you get double spacing). If you try coding "START REPORT rpt_name TO PIPE more",…
PC <-> Informix SUMMARY
Path: emory!wupost!spool.mu.edu!munnari.oz.au!metro!usage!sserve!prog2!jch From: jch@prog2.cs.adfa.oz.au (Jeff Howard) Newsgroups: comp.databases.informix Keywords: Visual Basic PC Informix Message-ID: <1991Dec23.034744.13525@sserve.cc.adfa.oz.au> Date: 23 Dec 91 03:47:44 GMT Sen…
Re: Help for test the printer
Path: emory!samsung!nstar!ka3ovk!irscscm!bogart!mfaurot From: mfaurot@bogart.uucp (Michael Faurot) Newsgroups: comp.databases.informix Summary: Why not let the Unix spooler handle it? Message-ID: <1991Dec21.173718.20202@bogart.uucp> Date: 21 Dec 91 17:37:18 GMT References: <4810@…
Direct Unload to Tape Drives
Path: emory!wupost!darwin.sura.net!haven.umd.edu!umbc3.umbc.edu!gmuvax2!jkwajee From: jkwajee@gmuvax2.gmu.edu (James A. Kolodziej) Newsgroups: comp.databases.informix Keywords: large database dump / restore Message-ID: <1991Dec21.194347.13511@gmuvax2.gmu.edu> Date: 21 Dec 91 19:4…
DOS/MS-Windows 4GL front ends
Path: emory!swrinde!cs.utexas.edu!usc!rutgers!ub!dsinc!gvlf3.gvl.unisys.com!lgnp1.ls.com!candle!root From: root@candle.uucp (Bruce Momjian) Newsgroups: comp.databases.informix Message-ID: <1991Dec20.213752.14383@candle.uucp> Date: 20 Dec 91 21:37:52 GMT Organization: private syst…
How portable is Informix compiled code?
Path: emory!swrinde!cs.utexas.edu!usc!rutgers!ub!dsinc!gvlf3.gvl.unisys.com!lgnp1.ls.com!candle!root From: root@candle.uucp (Bruce Momjian) Newsgroups: comp.databases.informix Message-ID: <1991Dec20.213111.14249@candle.uucp> Date: 20 Dec 91 21:31:11 GMT Organization: private syst…
Re: Help for test the printer
Path: emory!walt From: walt@mathcs.emory.edu (Walt Hultgren {rmy}) Newsgroups: comp.databases.informix Message-ID: <8322@emory.mathcs.emory.edu> Date: 20 Dec 91 20:25:47 GMT References: <4810@mtecv2.mty.itesm.mx> <1585@das13.snide.com> Organization: Emory University In article <…
Re: What is this error?
Path: emory!swrinde!elroy.jpl.nasa.gov!sdd.hp.com!hplabs!pyramid!infmx!news From: cortesi@informix.com (David Cortesi) Newsgroups: comp.databases.informix Message-ID: <1991Dec13.195514.10882@informix.com> Date: 13 Dec 91 19:55:14 GMT References: <1991Dec13.171848.7705@informix.co…
PATH problems
In reference to RUCHI's message I'm not sure I can answer properly, or that what I suggest you haven't already tried but here goes.... >>>We are running INFORMIX/SE. I have a billing database which has >>>4gl files in directory /u/ruchi/billing and also the form files. >>>The fi…
Re: What is this error?
Path: emory!swrinde!elroy.jpl.nasa.gov!sdd.hp.com!hplabs!pyramid!infmx!johnl From: johnl@informix.com (Jonathan Leffler) Newsgroups: comp.databases.informix Message-ID: <1991Dec13.171848.7705@informix.com> Date: 13 Dec 91 17:18:48 GMT References: <1991Dec11.115229.13125@dircon.co…
Error -522
Path: emory!wupost!cs.utexas.edu!sdd.hp.com!hplabs!pyramid!infmx!billd From: billd@infmx.informix.com (William Daul) Newsgroups: comp.databases.informix Message-ID: <1991Dec13.072057.10092@informix.com> Date: 13 Dec 91 07:20:57 GMT Sender: news@informix.com (Usenet News) Organiza…
Re: Open join in SQL?
Path: emory!swrinde!sdd.hp.com!hplabs!pyramid!infmx!johnl From: johnl@informix.com (Jonathan Leffler) Newsgroups: comp.databases.informix Summary: answer = outer join, but be careful Message-ID: <1991Dec12.135511.5617@informix.com> Date: 12 Dec 91 13:55:11 GMT References: <629800…
Re: Help for test the printer
Path: emory!swrinde!zaphod.mps.ohio-state.edu!unix.cis.pitt.edu!dsinc!das13!dave From: dave@das13.snide.com (Dave Snyder) Newsgroups: comp.databases.informix Message-ID: <1585@das13.snide.com> Date: 19 Dec 91 03:43:18 GMT References: <4810@mtecv2.mty.itesm.mx> Organization: Snide…
Resources for Development in ACE
We are looking for information to help get up the learning curve when developing reports in ACE--books, etc. Any suggestions?…
Informix/SE
We are running INFORMIX/SE. I have a billing database which has 4gl files in directory /u/ruchi/billing and also the form files. The files are growing and I would like to divide them in several directories. So, I created the following directories and it has following files. I can…
Altering privs (sorry, mailed wrong one)
I write > I haven't embarrassed myself in public for a little while, so how 'bout and promptly mail the wrong lump of text. ARGHHH !!! Sorry folks :-( RUCHI@CFRVM.CFR.USF.edu writes: > I have number of tables that I would like to give access to users. Currently, > I am us…
Re: Windstar development tools.
Path: emory!swrinde!zaphod.mps.ohio-state.edu!unix.cis.pitt.edu!dsinc!das13!dave From: dave@das13.snide.com (Dave Snyder) Newsgroups: comp.databases.informix Message-ID: <1584@das13.snide.com> Date: 19 Dec 91 03:34:58 GMT References: <4425@krafla.rhi.hi.is> Organization: Snide In…
Help for test the printer
Path: emory!wupost!cs.utexas.edu!tamsun!mtecv2!root From: cluis@mtecv2.mty.itesm.mx Newsgroups: comp.databases.informix Message-ID: <4810@mtecv2.mty.itesm.mx> Date: 18 Dec 91 21:45:00 GMT Sender: root@mtecv2.mty.itesm.mx Reply-To: cluis@mtecv2.mty.itesm.mx Dear Friends : Has…
Windstar development tools.
Path: emory!europa.asd.contel.com!darwin.sura.net!Sirius.dfn.de!math.fu-berlin.de!uniol!unido!mcsun!news.funet.fi!sunic!seunet!isgate!krafla!gaukur From: gaukur@rhi.hi.is (Kristjan Gaukur Kristjansson) Newsgroups: comp.databases.informix Message-ID: <4425@krafla.rhi.hi.is> Date: …
Altering privileges on lots of tables
RUCHI@CFRVM.CFR.USF.edu writes: > I have number of tables that I would like to give access to users. Currently, > I am using INFORMIX/SQL to do this one at a time. Is there anyway I can > run this in a group if I have it in a file? I haven't embarrassed myself in public for a l…
Re: Granting the privileges to users on number of tables
> > I have number of tables that I would like to give access to users. Currently, > I am using INFORMIX/SQL to do this one at a time. Is there anyway I can > run this in a group if I have it in a file? Try the following bourne shell script ------------Cut Here------------- #!/bi…
Large Database (9 Gigabyte). Big Insert 3 MB possible?
Path: emory!att!linac!pacific.mps.ohio-state.edu!zaphod.mps.ohio-state.edu!wupost!uunet!math.fu-berlin.de!NewsServ!reseq!guug!ixos!mars From: mars@ixos.de (Martin Stein) Newsgroups: comp.databases.informix Keywords: big insert large database size Message-ID: <1407@ixos.de> Date: …
Granting the privileges to users on number of tables
I have number of tables that I would like to give access to users. Currently, I am using INFORMIX/SQL to do this one at a time. Is there anyway I can run this in a group if I have it in a file? By the way, I like to understand the table authorization "su-id--" that is generated …
Re: Format of database logfile needed
The format of Informix's SE Transaction Log file is defined on page D-10/12 of the C-ISAM Manual. I think it would be foolish of me to iterate the contents of these pages due to Informix's copywrite! However, the documentation is reasonably comprehensive an…
Re: unloading smallfloat-data
Path: emory!sol.ctr.columbia.edu!hamblin.math.byu.edu!hellgate.utah.edu!cs.utexas.edu!qt.cs.utexas.edu!yale.edu!think.com!rpi!ispd-newsserver!kodak!music!amiano From: amiano@music.Kodak.Com (Mitch Amiano) Newsgroups: comp.databases.informix Message-ID: <1991Dec16.172139.18319@kod…
Re: What is this error?
Path: emory!sol.ctr.columbia.edu!zaphod.mps.ohio-state.edu!qt.cs.utexas.edu!cs.utexas.edu!uunet!psinntp!gdc!nms!bergquis From: bergquis@nms.gdc.com (Brett Bergquist) Newsgroups: comp.databases.informix Message-ID: <434@wimpy.nms.gdc.com> Date: 12 Dec 91 14:42:09 GMT References: <…
Re: i4gl question. (fwd)
Gauker, Per your question about moving to Informix or cobol I received this from Jennifer Hayes at Informix. I don't know anything about the product but if it works it seems like it could give you the best of both worlds. A simple translation of the Cobol while still allowing …
Re: USER function
> How about > > LET cur_user = fgl_getenv("LOGNAME") Yes, that's a possibility. However, if your set-up is such that users can change the environment before running the application, you can't count on the value of LOGNAME. Since our applications can be invoked from the s…
Re: USER function
> > > You may want to use a C function which picks up the LOGNAME from the > > environment instead. 4.1 has a function like this built in to 4GL. > > Is 4.1 supposed to let you do something like the following? > > DEFINE cur_user CHAR(8) > > LET cur_user = USER # or m…
Format of database logfile needed
Path: emory!wupost!cs.utexas.edu!uunet!psinntp!gdc!nms!bergquis From: bergquis@nms.gdc.com (Brett Bergquist) Newsgroups: comp.databases.informix Message-ID: <433@wimpy.nms.gdc.com> Date: 12 Dec 91 12:18:43 GMT Organization: General DataComm, Middlebury CT Does anyone know the fo…
Re: unloading smallfloat-data
Path: emory!europa.asd.contel.com!darwin.sura.net!wupost!zaphod.mps.ohio-state.edu!unix.cis.pitt.edu!pitt!darth!investor.pgh.pa.us!rbp From: rbp@investor.pgh.pa.us (Bob Peirce #305) Newsgroups: comp.databases.informix Message-ID: <1991Dec13.134143.5189@investor.pgh.pa.us> Date: 1…
Re: Open join in SQL?
Path: emory!swrinde!sdd.hp.com!hp-col!col!judym From: judym@col.hp.com (Judy Miller) Newsgroups: comp.databases.informix Message-ID: <62980005@col.hp.com> Date: 13 Dec 91 17:22:29 GMT References: <62980004@col.hp.com> Organization: HP Colorado Springs Division >How do you do an …
Re: USER function
> > I am using the USER function in Informix/4gl program but get an error > when I compile it. Is this a bug? or is it not functional in 4GL ? > > DECLARE init CURSOR FOR SELECT * from Table_a where id = USER > > Thanks. > Ruchi. > I have seen the following function being used f…
Re: I4GL-mode for GNU Emacs?
Path: emory!sol.ctr.columbia.edu!cunixf.cc.columbia.edu!shimmin From: shimmin@cunixf.cc.columbia.edu (John Shimmin) Newsgroups: comp.databases.informix Message-ID: <1991Dec13.213542.19042@cunixf.cc.columbia.edu> Date: 13 Dec 91 21:35:42 GMT References: <79@lexis.lexis.hi.is> Repl…
Re: Front_end screen design
Path: emory!att!att!mcdchg!marcal!marc From: marc@marcal.uucp (Marc Veeneman) Newsgroups: comp.databases.informix Message-ID: <1991Dec13.142002.13952@marcal.uucp> Date: 13 Dec 91 14:20:02 GMT References: <1991Dec12.235116.18681@seas.gwu.edu> Organization: Marcal Systems Corporati…
Need a particular database
Path: emory!sol.ctr.columbia.edu!spool.mu.edu!tulane!rouge!JOHNSON@EA.USL.EDU From: johnson@EA.USL.EDU Newsgroups: comp.databases,comp.databases.informix Message-ID: <009530BA.FD2B2040@EA.USL.EDU> Date: 13 Dec 91 14:58:39 GMT Sender: anon@usl.edu (Anonymous NNTP Posting) Reply-To…
Wingz print/plot question
Path: emory!att!linac!uwm.edu!cs.utexas.edu!sdd.hp.com!hp-cv!hp-pcd!hpspkla!mills From: mills@hpspkla.spk.hp.com (Terence J. Mills) Newsgroups: comp.databases.informix Message-ID: <20490003@hpspkla.spk.hp.com> Date: 12 Dec 91 23:07:27 GMT Organization: Hewlett Packard Company, Sp…
PC <-> Informix
Path: emory!samsung!munnari.oz.au!manuel!sserve!cserve.cs.adfa.oz.au!jch From: jch@cserve.cs.adfa.oz.au Newsgroups: comp.databases.informix Message-ID: <1991Dec13.021444.27191@sserve.cc.adfa.oz.au> Date: 13 Dec 91 02:14:44 GMT Sender: news@sserve.cc.adfa.oz.au Reply-To: jch@cserv…
Front_end screen design
Path: emory!swrinde!cs.utexas.edu!wupost!uunet!seas.gwu.edu!saud From: saud@seas.gwu.edu (Wanes Saud) Newsgroups: comp.databases.informix Message-ID: <1991Dec12.235116.18681@seas.gwu.edu> Date: 12 Dec 91 23:51:16 GMT Sender: news@seas.gwu.edu Organization: George Washington Unive…
Followup to Multiple Master/Detail Relationships in ACE (LONG)
Path: emory!wupost!zaphod.mps.ohio-state.edu!sample.eng.ohio-state.edu!purdue!yuma!ccncsu!lamar!sharif From: sharif@lamar.ColoState.EDU (Thomas Abdallah) Newsgroups: comp.databases.informix Message-ID: <19933@ccncsu.ColoState.EDU> Date: 12 Dec 91 20:21:00 GMT Sender: news@ccncsu.…
Small float format problem on unload
Received: from gollum.twg.com by Mercury.TWG.COM id aa25728; 12 Dec 91 14:39 PST From: "Jeff P. Cauhape" <cauhape@TWG.COM> Date: Thu, 12 Dec 91 14:39:07 -0800 Message-Id: <5838.9112122239@gollum.twg.com.twg.com> To: becker@ukh840.med-in.uni-sb.de Subject: Re: unloading smallfloat…
Re: USER function
> You may want to use a C function which picks up the LOGNAME from the > environment instead. 4.1 has a function like this built in to 4GL. Is 4.1 supposed to let you do something like the following? DEFINE cur_user CHAR(8) LET cur_user = USER # or maybe LET cu…
Grouping Master/Detail Relationships in ACE
Path: emory!swrinde!cs.utexas.edu!uunet!boulder!csn!yuma!ccncsu!lamar!sharif From: sharif@lamar.ColoState.EDU (Thomas Abdallah) Newsgroups: comp.databases.informix Message-ID: <19910@ccncsu.ColoState.EDU> Date: 10 Dec 91 21:00:58 GMT Sender: news@ccncsu.ColoState.EDU Organization…
Re: USER function
> >I am using the USER function in Informix/4gl program but get an error >when I compile it. Is this a bug? or is it not functional in 4GL ? > >DECLARE init CURSOR FOR SELECT * from Table_a where id = USER > >Thanks. >Ruchi. The 4.0 reference says you may use the USER keyword in…
USER function
I am using the USER function in Informix/4gl program but get an error when I compile it. Is this a bug? or is it not functional in 4GL ? DECLARE init CURSOR FOR SELECT * from Table_a where id = USER Thanks. Ruchi.…
Clearing table locks
Path: emory!swrinde!zaphod.mps.ohio-state.edu!ncar!csn!cherokee!cherokee!bruce From: bruce@patton.USWest.COM ( Bruce W. Hoylman x5806 ) Newsgroups: comp.databases.informix Message-ID: <BRUCE.91Dec11202149@patton.USWest.COM> Date: 12 Dec 91 03:21:49 GMT Sender: news@cherokee.uswes…
Open join in SQL?
Path: emory!swrinde!elroy.jpl.nasa.gov!sdd.hp.com!hp-col!col!judym From: judym@col.hp.com (Judy Miller) Newsgroups: comp.databases.informix Message-ID: <62980004@col.hp.com> Date: 11 Dec 91 21:23:07 GMT Organization: HP Colorado Springs Division How do you do an "open join" in I…
Multiple Master/Detail Relationships in ACE
Path: emory!att!pacbell.com!ames!ncar!csn!yuma!lamar!sharif From: sharif@lamar.ColoState.EDU (Thomas Abdallah) Newsgroups: comp.databases.informix Message-ID: <1991Dec11.204511.45164@yuma.ACNS.ColoState.EDU> Date: 11 Dec 91 20:45:11 GMT Organization: Colorado State University, Fo…
Re: WINGZ or LOTUS123-UNIX ?
Path: emory!swrinde!zaphod.mps.ohio-state.edu!uakari.primate.wisc.edu!ames!agate!linus!linus!linus!dsr From: dsr@mitre.org (Douglas S. Rand) Newsgroups: comp.databases.informix Message-ID: <DSR.91Dec11143945@chickpea.mitre.org> Date: 11 Dec 91 20:39:45 GMT References: <1991Dec11.…
Re: Error number -522
Quoting Pete Miles (uaa1006@dircon.co.uk): > I've got an ESQL/C program which is trying to UPDATE a row in > the database, but it keeps returning with Error number: -522. > > This number doesn't appear in the manual. Can anyone tell me > what it means? > > I'm using ESQL/C 4.00…
Re: What is this error?
Path: emory!swrinde!cs.utexas.edu!uunet!trac2000!das13!dave From: dave@das13.snide.com (Dave Snyder) Newsgroups: comp.databases.informix Message-ID: <1576@das13.snide.com> Date: 11 Dec 91 18:13:28 GMT References: <1991Dec11.115229.13125@dircon.co.uk> Organization: Snide Inc. - Fo…
WINGZ or LOTUS123-UNIX ?
Path: emory!att!linac!uchinews!gsbsun!jacquier From: jacquier@gsbsun.uchicago.edu (Eric Jacquier (PhD student)) Newsgroups: comp.databases.informix Message-ID: <1991Dec11.154231.1268@midway.uchicago.edu> Date: 11 Dec 91 15:42:31 GMT Sender: news@uchinews.uchicago.edu (News System…
What is this error?
Path: emory!swrinde!zaphod.mps.ohio-state.edu!wupost!uunet!mcsun!uknet!dircon!uaa1006 From: uaa1006@dircon.co.uk (Peter Miles) Newsgroups: comp.databases.informix Message-ID: <1991Dec11.115229.13125@dircon.co.uk> Date: 11 Dec 91 11:52:29 GMT Organization: The Direct Connection, U…
answer Frank Huemme
Frank Huemme writes: >After bringing up the the System, one programm dosn't work properly. >Ok,we dial in via Modem and try to update a table: > >update "tablexxx" ..... > >The errors: >246: Could not do an indexed read to get the next row >107: ISAM Error: record is locked > >H…
I4GL-mode for GNU Emacs?
Path: emory!wupost!think.com!yale.edu!jvnc.net!darwin.sura.net!Sirius.dfn.de!math.fu-berlin.de!unido!mcsun!news.funet.fi!sunic!seunet!isgate!lexis.hi.is!bjorn From: bjorn@lexis.hi.is (Bjorn Svavarsson/100000) Newsgroups: comp.databases.informix Summary: Has any one writen mode fo…
need vendor for isql & r4gl
Path: emory!att!linac!uwm.edu!cs.utexas.edu!swrinde!elroy.jpl.nasa.gov!decwrl!tcomeng!daryl From: daryl@tcomeng.uucp (Daryl Jones) Newsgroups: comp.databases.informix Message-ID: <1991Dec11.065026.9029@tcomeng.uucp> Date: 11 Dec 91 06:50:26 GMT Organization: Telecomm. Engineering…
Re: ESQL/C insert statement problem
Path: emory!swrinde!mips!sdd.hp.com!hplabs!pyramid!infmx!jacob From: jacob@informix.com (Jacob Salomon) Newsgroups: comp.databases.informix Message-ID: <1991Dec10.212731.13207@informix.com> Date: 10 Dec 91 21:27:31 GMT References: <1991Dec05.192501.13636@dircon.co.uk> <1991Dec6.1…
Re: ESQL/C insert statement problem
Path: emory!swrinde!mips!sdd.hp.com!hplabs!pyramid!infmx!jacob From: jacob@informix.com (Jacob Salomon) Newsgroups: comp.databases.informix Summary: Semantic error in ESQL/C Message-ID: <1991Dec10.212029.12845@informix.com> Date: 10 Dec 91 21:20:29 GMT References: <1991Dec05.1925…
Re: RUN 4GL Statement
Path: emory!walt From: walt@mathcs.emory.edu (Walt Hultgren {rmy}) Newsgroups: comp.databases.informix Message-ID: <8296@emory.mathcs.emory.edu> Date: 9 Dec 91 15:41:01 GMT References: <1991Dec6.193733.1373@cbfsb.att.com> <1574@das13.snide.com> Organization: Emory University >In…
C-ISAM isopen default mode
The isbuild() function call invokes open() with O_CREAT set and the mode argument set to 0664. Surely it makes more sense to specify mode 0666 and allow the ultimate control to be in the hands of the umask value ! If anybody knows why Informix do this, can they please tell…
Re: Ansi Mode
Andres Marianovsky writes... > >>Date: Wed, 13 Nov 1991 13:51:38 ARG > >>From: "Andres Marianovsky" <dcfcen!atina!dia!andres> > >>Subject: Ansi Mode > >>X-Informix-List-Id: <list.599> > >> > >>We created a Data Base. We used Ansi Mode, to make it more standard. > >> > >>W…
Re: Copying Programs
Michael Segel writes... > > Tony, > > Uhm, since I am not a laywer, and I don't play one on TV, > IMHO I think your wrong. > > What Dave is saying to do, is that since you have 5 copies of SE, > and only one copy of Compiled 4GL, use the compiled version to > create binaries. Th…
Error -246
Hello members, thats my first posting to this list. Our customer called us via phone that he has have a crash on his HP-Vectra (SCO 3.2.2, Informix-Online) After bringing up the the System, one programm dosn't work properly. Ok,we dial in via Modem and try to update a table: upd…
unloading smallfloat-data
Path: emory!swrinde!cs.utexas.edu!uunet!mcsun!unido!sbsvax!ukh840!becker From: becker@ukh840.med-in.uni-sb.de Newsgroups: comp.databases.informix Message-ID: <14911@sbsvax.cs.uni-sb.de> Date: 9 Dec 91 09:13:52 GMT Sender: news@sbsvax.cs.uni-sb.de Problems unloading smallfloat - …
Re: RUN 4GL Statement
Path: emory!wupost!zaphod.mps.ohio-state.edu!unix.cis.pitt.edu!dsinc!das13!dave From: dave@das13.snide.com (Dave Snyder) Newsgroups: comp.databases.informix Message-ID: <1574@das13.snide.com> Date: 8 Dec 91 16:55:20 GMT References: <1991Dec6.193733.1373@cbfsb.att.com> Organizatio…
Wingz Hyperscript for beginners
I am trying to teach myself Wingz Hyperscript but find the HyperScript Manual as supplied by Informix not the easiest of tutorials. Does any of you know of a more friendly tutorial (with sample scripts PLEASE)? -- Gert Blij +27/(0)21/933 4400 Shoprite Holdings …
Re: Forms, how to inform users of choices during data entry
Path: emory!ducvax.auburn.edu!darwin.sura.net!gatech!rutgers!ub!zaphod.mps.ohio-state.edu!casbah.acns.nwu.edu!nucsrl!tellab5!odgate!mike From: mike@odgate.odesta.com (Mike J. Kelly) Newsgroups: comp.databases.informix Keywords: forms Message-ID: <1991Dec5.185748.21249@odgate.odes…
Re: ESQL/C insert statement problem
Path: emory!sol.ctr.columbia.edu!zaphod.mps.ohio-state.edu!sdd.hp.com!hplabs!pyramid!infmx!johnl From: johnl@informix.com (Jonathan Leffler) Newsgroups: comp.databases.informix Summary: There is a bug in the manual Message-ID: <1991Dec6.174109.10282@informix.com> Date: 6 Dec 91 1…
Re: Hung Locks
there is a *.lok file in the *.dbs directory, it stores some records make the table locked, try to make it a null file, I forgot how to do it, I did it once, something like a cp /etc/null *.lok or cat /etc/null > *.lok, just try to make it null, and everything will be unlock. Ji…
Informix on a PC - problem 2
Make that _two_ urgent problems... As I mentioned in the last note, my PC is on a network. The other problem I have is accessing the Unix server using I-net. "remsql" starts ok, but then "fglgo" exits with "error number -408" "an invalid message type received from the database…
Informix and Microsoft C 6.0
I have a rather urgent problem... I'm setting up Informix on a DOS-Unix network. I need to compile a new "fglgo" p-code runner on the DOS system, but I am using Microsoft C 6.0 Of course the manuals say that only C versions 5.0/5.1 are supported, but I don't have access to them…
RUN 4GL Statement
Path: emory!att!cbnewsh!cbnewse!cbnewsd!cbfsb!cbnewsb.cb.att.com!dab From: dab@cbnewsb.cb.att.com (david.a.berk) Newsgroups: comp.databases.informix Message-ID: <1991Dec6.193733.1373@cbfsb.att.com> Date: 6 Dec 91 19:37:33 GMT Sender: news@cbfsb.att.com Organization: AT&T Bell Lab…
Re: ESQL/C insert statement problem
Path: emory!samsung!uunet!trac2000!das13!dave From: dave@das13.snide.com (Dave Snyder) Newsgroups: comp.databases.informix Message-ID: <1559@das13.snide.com> Date: 6 Dec 91 16:31:08 GMT References: <1991Dec05.192501.13636@dircon.co.uk> Organization: Snide Inc. - Folcroft, PA In …
Re: how to use multiple tables on one screen(add'l info)
Path: emory!sol.ctr.columbia.edu!samsung!uunet!trac2000!das13!dave From: dave@das13.snide.com (Dave Snyder) Newsgroups: comp.databases.informix Keywords: tables Message-ID: <1551@das13.snide.com> Date: 6 Dec 91 03:19:59 GMT References: <jc.691956868@tau> <jc.691964328@tau> Organi…
Hung Locks
Environment - Informix 4.0 Standard Engine I have a problem which has coincidentally occurred at two of my sites at nearly the same time (different applications and databases). It appears that a table has become locked out of the rest of the world, such that no one can access it…
Xenix Operating System.
Friends of Xenix: This query is not a direct Informix problem, however, it is related in that without solving our problem we can not use our informix programs. We are using an Intel 310 Multiuser system running under Intel X…
Representation of float and smallfloat in ISQL-SE - DOS
I have a DOS application which uses C-ISAM to store "C" record structures. Most of the C record structures contain C "double" types. I wish to access this C-ISAM data through ISQL-SE but, when I create and run the corresponding SQL schemas, I notice that ISQL is converting the "f…
I4GL-mode for GNU Emacs
Hi every one! I am wondering if some one has writen I4GL-mode for GNU Emacs. If so I would like to know how to get a copy of it. Thanks in advance. -- Bjorn Svavarsson, Institute of Lexicography Tel. 354-1-694438 University of Iceland Internet: bjorn@lexis.hi.is …
Macintosh Client -> Informix (mainframe) database?
Path: emory!att!linac!uwm.edu!wupost!sdd.hp.com!elroy.jpl.nasa.gov!nntp-server.caltech.edu!flowers From: flowers@caltech.edu (Dave Flowers) Newsgroups: comp.databases,comp.databases.informix,comp.sys.mac.apps Message-ID: <flowers.691984106@delphi.bio.caltech.edu> Date: 6 Dec 91 0…
ESQL/C insert statement problem
Path: emory!wupost!uunet!mcsun!uknet!dircon!uaa1006 From: uaa1006@dircon.co.uk (Peter Miles) Newsgroups: comp.databases.informix Message-ID: <1991Dec05.192501.13636@dircon.co.uk> Date: 5 Dec 91 19:25:01 GMT Organization: The Direct Connection, UK The manual for Informix-Esql/C (…
Re: how to use multiple tables on one screen(add'l info)
Path: emory!wupost!cs.utexas.edu!swrinde!mips!tau!jc From: jc@mips.com (J.C. Webber III) Newsgroups: comp.databases.informix Keywords: tables Message-ID: <jc.691964328@tau> Date: 5 Dec 91 20:18:48 GMT References: <jc.691956868@tau> Sender: news@mips.COM Nntp-Posting-Host: tau.mip…
Spanning transactions across machines (fwd)
Corinne Bruce writes: > >I have YET another question... > >When our conversion (from IBM to Unix/Informix 4GL) is complete, our "database" >will actually consist of several databases, spanning 4 machines and as many >On-Line engines. Organizationally, the application is extremel…
how to use multiple tables on one screen
Path: emory!swrinde!mips!tau!jc From: jc@mips.com (J.C. Webber III) Newsgroups: comp.databases.informix Keywords: tables Message-ID: <jc.691956868@tau> Date: 5 Dec 91 18:14:28 GMT Sender: news@mips.COM Nntp-Posting-Host: tau.mips.com I'm setting up a data entry screen that cross…
perl with informix access?
Path: emory!sol.ctr.columbia.edu!zaphod.mps.ohio-state.edu!qt.cs.utexas.edu!cs.utexas.edu!uunet!mcsun!unido!sbsvax!ukh840!becker From: becker@ukh840.med-in.uni-sb.de Newsgroups: comp.databases.informix Message-ID: <14849@sbsvax.cs.uni-sb.de> Date: 5 Dec 91 05:40:29 GMT Sender: ne…
Re: Forms, how to inform users of choices during data entry
Path: emory!wupost!uunet!news.larc.nasa.gov!teb.larc.nasa.gov!caywood From: caywood@teb.larc.nasa.gov (John Caywood) Newsgroups: comp.databases.informix Keywords: forms Message-ID: <1991Dec4.165400.1152@news.larc.nasa.gov> Date: 4 Dec 91 16:54:00 GMT References: <769@skyking.UUCP…
Re: Question: get to next row in INPUT ARRAY
Path: emory!sol.ctr.columbia.edu!spool.mu.edu!agate!dog.ee.lbl.gov!nosc!crash!ipars!scotto From: scotto@ipars.cts.com (Scott O'Connell) Newsgroups: comp.databases.informix Message-ID: <1991Dec4.071106.21456@ipars.cts.com> Date: 4 Dec 91 07:11:06 GMT References: <1991Dec2.191316.1…
Ansi Mode
I sent the following message some weeks ago. I didn't receive any answer. Why? Informix, are you listening? Thanks. >>Date: Wed, 13 Nov 1991 13:51:38 ARG >>From: "Andres Marianovsky" <dcfcen!atina!dia!andres> >>Subject: Ansi Mode >>X-Informix-List-Id: <list.599> >> >>W…
Forms, how to inform users of choices during data entry
Path: emory!sol.ctr.columbia.edu!spool.mu.edu!mips!skyking!jc From: jc@skyking.UUCP (J.C. Webber III) Newsgroups: comp.databases.informix Keywords: forms Message-ID: <769@skyking.UUCP> Date: 4 Dec 91 01:53:33 GMT Organization: Skyking Inc., San Jose CA USA I am attempting to set…
Re: Question: get to next row in INPUT ARRAY
Path: emory!swrinde!cs.utexas.edu!uunet!ddssuprs!lpc From: lpc@ddssuprs.UUCP (Luis Caamano) Newsgroups: comp.databases.informix Message-ID: <1991Dec03.153629.20164@ddssuprs.UUCP> Date: 3 Dec 91 15:36:29 GMT References: <1991Dec2.191316.12675@odin.corp.sgi.com> Organization: Dicke…
4GL Error -410 Revisited
As promised, this is an update on the problem with 4GL Error -410 (Prepare statement failed or was not executed) as it relates to the AT&T 3B2 600/G platform (may be applicable elsewhere - read on!). This insidious error continues to occur, but at long last the specific circumst…
Re: SQL Query
Two similar, but different, solutions to the problem --- >TABLE A TABLE B >----------------------- >project_no project_no >________________________ > 1 1 > 2 - > 3 3 [...] > is there anyway I can do my query to find the project_no fro…
Re: Indexing problem with On-Line
> > Hi there. I have an amazing problem with Informix On-Line version 4.00.UE2. > > When two programs try to insert a row in the same table (within a > transaction ) and the one that has the greater value in a column with a > unique index, inserts his row first, then the other on…
Better speed w/large C-ISAM files
Path: emory!swrinde!cs.utexas.edu!uunet!decwrl!sgi!cdp!scott From: scott@igc.org (Scott Weikart) Newsgroups: comp.databases.informix Message-ID: <1561600004@igc.org> Date: 29 Nov 91 22:48:00 GMT Sender: Notesfile to Usenet Gateway <notes@igc.org> Nf-ID: #N:cdp:1561600004:004:2955…
Re: umask(1), shell wrappers.
>> From uunet!rmy.emory.edu!informix-list-owner Mon Dec 2 04:16:16 1991 >> From: uunet!bnr.co.uk!A.Heskett >> Subject: umask(1), shell wrappers. >> To: informix-list@rmy.emory.edu (Emory U. Informix List) >> >> (discussion about using umask to control file permissions on report …
Re: Copying Programs
Quoting Tony Lacy-Thompson... > > Surely you're not suggesting that John defrauds Informix by > infringeing our copyright? The rules are very clear: you MUST have an > Informix licence (either Development or Runtime) for EVERY machine on > which you wish to run our software. Even…
Indexing problem with On-Line
{ Hi there. I have an amazing problem with Informix On-Line version 4.00.UE2. When two programs try to insert a row in the same table (within a transaction ) and the one that has the greater value in a column with a unique index, inserts his row first, then the other one abort…
Re: Reversal of Records
Quoting Will Hartung (uunet!la4gen!villy): > You'll notice that the records are in the order of ENTRY, not the order > of the data (assuming the your 1,2,3,4 is not your serial field). > If you look at the SERIAL field data on those records, they probably read > something like: …
umask(1), shell wrappers.
Charles Lei writes (quoting Jeffrey Lawhorn) : > > A simpler answer is to write a shell script along the lines of: > > > > > #!/bin/sh > > > umask 0660 > > > your_4gl_app This is very handy for setting up the environment for users who don't normally use informix, or don't use t…
what does "object-oriented" mean
Path: emory!att!linac!uwm.edu!cs.utexas.edu!wupost!micro-heart-of-gold.mit.edu!uw-beaver!ubc-cs!alberta!access.usask.ca!ccu.umanitoba.ca!ciit85.ciit.nrc.ca!brandonu.ca!$jiangl From: $jiangl@brandonu.ca Newsgroups: comp.databases.informix Message-ID: <1991Nov29.110802.1103@brandon…
"log full", "no more locks" errors
Path: emory!swrinde!cs.utexas.edu!usc!orion.oac.uci.edu!ucivax!george From: george@brooks.ics.uci.edu (George Herson) Newsgroups: comp.databases.informix Message-ID: <2936F200.22922@ics.uci.edu> Date: 30 Nov 91 02:05:52 GMT Reply-To: george@ics.uci.edu (George Herson) Organizatio…
C-ISAM question
Path: emory!swrinde!cs.utexas.edu!uunet!shearson.com!press!fsmadja From: fsmadja@figment.shearson.com (Frank Smadja) Newsgroups: comp.databases.informix Message-ID: <FSMADJA.91Nov27123846@figment.shearson.com> Date: 27 Nov 91 18:38:46 GMT References: <1991Nov25.045603.8960@dbsm.o…
Re: Report - saving into file
> ... Stuff deleted ... > A simpler answer is to write a shell script along the lines of: > > > #!/bin/sh > > umask 0660 > > your_4gl_app > > This will have your_4gl_app create it's files with the group write > permission turned on. Then anyone in the same group will be able to…
Displaying blobs on a PC
Are you running a vanilla pc, or windows 3.0 on the pc? Where do you want to trigger the program from, the 386 server or the PC? There are many public domain programs that display graphics held in various formats (tiff, et.al.) If you are just running from the DOS prompt, one …
Re: Copying Programs
Quoting David A. Snyder @ Snide Inc. - Folcroft, PA (Dave.Snyder@snide.com): > > Quoting John Baker Depot Sys Mgt Br... > > > > YES I certainly agree with you Tony. Perform is the wrong tool. What my > > users really need is a 4GL array. Unfortunately, the 4GL package is not >…
Re: File/function info
Path: emory!swrinde!zaphod.mps.ohio-state.edu!sdd.hp.com!hplabs!pyramid!infmx!johnl From: johnl@informix.com (Jonathan Leffler) Newsgroups: comp.databases.informix Message-ID: <1991Nov27.141812.3485@informix.com> Date: 27 Nov 91 14:18:12 GMT References: <1991Nov26.172748.176@wvus…
InformixLink and TechNotes
To: <uunet!lexington-emh2.army.mil!jbaker> John Baker Depot Sys Mgt Br ================ From uunet!rmy.emory.edu!informix-list-owner Tue Nov 26 18:44:36 1991 Date: Tue, 26 Nov 91 12:00:05 EST > Does anyone subscribe to InformixLink? If so, can you tell us how useful…
Re: File/function info
Path: emory!swrinde!cs.utexas.edu!uunet!mcsun!uknet!stl!th From: th@stl.stc.co.uk (Tony Heskett) Newsgroups: comp.databases.informix Summary: Use revision control Keywords: SCCS RCS Message-ID: <5176@stl.co.uk> Date: 27 Nov 91 20:12:19 GMT References: <1991Nov26.172748.176@wvus.o…
[Root: [Cheryl Gross: Program names back to calling process while doing a perform screen]]
Subject: Program names back to calling process while doing a perform screen In Response to the message from cbruce@wvus.org about returning functions names called from 4GL. I don't know if 4GL screens are like perform screens in 2.10 but here is how we have done what you are a…
Re: SQL Query
> When I user outer join then it says that it found 3 rows which is correct. > But is there anyway I can do my query to find the project_no from TABLE A > that is not in the TABLE B? So, my result should say only one row found > from TABLE A. Try something like this: select *…
Public Domainn Relational Database Managers
Path: emory!samsung!zaphod.mps.ohio-state.edu!think.com!ames!agate!dog.ee.lbl.gov!nosc!cod!ggreen From: ggreen@cod.NOSC.MIL (George W. Green) Newsgroups: comp.unix.misc,comp.databases.informix Keywords: database, relational Message-ID: <3410@cod.NOSC.MIL> Date: 26 Nov 91 18:06:42…
Perform record ordering
In respect of John Baker's perform problem: this seems sufficiently dirty it just might work ... This is sorta pseudo-SQL, BTW. Flames to the address at the very bottom. * create table apps_table ( col1 char(3), col2 char(77), time_order seri…
Re: Reversal of Records
> to get the desired results. I thought I read somewhere that a Serial > column cannot have a Dups index (after all, it would not be possible to > have duplicates on a Serial column). Is this now a restriction in version > 4.00? Nevertheless, our version 2.10 lets me declare a…
Re: SQL Query
RUCHI@CFRVM.CFR.USF.edu writes: > I have two tables that joines them by project_no. Following are two tables > with its values. > > TABLE A TABLE B > ----------------------- > project_no project_no > ________________________ > 1 1 > 2 - > 3 …
SQL Query
----- Begin Included Message ----- From: RUCHI@CFRVM.CFR.USF.EDU To: informix-list@rmy.emory.edu Subject: SQL Query X-Informix-List-Id: <list.655> Status: R I have two tables that joines them by project_no. Following are two tables with its values. TABLE A TABLE B -------…
Re: Report - saving into file
>>I am generating reports from INFORMIX/4GL ans saving into file called inv.out. >>This file is under /u/ruchi/billing.report. The group has permission to rwx >>to a subdirectory billing.report. When A user creates >>inv.out to generate report then he can use the same file over a…
Re: SQL Query
>I have two tables that joines them by project_no. Following are two tables >with its values. > >TABLE A TABLE B >----------------------- >project_no project_no >________________________ > 1 1 > 2 - > 3 3 > >When I user outer join then…
Copying Programs
Quoting David A. Snyder @ Snide Inc. - Folcroft, PA (Dave.Snyder@snide.com): > > Quoting John Baker Depot Sys Mgt Br... > > > > YES I certainly agree with you Tony. Perform is the wrong tool. What my > > users really need is a 4GL array. Unfortunately, the 4GL package is not >…
Re: Report - saving into file
Greg Bryan <gbryan@ssf-sys.dhl.com> writes: > > [ ... multiple users cannot write to file "inv.out" ... ] > > > >Thanks. Ruchi. > > Ruchi - > > Write a C function to call chmod() and fix the permissions > on the file. Link the C function into your 4GL program, and > call it …
Re: Keypad Application/Numeric Mode
Path: emory!swrinde!elroy.jpl.nasa.gov!ames!daffodil!cs.odu.edu!bander From: bander@cs.odu.edu (Jim Bander) Newsgroups: comp.databases.informix Summary: Keep 2 termcaps Message-ID: <1991Nov27.043056.12430@cs.odu.edu> Date: 27 Nov 91 04:30:56 GMT References: <1991Nov20.225504.2682…
Re: INFORMIX e-mail address
Path: emory!swrinde!elroy.jpl.nasa.gov!sdd.hp.com!hplabs!pyramid!infmx!davek From: davek@informix.com (David Kosenko) Newsgroups: comp.databases.informix Message-ID: <1991Nov26.161810.5531@informix.com> Date: 26 Nov 91 16:18:10 GMT References: <1991Nov25.045603.8960@dbsm.oz.au> <…
Re: Keypad Application/Numeric Mode
Path: emory!wupost!zaphod.mps.ohio-state.edu!qt.cs.utexas.edu!yale.edu!yale!mintaka.lcs.mit.edu!spdcc!das.harvard.edu!bochner From: bochner@das.harvard.edu (Harry Bochner) Newsgroups: comp.databases.informix Message-ID: <2411@endor.das.harvard.edu.harvard.edu> Date: 26 Nov 91 19:…
File/function info
Path: emory!swrinde!elroy.jpl.nasa.gov!wvus!cbruce From: cbruce@wvus.org (Corinne Bruce) Newsgroups: comp.databases.informix Message-ID: <1991Nov26.172748.176@wvus.org> Date: 26 Nov 91 17:27:48 GMT Sender: cbruce@wvus.org (Corinne Bruce) Organization: World Vision U.S. In an att…
Foreign char sets
Path: emory!swrinde!elroy.jpl.nasa.gov!wvus!cbruce From: cbruce@wvus.org (Corinne Bruce) Newsgroups: comp.databases,comp.databases.informix,comp.unix.large Message-ID: <1991Nov26.171804.29954@wvus.org> Date: 26 Nov 91 17:18:04 GMT Sender: cbruce@wvus.org (Corinne Bruce) Organizat…
Spanning transactions across machines
Path: emory!att!linac!pacific.mps.ohio-state.edu!zaphod.mps.ohio-state.edu!qt.cs.utexas.edu!cs.utexas.edu!swrinde!elroy.jpl.nasa.gov!wvus!cbruce From: cbruce@wvus.org (Corinne Bruce) Newsgroups: comp.databases,comp.databases.informix Message-ID: <1991Nov26.174644.597@wvus.org> Da…
Re: Keypad Application/Numeric Mode
Path: emory!swrinde!elroy.jpl.nasa.gov!ames!agate!stanford.edu!rutgers!pyrnj!pyramid!infmx!jacob From: jacob@informix.com (Jacob Salomon) Newsgroups: comp.databases.informix Summary: (ESC)= and (ESC)> Message-ID: <1991Nov25.222407.19068@informix.com> Date: 25 Nov 91 22:24:07 GMT …
Help me, BLOBbers
(This is a refinement of a previously submitted question:) I have a '386 running Unix and On-Line. Networked to this host, I have some PCs with VGA monitors. The network soft is TCP/IP. I'll run network terminals (with telnet) on the PCs, and then I'll trig a pro…
Report - saving into file
>I am generating reports from INFORMIX/4GL ans saving into file called inv.out. >This file is under /u/ruchi/billing.report. The group has permission to rwx >to a subdirectory billing.report. When A user creates >inv.out to generate report then he can use the same file over and o…
Re: Reversal of Records
Jeffrey F. Lawhorn writes: > > > [ text deleted ] > > The reason for this is the reason that SERIAL exists - it provides > > an automatically generated primary key. The only implied > > requirements are that a type SERIAL be UNIQUE and NOT NULL. > > In addition, a quick review o…
InformixLink & Tech Notes
Hi. Does anyone subscribe to InformixLink? If so, can you tell us how useful it is? Send your comments to this List please. We recently received some junk mail from Informix about InformixLink. The one-page "Info Sheet" says that their TECH NOTES are on the bulletin board. H…
Re: Reversal of Records
A big "THANK YOU" to all who responded. Seems to me to be a good number of experts out there. For the most part, my "little" problem has been solved and the boss is somewhat satisfied. I do however have a few more questions. Quoting Greg Bryan, DHL WORLDWIDE EXPRESS <gbr…
Re: Reversal of Records
>> > [ text deleted ] >> > The reason for this is the reason that SERIAL exists - it provides >> > an automatically generated primary key. The only implied >> > requirements are that a type SERIAL be UNIQUE and NOT NULL. >> > In addition, a quick review of several Informix 4.0 m…
INFORMIX e-mail address
Path: emory!swrinde!cs.utexas.edu!uunet!shearson.com!press!fsmadja From: fsmadja@figment.shearson.com (Frank Smadja) Newsgroups: comp.databases.informix Message-ID: <FSMADJA.91Nov25120514@figment.shearson.com> Date: 25 Nov 91 18:05:14 GMT References: <1991Nov25.045603.8960@dbsm.o…
SQL Query
I have two tables that joines them by project_no. Following are two tables with its values. TABLE A TABLE B ----------------------- project_no project_no ________________________ 1 1 2 - 3 3 When I user outer join then it says tha…
Report - saving into file
I am generating reports from INFORMIX/4GL ans saving into file called inv.out. This file is under /u/ruchi/billing.report. The group has permission to rwx to a subdirectory billing.report. When A user creates inv.out to generate report then he can use the same file over and over …
Re: 4GL DateTime Variables
Path: emory!swrinde!sdd.hp.com!hp-cv!hp-pcd!hpspkla!engstrom From: engstrom@hpspkla.spk.hp.com (Kathleen Engstrom) Newsgroups: comp.databases.informix Message-ID: <20490002@hpspkla.spk.hp.com> Date: 25 Nov 91 15:29:41 GMT References: <20490001@hpspkla.spk.hp.com> Organization: He…
Re: Reversal of Records
John Baker writes: >How do I get the standard engine to use an ORDER BY clause >(on a serial field) when it goes out to retrieve records >during a "Query" done while running an INFORMIX-SQL >PERFORM screen? > A perform screen will retrieve rows ordered on a particular field unde…
Re: Reversal of Records
John Baker Depot Sys Mgt Br writes: > Hello again. ^ [ yet ] :-) > How do I get the standard engine to use an ORDER BY clause > (on a serial field) when it goes out to retrieve records > during a "Query" done while running an INFORM…
Backing Up INFORMIX-Online Databases
Path: emory!wupost!spool.mu.edu!munnari.oz.au!metro!dbsm!ralph From: ralph@dbsm.oz.au (Ralph Michael Gyoery) Newsgroups: comp.databases.informix Message-ID: <1991Nov25.045603.8960@dbsm.oz.au> Date: 25 Nov 91 04:56:03 GMT Reply-To: ralph@dbsm.oz.au (Ralph Michael Gyoery) Organizat…
Re: Reversal of Records
Hello again. First, thanks to all who responded to my message. All the information was quite helpful. Now for a few quotes and follow-ups (I have listed the results of my experiment last). Quoting Will Hartung (la4gen!villy@uunet.UU.NET): > [ text deleted ] > By putting a se…
Re: NULL-Problem, Bug or Feature
Alan Denney writes: >>> From uunet!rmy.emory.edu!informix-list-owner Thu Nov 21 02:16:10 1991 >>> From: uunet!pdact.pd.necisa.oz.au!ronl (Ron Lees) >>> To: informix-list@rmy.emory.edu >>> Subject: Re: NULL-Problem, Bug or Feature >>> >>> Joerg, >>> >>> What you've described soun…
Re: Soundex type search
Path: emory!swrinde!cs.utexas.edu!uunet!mcsun!i2unix!esacs!martin From: martin@esacs.UUCP (Martin Guy) Newsgroups: comp.databases.informix Message-ID: <202@esacs.UUCP> Date: 22 Nov 91 09:20:33 GMT References: <1991Nov20.224415.21672@ddssuprs.uucp@uunet.uu.net> Reply-To: martin@es…
Thank you ( Re: Informix tape archive useful? )
Thank you for many person who respond my question. my understanding is, "Use link or symbolic link techinc for create same name device". OK? I did not try yet ( I very busy for machine/service change our environment), but I will try restore use that techinc and report here. …
Re: Variable field with 300 characters
Hi, I would define your record like this : define item record note1 char(75), note2 char(75), note3 char(75), note4 char(75) end record instead of like that table project. Then you have to define variables to hold the input res…
Re: Reversal of Records
>> From uunet!rmy.emory.edu!informix-list-owner Fri Nov 22 12:04:07 1991 >> Subject: Re: Reversal of Records >> >> OK people, my turn. Nobody has yet mentioned VIEWS. Why can't you set >> up a view of the form >> >> CREATE VIEW viewtab AS >> SELECT * FROM tab >> ORDER BY…
Re: Reversal of Records (fwd)
> > OK people, my turn. Nobody has yet mentioned VIEWS. Why can't you set > up a view of the form > > CREATE VIEW viewtab AS > SELECT * FROM tab > ORDER BY serial > > You can then use this view in Perform for both inserting and retrieving, > and of course it will also wo…
Need Help With "shmconfig" File
Path: emory!swrinde!elroy.jpl.nasa.gov!sdd.hp.com!hplabs!hpl-opus!hpcc05!hpyhde4!hpycla!hpcupna!hprdash!mothra!bruceh From: bruceh@mothra.rose.hp.com (Bruce Hendler) Newsgroups: comp.databases.informix Message-ID: <26890001@mothra.rose.hp.com> Date: 21 Nov 91 15:48:37 GMT Organiz…
Re: Reversal of Records
As was mentioned before, unless an order is specified in the SELECT, the order that rows are arbitrary/undefined/possibly different from instance to instance. The returned order undefined regardless of how many indexes are on table. By putting a serial field on the row, a number…
Re: Reversal of Records
Quoting John Baker Depot Sys Mgt Br... > > I will try to conduct some experiments to see how Informix stores records > and get back with my results. From what I've experienced so far, when using > PERFORM and you do a Query (that is folks, you use the "Query" option on the > Per…
Re: Variable field with 300 characters
Quoting RUCHI@CFRVM.CFR.USF.EDU... > > I have a one problem with INFORMIX/4GL that I don't know how to resolve it. > I have a note field that is 300 characters long so when the form was generated > it splitt into 4 lines. I am using the > > DEFINE item RECORD LIKE project.* > > S…
Backing up INFORMIX-online databases (fwd)
Ralph Gyoery writes: > > Informix : 4.00.UH1 Online > Platform : SUN 4/490 > SunOS 4.1.1 > > I would like to take a checkpoint / snapshot of individual databases > residing on a common raw partition. The reading I have done so far > let's me take an archive of the whol…
Help with INFORMIX locking
Path: emory!swrinde!sdd.hp.com!hp-col!col!judym From: judym@col.hp.com (Judy Miller) Newsgroups: comp.databases.informix Message-ID: <62980003@col.hp.com> Date: 21 Nov 91 22:09:15 GMT Organization: HP Colorado Springs Division Question: Please direct me to some reference on how…
Re: Reversal of Records
OK people, my turn. Nobody has yet mentioned VIEWS. Why can't you set up a view of the form CREATE VIEW viewtab AS SELECT * FROM tab ORDER BY serial You can then use this view in Perform for both inserting and retrieving, and of course it will also work for reports. T…
Re: Keypad Application/Numeric Mode
Path: emory!ox.com!yale.edu!yale!mintaka.lcs.mit.edu!spdcc!dirtydog.ima.isc.com!ispd-newsserver!kodak!static!amiano From: amiano@static.Kodak.Com (Mitch Amiano) Newsgroups: comp.databases.informix Keywords: Informix Termcap TERM Function-keys Message-ID: <1991Nov21.135704.29115@k…
Soundex type search (fwd)
Luis Caamano writes: > > Hello, everybody. > > Does anybody knows of any way to implement sound matching searches > on character fields? That is, to match words that have the same > sound not the spelling? > > It don't care how as long as I'm reading from an informix database. > …
Re: Reversal of Records
I will try to conduct some experiments to see how Informix stores records and get back with my results. From what I've experienced so far, when using PERFORM and you do a Query (that is folks, you use the "Query" option on the Perform menu), and then view your records using the …
(no subject)
Four questions: a.(I think this may be an old question) I'm working with 4glRDS 4.00.UH2, and I've found that the environVar DBDATE does not have any incidence in the behaviour of my programs. The first idea I used was to spe…
Re: NULL-Problem, Bug or Feature
>> From uunet!rmy.emory.edu!informix-list-owner Thu Nov 21 02:16:10 1991 >> From: uunet!pdact.pd.necisa.oz.au!ronl (Ron Lees) >> To: informix-list@rmy.emory.edu >> Subject: Re: NULL-Problem, Bug or Feature >> >> Joerg, >> >> What you've described sounds like another example of In…
Informix tape archive useful?
Hello world, I think, I got Online/Turbo tape archive problem. as you know, Informix Online/Turbo request same environment when restore archive tape. So, I used row device /dev/xd15b for DBSPACE, and /dev/xd15b has been losted. I have archive tape and other disk space, but I c…
Variable field with 300 characters
I am very greatful to everyone who has responded to my mail in the past. I have a one problem with INFORMIX/4GL that I don't know how to resolve it. I have a note field that is 300 characters long so when the form was generated it splitt into 4 lines. I am using the DEFINE item…
Backing up INFORMIX-online databases
Path: emory!wupost!spool.mu.edu!munnari.oz.au!metro!dbsm!ralph From: ralph@dbsm.oz.au (Ralph Michael Gyoery) Newsgroups: comp.databases.informix Message-ID: <1991Nov21.053951.1957@dbsm.oz.au> Date: 21 Nov 91 05:39:51 GMT Organization: SBC Dominguez Barry Ltd Informix : 4.00.UH1 …
Re: NULL-Problem, Bug or Feature
Joerg Werner (joerg@mwtech.UUCP) writes: >Can anyone explain the following results? >Below are listed two tables t1 and t2. I execute the >select-statement three times and before the 2nd and 3rd >execution I inserted new rows into table t2. [ much deleted ] Joerg, What you've…
Soundex type search
Path: emory!wupost!uunet!ddssuprs!lpc From: lpc@ddssuprs.uucp (Luis Caamano) Newsgroups: comp.databases.informix Message-ID: <1991Nov20.224415.21672@ddssuprs.uucp@uunet.uu.net> Date: 20 Nov 91 22:44:15 GMT Sender: lpc@ddssuprs.uucp@uunet.uu.net (Luis Caamano) Organization: Dicken…
Re: Problem with SQL
I believe that the only clean way of handling row ordering in a relational database was never to rely on rowid. This is because in general they are not controllable, especially when you consider the impact of future releases, which may choose a different row insertion/deletion a…
Keypad Application/Numeric Mode
Path: emory!wupost!uunet!mdisea!rudoff From: rudoff@mdd.comm.mot.com (Doug Rudoff) Newsgroups: comp.databases.informix Message-ID: <1991Nov20.225504.26829@mdd.comm.mot.com> Date: 20 Nov 91 22:55:04 GMT Sender: news@mdd.comm.mot.com Organization: Motorola, Mobile Data Division - S…
Problem with SQL (fwd)
John Baker writes: > Hi, > We are having a strange problem with INFORMIX-SQL version 2.10.00A. > We have a simple application that serves as a user interface for creating > 80-column card images on tape. In other words, users key in their data > on a PERFORM screen one line…
Re: Problem with SQL
Quoting John Baker Depot Sys Mgt Br... > > Well David, your suggestion sounded like a good idea, so I gave it a try > and found that it won't solve our problem. > > Can anyone shed any light on this problem????? > Well on to another idea... my next suggestion is the one…
Re: Problem with SQL
John Baker Depot Sys Mgt Br writes: > Quoting David A. Snyder, Folcroft, PA, in reply to my original message > about SQL PERFORM that is storing records in the .dat file in reverse order: [ It's not perform that's storing the rows, mind, it's the backend process ] > > When …
Re: Report
Quoting RUCHI@CFRVM.CFR.USF.EDU... > > One of the SQL field is 40 charachters long and I would like to truncate to > 20 characters. How would I do in INFORMIX/SQL report? > Try... PRINT somevariable[1,20] > I am using the INFORMIX/SQL report to generate the reports. Is there…
Re: NULL-Problem, Bug or Feature
Path: emory!swrinde!zaphod.mps.ohio-state.edu!uakari.primate.wisc.edu!usenet.coe.montana.edu!ogicse!sequent!muncher.sequent.com!news From: krader@sequent.com (Kurtis D. Rader) Newsgroups: comp.databases.informix Message-ID: <1991Nov20.012037.16593@sequent.com> Date: 20 Nov 91 01:…
Reversal of Records in SQL
Hello again Folks, The problem I have described with Informix-SQL is very simple. Let me summarize: 1. The table is like this, with NO indexes (because none are needed): dic char(3), rest char(77) 2. The PERFORM screen lo…
I-SQL, I-4GL .03->4.0
There have been a number of requests for the differences between .03 and 4.1 Informix products. Problem is, you first need to know the differences between .03 and 4.0! Here are a couple of documents which I prepared earlier (any Blue Peter fans?) on the differences between .03 an…
INFORMIX-SQL book - Tony Lacy-Thompson
Dear music lovers, There was a spate of emails last month with regard to books on Informix, and mine was mentioned. However, there were requests for any reviews of the book, which did not seem to be forthcoming. So it falls to the author to blow his own trumpet. Here are two rev…
Re: Problem with SQL
I have noticed this behavior before (back in the 3.3 days, actually). It may depend on the order in which you delete the rows. If the way that C-ISAM handles deleted rows in the .dat file is to keep a linked list of empty rows, then you could see this kind of physical row order…
Re: Problem with SQL
Quoting David A. Snyder, Folcroft, PA, in reply to my original message about SQL PERFORM that is storing records in the .dat file in reverse order: > When you select data from your table, do an "ORDER BY ROWID". That will > work until you start removing old records and inser…
Report
One of the SQL field is 40 charachters long and I would like to truncate to 20 characters. How would I do in INFORMIX/SQL report? I am using the INFORMIX/SQL report to generate the reports. Is there anyway I can use this report in conjuction with INFORMIX/SQL form? The reason i…
Re: Problem with SQL
Quoting John Baker Depot Sys Mgt Br... > > Everything works as it should, *except* that the records are not being > stored in the .dat files in the order in which they were entered! > > Our platform is a Unisys 5000/80 running UNIX V.3.2. A solution or > workaround woul…
Help wanted: UNIPLEX II+ and Apple Laserwriter II
Path: emory!wupost!uunet!mcsun!news.funet.fi!sunic!dkuug!ruc.dk!bjim From: bjim@gorm.ruc.dk (Jim Andersen) Newsgroups: comp.databases.informix,comp.lang.postscript,comp.fonts Keywords: UNIPLEX II+, postscript Message-ID: <1991Nov19.144032.25402@gorm.ruc.dk> Date: 19 Nov 91 14:40:…
Re: i4gl question.
Gauker, > I've got a fairly large system written mainly in cobol and fortran > on an old vax/vms machine. I have to transfer it to a unix machine > and estimated time to transfer in cobol is 6 to 9 months. > Now I have to make a decision if to do it in cobol or i4gl, so what > …
Re: Control-X bug in WORDWRAP
>> From uunet!rmy.emory.edu!informix-list-owner Tue Nov 19 00:49:19 1991 >> From: uunet!pdact.pd.necisa.oz.au!ronl (Ron Lees) >> To: tab@ibmpcug.co.uk >> Subject: Re: Control-X bug in WORDWRAP >> Cc: informix-list@rmy.emory.edu >> >> Andrew, >> >> We have had that problem as well…
NULL-Problem, Bug or Feature
Path: emory!samsung!uunet!mcsun!unido!omikros!mwtech!joerg From: joerg@mwtech.UUCP (Joerg Werner) Newsgroups: comp.databases.informix Message-ID: <1254@mwtech.UUCP> Date: 18 Nov 91 16:24:56 GMT Reply-To: joerg@mwtech.UUCP (Joerg Werner) Organization: MIKROS Systemware, Darmstadt/…
Re: informix 408 error
I have had this problem in the past. What caused it was a bug in a 4GL program that was inserting uninitialized data into the database. Apparently at some point we inserted a value into a date column that the On-Line backend could not deal with. We could reliably crash the back…
Re: Database utility
> >I have two ascii files that contains two diffrent set of data with one common >key. How would I load into database? I used the DBLOAD command to load the firs >t ascii file but how would I load the second set of ascii file to merge with >existing data. > I assume that you wan…
Problem with SQL
Hi, We are having a strange problem with INFORMIX-SQL version 2.10.00A. We have a simple application that serves as a user interface for creating 80-column card images on tape. In other words, users key in their data on a PERFORM screen one line at a time. The screen (and …
Re: Database utility
Quoting RUCHI@CFRVM.CFR.USF.EDU... > > I have two ascii files that contains two diffrent set of data with one common > key. How would I load into database? I used the DBLOAD command to load the firs > t ascii file but how would I load the second set of ascii file to merge with > …
Re: informix 408 error
Ron, Thanks for the suggestion about altering the table, it's worth a try. I agree with the ambigious -408 error ! Brian MacWilliams P.S. Where did you say Australia was ???…
Re: Control-X bug in WORDWRAP
Andrew, We have had that problem as well and reported it to Informix in Australia about a month ago. Here is their reply: "The problem that you have identified has already been reported as a bug and is scheduled to be fixed in 4.00.UJ1. Expected release date for this version is…