Threads from 1992
INFORMIX 4GL (DOS) FOR SALE
Anyone want to buy INFORMIX 4GL - DOS (legal registered vers 1.10.06B). This is on 3.5 diskettes. I believe the current release is 1.10.06E. This can be upgraded to the new 4GL when the NEW 4GL is released by Informix. Make me an offer... I still need INFORMIX ISQL, ESQL/C, & …
making isql output horizontal
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? # # reform…
Re: Start values for serial columns
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…
Re.:Nice kill of tbtape -c
Nice kill of tbtape -c ---------------------- Thanks for all the answers. I think it is working now. This is my result: I will execute tbtape -c with a trap on signal 2. The output will be piped to a program, which w…
Re: Corrupted Index
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 prim…
Re: parameters as host variables
Mark_Sherman@transarc.com wrote: > 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 …
Re: Start values for serial columns
Thanks for the advice guys - I'll give up trying and encourage people to document the system properly. -- +-----------------------------------------------------------------------------+ We'd be fools not to ride this strange torpedo all the way out to the end. Malcolm Apps…
Corrupted Index
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 re…
Re: Nice kill of tbtape -c ?
Poul Pedersen writes: > > How is it possible to stop 'tbtape -c' if it is running > in the background. (Terminal turned off and SIGHUP trapped.) > > The tbtape command must be stopped in a nice way. > Is it possible to use 'kill -xx' ? Since tbtape is…
Re: INF4.1 -1 ERROR ?? problem
shemminga@cix.compulink.co.uk writes: > >>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 r…
Nice kill of tbtape -c ?
How is it possible to stop 'tbtape -c' if it is running in the background. (Terminal turned off and SIGHUP trapped.) The tbtape command must be stopped in a nice way. Is it possible to use 'kill -xx' ? If you under normal log backup execu…
Re: C-ISAM to Informix rdb con
In-Reply-To: <1hqc37INNaj@emory.mathcs.emory.edu> markf@sequoia.sequoia.com (Mark R. Friedman) TITLE: C-ISAM to Informix rdb conversion utilities In <1hqc37INNaj@emory.mathcs.emory.edu> Mark R. Friedman asks: > What utilities/tools exist to ease moving data from (Informix) C-I…
Re: INF4.1 -1 ERROR ?? problem
In-Reply-To: <1992Dec28.183425.12622@informix.com> davek@informix.com (David Kosenko) 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 i…
Re: Display array highlist
In-Reply-To: <cortesi.725577273@helium> cortesi@informix.com (David Cortesi) TITLE: Re: Display array highlist In <cortesi.725577273@helium> David Cortesi writes: [Stuff deleted] > The latter (ability to use variables in the OUTPUT section) is > generally accepted as a Good I…
Re: Display array highlist
In-Reply-To: <cortesi.725577273@helium> cortesi@informix.com (David Cortesi) TITLE: Re: Display array highlist In <cortesi.725577273@helium> David Cortesi writes: [Stuff deleted] > The latter (ability to use variables in the OUTPUT section) is > generally accepted as a …
Re: MacTCP problem with Informix DataLink - solved
In article <168CCAF7A.M21520@mwvm.mitre.org> I wrote: >>When anyone uses DataLink to open a connection w/ a database on the UNIX host, >>the following error message appears: "Your MacTCP software had problems >>sending data because the TCP connection went down. (ERR# -27015)". …
C-ISAM to Informix rdb conversion utilities
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…
Re: MacTCP problem with Informix DataLink
I am reposting this here, because I incorrectly specified the address of this group on my first attempt: >Hello MacTCP experts! > >We have been using Wingz DataLink to communicate with an Informix database >on a UNIX host. This set-up requires MacTCP. We have maintained a rela…
Informix/Ingres conversion utilities
Are there any PD or commercial tools/utilities that would assist in transfering an informix database to ingres? I'd be especially interested in something that handles report conversions (although forms and 4GL would be nice too). It might also be worthwhile to look at product…
Using multiple GLOBALS files
hello, Does anybody know how can I do something like these: in a.4gl -> GLOBALS "glo1.4gl", "glo2.4gl" or in glo.4gl -> GLOBALS "glo1.4gl" DEFINE a, b, c .... END GLOBALS Any hints ? ale. --- By the way, I'm re-sending a question nobody answered: On last July…
Re: Display array highlist
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 r…
INFORMIX DB BENCHMARKS and LOCATION of FAQ
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 rodn…
Wingz.sleep.problem
Hi, We are users of Wingz/DataLink. In my application I need to poll database (awaiting triggers !!) every 3 mins. My choices are: 1. "wait" command from hyperscript OR 2. calling external C-function which includes sleep() call Problem with solution # 1 is that W…
Re: Display array highlist
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 le…
Re: Error 208 - Memory Allocation
In article <1992Dec26.210807.5884@Thalatta.COM> bossert@thalatta.com (John Bossert) writes: >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 allocati…
Re: INF4.1 -1 ERROR ?? problem
>>>We have just started getting a new error which is described nowhere >>>in the INFORMIX literature (whats new): -1. This happens when we >>>install our package on UNIX . In one of our package-installation-scripts >>>we start tbinit and straight afterwards try a drop database in…
Re: Error 208 - Memory Allocation
John Bossert writes: >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. > This error is caused by an error …
Re: Start values for serial columns
Dave Snyder writes: >Quoting Malcolm Apps... >} >} I've recently been working on a small project that will recreate a >} database schema *exactly* - down to the names of tablespaces etc and >} especially the initial values of any serial columns. >} >} I've scoured the system cata…
Why??? (did informix use termcap on AIX port?)
Why did Informix choose to stay with the old "termcap" terminal information database when they ported SQL & 4GL to AIX? This certainly is a pain, since termcap is not really documented anymore... Anyone care to shed some light on this? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=…
Inventory System Info
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 gove…
Tripping Server III
%UNIPLEX %TO informix-list@rmy.emory.edu %FROM rridley %SYSTEM DHLNET %SUBJECT Tripping Server III %VERIFY y %DATE 28/12/92 10:34 %REFERENCE 10020 Alan Denney writes : >We are experiencing problems with an application develop…
Re: Display array highlist
In-Reply-To: <1992Dec21.175031.11266@informix.com> cortesi@informix.com (David Cortesi) TITLE: Re: Display array highlist In <1992Dec21.175031.11266@informix.com> David Cortesi [Stuff deleted] > How would you want this window defined? Just a bare window, or would > you requi…
Re: INF4.1 -1 ERROR ?? problem
In-Reply-To: <1992Dec23.161421.17027@informix.com> davek@informix.com (David Kosenko) TITLE: Re: INF4.1 -1 ERROR ?? problem In <1992Dec23.161421.17027@informix.com> David Kosenko writes: >Rigby writes: >> >>HELP !!! >>We have just started getting a new error which is described…
Informix & Softbench
Informix users, We are using Informix & Softbench on our HP-700s. Any help on integrating Softbench & Informix? Thanx, N.Strifas…
Error 208 - Memory Allocation
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 mys…
PC Client access tools?
Hi, we have a mixed environment where Informix on an HP9000/800 series HP-UX box is running as one RDMS among others (Sybase, MS-SQL Server on OS/2, Paradox, Allbase(HP), Image(HP) for example). Are there PC client tools to access Informix over a LAN Manager LAN, like Pioneer So…
Re: Start values for serial columns
Quoting Malcolm Apps... } } I've recently been working on a small project that will recreate a } database schema *exactly* - down to the names of tablespaces etc and } especially the initial values of any serial columns. } } I've scoured the system catalogs and can't find the inf…
Start values for serial columns
I've recently been working on a small project that will recreate a database schema *exactly* - down to the names of tablespaces etc and especially the initial values of any serial columns. I've scoured the system catalogs and can't find the information required for serial column…
parameters as host variables
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; …
Transactions
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 no…
WANTED: INFORMIX for MS-DOS
Anyone want to sell me their current DOS version of INFORMIX? Please reply to: bobb@netcom.com Thanks, Bob Beaulieu -- ============================================================= Bob Beaulieu bobb@netcom.com San Jose, CA …
Re: Calculating Extents
In article <1992Dec23.170729.20715@informix.com> davek@informix.com (David Kosenko) writes: >Naomi Walker asked: >> >>Can someone please tell me a reliable way to calculate extents >>on tables with TEXT BLOBS? I've tried using the formula in >>the book, but that doesnt work well…
Shareware SQL base database for DOS.
Hi netter, I was told by a friend of mine that there are some shareware database that provide SQL access. Can anyone give me more info on where to look?? Thanks a lot! .…
Re: What is INFORMIX-LINK?
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 …
Re: Calculating Extents
Naomi Walker writes: > >Can someone please tell me a reliable way to calculate extents >on tables with TEXT BLOBS? I've tried using the formula in the >book, but that doesnt work well. In our case, this BLOB is in >the tblspace, not in a blobspace. Does it make a difference? …
I-Net Question
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 …
A few Questions
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.…
Re: INF4.1 -1 ERROR ?? problem
Rigby writes: > >HELP !!! >We have just started getting a new error which is described nowhere >in the INFORMIX literature (whats new): -1. This happens when we >install our package on UNIX . In one of our package-installation-scripts >we start tbinit and straight afterwards try …
mail problem
>From: uunet!xact.demon.co.uk!ptm (Paul Thomas Mahoney) >I DO NOT WORK FOR INFORMIX! I'm just a VAR... >My software runs on 468 "Class C" machines which can support > 25 people. >Informix are now to have "# of user" prices breaks on Class C machines. >As a result the price hike f…
Re: Improvements to I4GL
obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler) writes: >* Screen dumps. There is an undocumented feature in INFORMIX-4GL and INFORMIX-SQL (it is documented in the INFORMIX-Quickstep manual though) that makes screendumps: Set the environment variable DBSCRE…
Tripping Server II
%UNIPLEX %TO informix-list@rmy.emory.edu %FROM rridley %SYSTEM DHLNET %SUBJECT Tripping Server II %VERIFY y %DATE 23/12/92 20:10 %REFERENCE 9933 Hi there informixer's : A while back I sent a mail asking if anyone had experien…
Re: Improvements to I4GL
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. } > . . .. …
Calculating Extents
Can someone please tell me a reliable way to calculate extents on tables with TEXT BLOBS? I've tried using the formula in the book, but that doesnt work well. In our case, this BLOB is in the tblspace, not in a blobspace. Does it make a difference? Should I just use the avera…
Re: Improvements to I4GL
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. --…
INF4.1 -1 ERROR ?? problem
HELP !!! We have just started getting a new error which is described nowhere in the INFORMIX literature (whats new): -1. This happens when we install our package on UNIX . In one of our package-installation-scripts we start tbinit and straight afterwards try a drop database in a …
Help: Table exists but isn't eraseable!
Hello World, I'm asking a very simple but opaque Thing: I have played with create table and create temp table .. and now I've got the problem: If I want to create a table called manipluation, the isql answers with: 310: Table (igrdb.manipulation) already exists in the database…
4.0 to 5.01 migration ?
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 …
List Of User Groups as of (12.21.92)
Country: Australia ================================================= Region: Canberra ====================================== =========================== User Group Name: /usr/informix …
Re: Fixes to Informix-4gl
Quoting Stuart Hemming... } } In-Reply-To: <1gor7vINN4u9@emory.mathcs.emory.edu> dave.snyder@snide.com (Dave Snyder) } } TITLE: Re: Fixes to Informix-4gl } } In <1gor7vINN4u9@emory.mathcs.emory.edu> Dave Snyder writes: } } [Stuff deleted] } } > Sounds great... but what happens if…
Re: An insider's view
>I hear every day that we have the best 4GL on the market ! It seems >that our 4GL has a very big share of the Unix market. I don't hear >very much from the marketing department that there should be so many >[.......] >say our 4GL is really a fourth generation language. And if th…
Re: An insider's view
> I recieved this message today from someone inside Informix. I've been > asked not to identify the individual but am posting the message with > permission. > > ----------------------------- > > Hello, > > > I hear every day that we have the best 4GL on the market ! It seems > th…
Re: Display array highlist
In article <1992Dec15.145006.8036@mnemosyne.cs.du.edu> aburt@mnemosyne.cs.du.edu (Andrew Burt) writes: > [his homespun solution is a lot more work than...] something like > > OPEN WINDOW foo AT 5,5 WITH 10 ROWS, 60 COLUMNS > ... > REPORT TO WINDOW foo > >"report to window" should…
Re: ESQL C and sqlerrd[2]
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 ro…
Re: [David Kosenko: Re: turbo extents used]
Anbarnes@letterkenn-emh1.army.mil writes: >Dave K writes in response to my request for help on determining how many >extents are in use in Turbo 2.10.03G: >>If the table is active (and you can make it active by going into isql and >>issuing a LOCK TABLE statement), then tbstat -t…
Re: An insider's view
Brian Douglass writes: shemminga@cix.compulink.co.uk writes: >> >>I recieved this message today from someone inside Informix. I've been >>asked not to identify the individual but am posting the message with >>permission. >> >[deleted stuff] >>And if there is >>nothing which is mu…
Re: Help, tbtape is trashing my rootdbs!
Ing. Juan Gabriel Ruiz writes: >davek@informix.com (David Kosenko) writes: >>What you should do is run a low-level disk surface check on the devices you >>are using for your chunks. Typically, this problem is caused by bad blocks >>present on the device. > >>As per bringing your…
Re: Improvements to I4GL
To all these suggestions, I want to add one more. I would like to see AUTOWRAP capability restored to the CONSTRUCT statement. Originally it was allowable, but Informix considered it a bug and 'fixed' it, which absolutely killed us here, because in our applications here we do a…
ESQL/C + GX ?
Ciao, I am using r6000 with Aix 3.1 and Informix 4.1 I am interesting in using ESQL/C with the forms of 4GL/GX (with X-window plus Motif). It's possible ? Please e-mail replies, I'll post a summary if asked Thanks in advance -- Sandro Doro (alex@aureus.sublink.org) DON'T wo…
Re: Fixes to Informix-4gl
In-Reply-To: <1gor7vINN4u9@emory.mathcs.emory.edu> dave.snyder@snide.com (Dave Snyder) TITLE: Re: Fixes to Informix-4gl In <1gor7vINN4u9@emory.mathcs.emory.edu> Dave Snyder writes: [Stuff deleted] > Sounds great... but what happens if the data isn't sorted alphabetically? > A…
Re: Improvements to I4GL
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. * Dynamically configurable reports. * Modular report code. So you can call a function to do a standard block of PRINT statements…
Sizing of Hardware
Hi, Does someone have a references to an articles og book where one could read about scaling of hardware for Informix databases. We are using HP 9000's for running our databases but I would like to a concept for sizing the machines when I know some data about the database (size,…
Re: Fixes to Informix-4gl
carl.t.mosley (mvctm@cbnews.cb.att.com) wrote: : : How about an improved DISPLAY ARRAY where the user can, for example, : press the letter "N" and the array will automatically scroll to the : row(s) beginning with "N"? If I am using DISPLAY ARRAY for some sort of : "browse" fun…
Re: Invisible entry
If your invisible attribute dosen't work, I have a suggestion that may work for entering a password. Start off by opening a form with a field the size of the largest password you want to enter. Then begin a loop with a prompt statement (PROMPT FOR CHAR). Directly after the user…
Re: Entering "invisible" data in a form
Quoting Cecilia Jaeger... } } I couldn't think of a better way to phase this. I have a form that } is basically an opening screen that asks for Employee Id and password. } } In 4gl 4.0 how do I make it so the user DOESN'T see what they type as the enter } their password. I like t…
Re: Suggested Changes to 4gl
In article <1992Dec16.213256.21452@nezsdc.icl.co.nz> you write: : John Oliver writes... : >How about dynamic use of I4GL call command, i.e be able to issue:- : > call func_name : >where func_name is a char variable storing the name of a function. I think we have this (sort of.) …
Re: "WordWrap" and temporary s
aburt@mnemosyne.cs.du.edu (Andrew Burt) writes: >In <memo.808385@cix.compulink.co.uk> shemminga@cix.compulink.co.uk (Stuart Hemming) writes: >>In-Reply-To: <randall.723872563@seashore> randall@informix.com (Randall Rhea) >>TITLE: Re: "WordWrap" and temporary string storage >>In …
Looking for database/stat/graphics applicatioN
We are looking for a software application for the PC with the following characteristics: Querying, regression analysis, statistical graphics preferably menu driven (point and click). For example we would like to read in some data, pull certain values that match certain criteria…
BEST RDBMS
I'm not going to tell you ! I want you to tell me: 1. Where can I find a current OBJECTIVE feature matrix for the major RDBMS's (Oracle, Sysbase, Informix, Ingres, Progress) 2. This is for people experienced with most of the major DBMS's: If you were going to standa…
Re: An insider's view
> Hello, > > And if these feature requests should be really justified - what is > the problem ? As you already mentioned - is there something better > on the market ? No - and people who come from Cobol or Assembler > are happy with the product. Forget the few ones who want to …
Comments on Insider.
> From: shemminga@cix.compulink.co.uk (Stuart Hemming) > Message-Id: <memo.818132@cix.compulink.co.uk> > Subject: An insider's view > Date: Fri, 18 Dec 1992 09:13:00 +0000 > Reply-To: shemminga@cix.compulink.co.uk > Sender: informix-list-owner@rmy.emory.edu > > > I recieve…
Invisible entry
> I couldn't think of a better way to phase this. I have a form that > is basically an opening screen that asks for Employee Id and password. > > In 4gl 4.0 how do I make it so the user DOESN'T see what they type as the enter > their password. I like to be able to do it in the fo…
Re: Fixes to Informix 4gl
The worst problems I've had with Informix 4gl all involve bugs with the product. My version of 4.1 suffers from the "out of temporary string space" WORDWRAP and USING bug as well as a core dump on INPUT ARRAY bug, other WORDWRAP bugs, and a dbload bug. There are undoubtedly oth…
Re: An insider's view
In article <memo.818132@cix.compulink.co.uk> shemminga@cix.compulink.co.uk writes: > >I recieved this message today from someone inside Informix. I've been >asked not to identify the individual but am posting the message with >permission. > [deleted stuff] >And if there is >nothi…
Re: Entering "invisible" data in a form
> >I couldn't think of a better way to phase this. I have a form that >is basically an opening screen that asks for Employee Id and password. > >In 4gl 4.0 how do I make it so the user DOESN'T see what they type as the enter >their password. I like to be able to do it in the form…
tmp space question
we have been having problems with our disk space not being released by the engine. we have a sun 690 running 5.0 online. several times we've had the case that one of the mounted devices would become 100% full. we looked at all the files for size, creation time, etc. and nothin…
hp termcap/terminfo
Ok, so I'm forgetful and don't always realize that everybody else doesn't have the foggiest of what I refer to. The hp termcap/terminfo attributes I just posted (at least I think I just posted them!) are documented in the TERM0 manual and should work with most hp terminals. Aga…
hp termcap/terminfo
(Author's note to hisself) Let's try sending it to the Net this time dummy! Sorry Kacy for the dupe. > Anybody got a good termcap/terminfo entry for an hp tube? (Yeah, I know, look > where I'm working!). Specifically I'm wondering if there is a solution to the > magic…
Re: An insider's view
> nothing which is much better - why should we spend money for > implementing all these features if we can sell it as it is ? Because, dummy, if *you* don't, someone else will - and will take away your customers. And you will be so far behind the power curve that you will never…
Asking about new products
On last July, Steve Price wrote a report on the Informix User Conference and he mentioned two new informix products announced for "late 1992 or early 1993". They are Hypertools (programming tools for hyperscript, with embedded SQL) and STORM (report and forms design facility for …
Re: Fixes to Informix-4gl
} }Quoting carl.t.mosley... }} }} How about an improved DISPLAY ARRAY where the user can, for example, }} press the letter "N" and the array will automatically scroll to the }} row(s) beginning with "N"? If I am using DISPLAY ARRAY for some sort of }} "browse" function or a "pi…
An insider's view
I recieved this message today from someone inside Informix. I've been asked not to identify the individual but am posting the message with permission. ----------------------------- Hello, I hear every day that we have the best 4GL on the market ! It seems that our 4GL has a ve…
Re: FORM FEED IN REPORTS
In-Reply-To: <1gnr51INNa7d@emory.mathcs.emory.edu> yaron@ortarg.edu.ar (Yaron Zarfati) TITLE: FORM FEED IN REPORTS In <1gnr51INNa7d@emory.mathcs.emory.edu> Yaron Zarfati asks: > Hi, I need help on the behavior of the SKIP TO TOP OF FORM statement in > reports. > > When this st…
Re: "WordWrap" and temporary s
shemminga@cix.compulink.co.uk (Stuart Hemming) writes: >In <randall.723872563@seashore> Randall Rhea writes: >[Stuff deleted] >> One of the things I like about Informix-4GL is that it does NOT >> have all them "bells and whistles." [...] >I sorry but this is completely the w…
Re: FORM FEED IN REPORTS
In article <1gnr51INNa7d@emory.mathcs.emory.edu> yaron@ortarg.edu.ar (Yaron Zarfati) writes: >Hi, I need help on the behavior of the SKIP TO TOP OF FORM statement in >reports. >When this statement is reached, informix fills the report with empty lines >until it reaches the number…
Re: ESQL C problem with sqlerrd[2]
In article <brownlow.724615082@xanadu> brownlow@informix.com (Keith Brownlow) writes: >>The sqlca.sqlerrd[2] value DOES NOT hold the number of rows found by opening >>a cursor for a select statement (dynamic or otherwise). The sqlerrd[2] value >>is filled in only by the update a…
Re: Tripping Server
In article <1gho6eINNikv@emory.mathcs.emory.edu> rridley@sin-pss.DHL.COM (Richard Ridley) writes: >%TO informix-list@rmy.emory.edu >%FROM rridley >%SYSTEM DHLNET >%SUBJECT Tripping Server >%VERIFY y >%DATE 14/12/92 18:03 >%REFERENC…
SOLVED: SQL 2.10.03 problem: cannot UPDATE table
I wrote: >A user wants to delete a row from a table. The query: > >delete from ft >where entry_name = "P90589"; > >dies with: > >263: Could not lock row for UPDATE. > >There is no possibility the table or row is being used by anyone >else. A number of other rows have been dele…
Re: Fixes to Informix-4gl
I hate the input staement in general. I hate the cursors. I hate the way that I can compile programs with syntax errors and they compile fine. I hate the time it takes to compile. I hate the size of the executables. I hate the cost. I hate the primitive Interface. I hate that I c…
Re: Database directed system administration ??
krienke@informatik.uni-koblenz.de (Rainer Krienke) writes: >We are looking for a database based system for (unix-) workstation >administration. >Using this databasesystem we want eg. to be able to add new users to our >system, or new workstations to our net. >The modification of…
Re: Informix termcap
In article <1go378INNh9f@emory.mathcs.emory.edu> jparker@hpbs2776.boi.hp.com (Jack Parker) writes: Anybody got a good termcap/terminfo entry for an hp tube? (Yeah, I know, look where I'm working!). Specifically I'm wondering if there is a solution to the magic-cookie-g…
Re: ESQL C problem with sqlerrd[2]
ray@unlv.edu (Ray Tripamer) writes: >The sqlca.sqlerrd[2] value DOES NOT hold the number of rows found by opening >a cursor for a select statement (dynamic or otherwise). The sqlerrd[2] value >is filled in only by the update and delete statements (maybe insert too), but >not by…
Re: ESQL C problem with sqlerrd[2]
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 …
Informix/Wingz - help needed!!
We are in the process of developing a system using Informix, Wingz, Unix, X-Window. We are attempting to pull data into Wingz to do some analysis and graphing. It is envisioned that the script would ask for minimal input from the user and then go off and do its thing, producing …
Re: FORM FEED IN REPORTS
In article <1gnr51INNa7d@emory.mathcs.emory.edu> yaron@ortarg.edu.ar (Yaron Zarfati) writes: >Hi, I need help on the behavior of the SKIP TO TOP OF FORM statement in >reports. > >When this statement is reached, informix fills the report with empty lines >until it reaches the numb…
Re: Help, tbtape is trashing my rootdbs!
davek@informix.com (David Kosenko) writes: >What you should do is run a low-level disk surface check on the devices you >are using for your chunks. Typically, this problem is caused by bad blocks >present on the device. >As per bringing your system back up after a "bad block ex…
Re: Help, tbtape is trashing my rootdbs!
davek@informix.com (David Kosenko) writes: : I will speculate that the reason the second database seems to "cause" the : problem is that the space allocated for the tables in that database contain : the problem area. Since tbtape will only try to read allocated space, it : does…
DAS13 Anonuucp Problems
I'll be brief... do to modem problems, the people trying to anonuucp the latest version of db4glgen from das13 are probably going to freak when they get their phone bills. The modem problem was SOLVED at about 10pm EST on 12/16/92. I'm sorry for the inconvenience. DAS -- Davi…
Re: deleting large databases
>From: uunet!ortarg.edu.ar!yaron (Yaron Zarfati) >Subject: deleting large databses >Date: Mon, 14 Dec 92 14:33:44 ARG >X-Informix-List-Id: <list.1698> >Hello, I am working in 4GL 4.00 under UNIX ... > Another solution was to drop and re-create the table, which would be > the …
Re: Fixes to Informix-4gl
Quoting carl.t.mosley... } } How about an improved DISPLAY ARRAY where the user can, for example, } press the letter "N" and the array will automatically scroll to the } row(s) beginning with "N"? If I am using DISPLAY ARRAY for some sort of } "browse" function or a "pick list"…
Updating a SERIAL field
Informixers, Any suggestion on the following problem: I have a db, and a C struct that corresponds directly to one of the tables. So, selecting & inserting is easy; I fill the struct with data & I do it. The problem that I have is when I am trying to UPDATE since one of the fiel…
Re: Suggested Changes to 4gl
I'm posting the suggestion below for John Oliver (oliverj@eymsl.co.nz), whose posts aren't getting out to the real world. John Oliver writes... >How about dynamic use of I4GL call command, i.e be able to issue:- > call func_name >where func_name is a char variable storing the na…
Entering "invisible" data in a form
I couldn't think of a better way to phase this. I have a form that is basically an opening screen that asks for Employee Id and password. In 4gl 4.0 how do I make it so the user DOESN'T see what they type as the enter their password. I like to be able to do it in the form. I tr…
Informix termcap
Anybody got a good termcap/terminfo entry for an hp tube? (Yeah, I know, look where I'm working!). Specifically I'm wondering if there is a solution to the magic-cookie-glitch for this thing. Also, has anybody ever got Informix to use attributes like DIM, UNDERLINE, or BLINK i…
Re: Suggested Changes to 4gl
(Paul Mahler) writes: >Hello the net, > >So far the only responses I have received have been suggestions >for changes to the input array statement. Is everyone really >this satisfied with 4gl? Is there nothing else we can >complain about? > >Paul Mahler I wouldn't consider myse…
Re: Fixes to Informix-4gl
How about an improved DISPLAY ARRAY where the user can, for example, press the letter "N" and the array will automatically scroll to the row(s) beginning with "N"? If I am using DISPLAY ARRAY for some sort of "browse" function or a "pick list" I would like to allow a user to qu…
Re: Fixes to Informix-4gl
> > paul, > > the recent influx of 4gl bashing (wish lists), that i have also > contributed to, is understandable. i was just curious what others > have been using prior to i4gl that was any better. certainly not > the big o products. possibly progress, ingress, etc. > > just …
Re: Database directed system administration ??
In article <1gk5osINNbq@uniko.uni-koblenz.de>, krienke@informatik.uni-koblenz.de (Rainer Krienke) writes: |> We are looking for a database based system for (unix-) workstation |> administration. |> Using this databasesystem we want eg. to be able to add new users to our |> system…
Re: Suggested Changes to 4gl
In-Reply-To: <1992Dec14.215058.24334@netcom.com> pmahler@netcom.com (Paul Mahler) TITLE: Suggested Changes to 4gl In <1992Dec14.215058.24334@netcom.com> Paul Mahler asks: > Hello the net, > > So far the only responses I have received have been suggestions > for changes to the …
Re: Fixes to Informix-4gl
paul, the recent influx of 4gl bashing (wish lists), that i have also contributed to, is understandable. i was just curious what others have been using prior to i4gl that was any better. certainly not the big o products. possibly progress, ingress, etc. just curious bob bas…
TSS problems in MS-DOS
Hello world! This one is dedicated to all those who have ever had to struggle with Informix 4GL for MS-DOS. I've been working for sometime on a project on MS-DOS that uses Informix. The trouble is that one of the programs has grown somewhat large (2 MB on the executable file) a…
[David Kosenko: Re: turbo extents used]
Dave K writes in response to my request for help on determining how many extents are in use in Turbo 2.10.03G: >If the table is active (and you can make it active by going into isql and >issuing a LOCK TABLE statement), then tbstat -t will show the number of >extents allocated fo…
FORM FEED IN REPORTS
Hi, I need help on the behavior of the SKIP TO TOP OF FORM statement in reports. When this statement is reached, informix fills the report with empty lines until it reaches the number specified in the PAGE LENGTH statement. This slows down the printing, so what I would like to …
Project Management Packages using Informix WANTED
We are looking for a package (commercial/shareware/freeware) that will be able to handle our engineering Project Scheduling requirements. Some requirements are that it: - uses Informix (at least 4.0) as the database - runs on UNIX (at this stage HPUX 7.0/8.0 and AIX (Risc6000 bo…
Fixes to Informix-4gl
Hi Everyone! Well the cards and letters have been coming in! I have a growing list of suggestions. As promised, I will post a summary back to the net. If there is anything you don't like about Informix-4gl now is your opportunity to tell us all about it. There have been some…
Re: Suggested Changes to 4gl
In article <1992Dec14.215058.24334@netcom.com> pmahler@netcom.com (Paul Mahler) writes: >So far the only responses I have received have been suggestions >for changes to the input array statement. Is everyone really >this satisfied with 4gl? Is there nothing else we can >complain…
Suggested Changes to 4GL
My Christmas list: -All fields/literals on forms should have attribute bytes associated with them which you can control from a 4GL program. So for example, if you want to hide a field for some users and not others you could use the same form and set an attribute byte…
WANTED: DOS 4.1 version of INFORMIX
Anyone want to sell me their DOS 4.1 version of INFORMIX? Please reply to: bobb@netcom.com Thanks, Bob Beaulieu -- ============================================================= Bob Beaulieu bobb@netcom.com San Jose, CA …
Help, tbtape is trashing my rootdbs!
Have the following hardware, OS, and Informix . . . IBM RT AIX 2.2.1 Informix OnLine v4.00.UD4 Here's the problem . . . After initializing rootdbs and shared memory without any difficulties I use ISQL to create a couple of databases, fill one of them up with records and …
4gl generator
Calling Dave Snyder, calling Dave Snyder, Would you please list the info on your generator programs and how we go about getting them. After all this time and many previous postings about them, I have successfully deleted every message on how …
Re: Suggested Changes to 4gl
How about IFDEFs in 4GL code. Sure would be handy to make customized versions of standard products in a single source tree.…
Re: ESQL C problem with sqlerrd[2]
In article <1992Dec14.230122.22841@unlv.edu> ray@unlv.edu (Ray Tripamer) writes: >In article <1giuitINNcgq@emory.mathcs.emory.edu> kristen.m.altman@ccd.harris.com (Kristen Altman) writes: >>In my application, I am using ESQL C 4.1 and formatting dynamic SQL stmts. >> >>After the …
Re: Informix 4.0 and AIX 3.2
In the following mail Andrew Congdon states } } In article <jgabriel.723504339@academ01> jgabriel@academ01.mty.itesm.mx (Ing. Juan Gabriel Ruiz) writes: } >Actually I'm running Informix Online and Standard Engine under AIX 3.1.5, } >both of them work fine. Now I'm trying to make …
Re: Two index query optimization problem
Devin Wala writes: > > >I'm having some problems with Informix over optimizing my query. >I have a table with > 500000 rows and I can't get Informix to >use what I deem to be the "correct" index. > >There are two indexes on the table: > > index1: unique index on A, B; > index…
ESQL C and sqlerrd[2]
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 a…
Infoperl available?
Is there a version of perl available yet for making informix queries? Something akin to sybperl and oraperl. Leif Neve…
tbstat utility
Alan/Emory, You answered Ann Barnes's question on how to get extent info with tbstat. You also gave her a select statement that allowed her to convert a partnum into a table name. Would you please resend that answer. Thanks - Brian MacWilliams…
INFORMIX-ORACLE differences
Has anybody any idea of the differences in ORACLE-SQL and INFORMIX-SQL as I have to port an application from INFORMIX to ORACLE for a fussy customer. Thanx Mr. ANDI RIGBY BEng(Hons) but you can call me Andi…
WingZ
I've been looking for a database package for a Unix system, and am considering Informix-SE among others. Originally I wasn't considering WingZ as a front end because I was told that it was somewhat limited as to what kind of queries it could process. For us, the main point of u…
Re: Suggested Changes to 4gl
In <1992Dec14.215058.24334@netcom.com> pmahler@netcom.com (Paul Mahler) writes: >Hello the net, >So far the only responses I have received have been suggestions >for changes to the input array statement. Is everyone really >this satisfied with 4gl? Is there nothing else we can…
Re: "WordWrap" and temporary s
In <memo.808385@cix.compulink.co.uk> shemminga@cix.compulink.co.uk (Stuart Hemming) writes: >In-Reply-To: <randall.723872563@seashore> randall@informix.com (Randall Rhea) >TITLE: Re: "WordWrap" and temporary string storage >In <randall.723872563@seashore> Randall Rhea writes: >>…
Re: Display array highlist
In <memo.808387@cix.compulink.co.uk> shemminga@cix.compulink.co.uk (Stuart Hemming) writes: >In <1992Dec10.181239.29704@mnemosyne.cs.du.edu> I, Andrew Burt, wrote: >> But, seriously, here's one that I haven't researched enough to know >> that it can't be done: >> !!!!…
Re: Database directed system administration ??
krienke@infko.uni-koblenz.de litauer@infko.uni-koblenz.de writes: }We are looking for a database based system for (unix-) workstation }administration. }Using this databasesystem we want eg. to be able to add new users to our }system, or new workstations to our net. }The modificat…
Re: Suggested Changes to 4gl
Quoting Paul Mahler... } } So far the only responses I have received have been suggestions } for changes to the input array statement. Is everyone really } this satisfied with 4gl? Is there nothing else we can } complain about? } Mmmm... exactly what are you getting at? If this…
Re: Suggested Changes to 4gl
Hi Paul, I've had a feature on request for a long time. I don't know the status but I would very much like to see the ability to fill a screen record both horizontaly and vertically. ie. row 1 row 6 row 11 row 2 row 7 ..etc row 3 row 8 row 4 row 9 row 5 row 10 Cu…
Re: SQL 2.10.03 problem: cannot UPDATE table
In article <Dec.10.18.05.40.1992.25678@net.bio.net> charleen@net.bio.net (Charleen Bunjiovianna) writes: |A user wants to delete a row from a table. The query: | |delete from ft |where entry_name = "P90589"; | |dies with: | | 263: Could not lock row for UPDATE. | |There is no p…
Re: Informix 4.0 and AIX 3.2
In article <jgabriel.723504339@academ01> jgabriel@academ01.mty.itesm.mx (Ing. Juan Gabriel Ruiz) writes: >Actually I'm running Informix Online and Standard Engine under AIX 3.1.5, >both of them work fine. Now I'm trying to make an operating system upgrade >to AIX 3.2, and my ques…
Is this an enhancement?
We have an ace program which is supposed to print 1 line of data for further processing by other processes. The programmer is question used a 'FIRST PAGE HEADER' construct to ensure that only one row was printed. Everything is fine and dandy - and then along comes 4.1. Now 'P…
Re: ESQL C problem with sqlerrd[2]
In article <1giuitINNcgq@emory.mathcs.emory.edu> kristen.m.altman@ccd.harris.com (Kristen Altman) writes: >In my application, I am using ESQL C 4.1 and formatting dynamic SQL stmts. > >After the first fetch the number of rows returned in sqlerrd[2] >is 0, but the sqlca.sqlcode = …
Systables problems
>The error message returned from either prepared select statements or >normally coded select statements are as follows : > >SQL statement error number -211 >Cannot read system catalog (systables). >System error number -101. >ISAM error: file is not open. > >Any ideas/help would b…
Suggested Changes to 4gl
Hello the net, So far the only responses I have received have been suggestions for changes to the input array statement. Is everyone really this satisfied with 4gl? Is there nothing else we can complain about? Paul Mahler -- ---------------------------------------------------…
INFORMIX how many records ?
Hi, I have a simple, maybe a FAQ question. How many records INFORMIX can handle - (a real value!) ? Where are a big databases which are maintened by INFORMIX programs - some e-mail addresses please. Krzysztof (Chris) Kosarzycki p.s. E-mail address of persons who write…
ESQL C problem with sqlerrd[2]
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]…
What is INFORMIX-LINK?
Hi, Could someone please tell us what INFORMIX-LINK is? Regards, Verbus M. Counts, AT&T/NCR Customer Support (703) 691-6134 VOICE (703) 691-5659 FAX email: verbus@attmail.com OR ...att!attmail!verbus…
Re: How can i ...
Laurence Humblet writes: >I want to insert a record in a table with a primary key of type SERIAL and >obtain the generated value of the primary key in a variable in my >application. After inserting a record containing a serial field, the value of the serial field inserted is ava…
Re: Two index query optimization problem
> I'm having some problems with Informix over optimizing my query. > I have a table with > 500000 rows and I can't get Informix to > use what I deem to be the "correct" index. > > There are two indexes on the table: > > index1: unique index on A, B; > index2: unique index o…
Re: tbinit suid root (Problem?)
Ross Hagglund writes: > >I was recently talking to a site running online 5.0 and the site >administrator mentioned that he didn't like application software >which was set user id to root. He was particularly concerned with >tbinit since it was "a little more complex than cat(1)".…
Re: turbo extents used
Root@letterkenn-emh1.army.mil writes: >Is there a way in Informix-Turbo (not ON-Line) to determine how many extents >a table is currently using? I figure one of those handy figurest in tbstat >must indicate that.... >Thanks. >Ann Barnes If the table is active (and you can make i…
Re: Help, tbtape is trashing my rootdbs!
Michael Faurot writes: >Here's the problem . . . > > After initializing rootdbs and shared memory without any > difficulties I use ISQL to create a couple of databases, fill > one of them up with records and the other is simply empty. > > Now I wish to back-up this entire configu…
Temporary string storage on MS-DOS
Hello world! This one is dedicated to all those who have ever had to struggle with Informix 4GL for MS-DOS. I've been working for sometime on a project on MS-DOS that uses Informix. The trouble is that one of the programs has grown somewhat large (2 MB on the executable file) a…
Re: Display array highlist
In-Reply-To: <1992Dec10.181239.29704@mnemosyne.cs.du.edu> aburt@mnemosyne.cs.du.edu (Andrew Burt) TITLE: Re: Display array highlist In <1992Dec10.181239.29704@mnemosyne.cs.du.edu> Andrew Burt asks: [Stuff deleted] > But, seriously, here's one that I haven't researched enough …
Re: Display array highlist
In-Reply-To: <1g8h5pINNjhb@emory.mathcs.emory.edu> dccrjc9@bpats (David Stockel) TITLE: Re: Display array highlist In <1g8h5pINNjhb@emory.mathcs.emory.edu> David Stockel writes: [Stuff deleted] > I have written a generic pick1("select key,desc FROM tab"). > It returns the key…
Re: Suggesting changes to 4gl
In-Reply-To: <1g8o6oINNq8c@emory.mathcs.emory.edu> dave.snyder@snide.com (Dave Snyder) TITLE: Re: Suggesting changes to 4gl In <1g8o6oINNq8c@emory.mathcs.emory.edu> Dave Snyder writes: >Quoting David Stockel... >} >} >The top of my list is the input array statement. It is jus…
Re: "WordWrap" and temporary s
In-Reply-To: <randall.723872563@seashore> randall@informix.com (Randall Rhea) TITLE: Re: "WordWrap" and temporary string storage In <randall.723872563@seashore> Randall Rhea writes: [Stuff deleted] > One of the things I like about Informix-4GL is that it does NOT > have all t…
database comparsion: Informix vs. Sybase; any info out there?
The subject line said it all: Is there anything in the FAQ of those news group, or are there any white papers on the subject achived somewhere on the net. Sybase seems to have more support from third-party (middle-ware) vendor and is doing very well these day. However, Informi…
deleting large databses
Hello, I am working in 4GL 4.00 under UNIX, and I need some help to solve this situation: I have a table that holds 12000 rows, this table has 4 indexes, some of them on one column and some combined. I have an initialization process that deletes all of the rows. This p…
Re: Strange Informix form behavior.
I have had the same problem going back a couple of years and discovered that on return to the Master Form, PERFORM displays the screen with most number of fields. Perhaps you have the same problem. There are two solutions to this: 1. Rearrange form so that the first screen has m…
Tripping Server
%UNIPLEX %TO informix-list@rmy.emory.edu %FROM rridley %SYSTEM DHLNET %SUBJECT Tripping Server %VERIFY y %DATE 14/12/92 18:03 %REFERENCE 9241 We are experiencing problems with an application developed using I4GL 4.0, and runni…
thanks + question
Hi, I want to thanks all the people who answered to my question about SERIAL in Informix Database. The answer i received is : SQLCA.SQLERRD[2], but the problem is that i can't find how to access this structure from SQL Windows (thats why i sent the question also to the WIN3-L).…
Two index query optimization problem (fwd)
} I'm having some problems with Informix over optimizing my query. } I have a table with > 500000 rows and I can't get Informix to } use what I deem to be the "correct" index. } } There are two indexes on the table: } } index1: unique index on A, B; } index2: unique index o…
Re: Two index query optimization problem
In article <1992Dec12.000653.7004@anasaz> devin@anasaz (Devin Wala) writes: > > >There are two indexes on the table: > > index1: unique index on A, B; > index2: unique index on C, D, A, B; > >The problem I'm having is that I can't run a query with A and B mentioned >in the WH…
Re: INFORMIX 4.1 (ISQL & ESQL/C) FOR MS-DOS
>In article <1992Dec12.042750.8222@informix.com>, aland@informix.com (Colonel Panic) writes: > In article <1992Dec10.184110.10331@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: > >I need Informix's 4.1 SE ISQL & ESQL/C for DOS - single user version. > > > It was my understa…
Re: Configuring locks on a Sun 4 for I-SE 4.10
In article <OLIVER.92Dec9230440@snoopy.infix.de> oliver@infix.de (Oliver Okrongli) writes: >Dear netlanders, > >Please apologize if the following question is a RTFM. We just did a >port on a customer configured system and do not have access to all >documentation that might be ou…
Re: INFORMIX 4.1 (ISQL & ESQL/C) FOR MS-DOS
In article <1992Dec10.184110.10331@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: >I need Informix's 4.1 SE ISQL & ESQL/C for DOS - single user version. > >I currently have: Cost to upgrade to 4.1 (with 1 yr support): It was my understanding that .06 - 4.1 …
Re: "WordWrap" and temporary string storage
>>One of the things I like about Informix-4GL is that it does NOT >>have all them "bells and whistles." This is also why I and many other >>people like C. Why have all those huge libraries filled with crud >>you'll never use? ... >Here I have to disagree with you. Are you sug…
Two index query optimization problem
I'm having some problems with Informix over optimizing my query. I have a table with > 500000 rows and I can't get Informix to use what I deem to be the "correct" index. There are two indexes on the table: index1: unique index on A, B; index2: unique index on C, D, A, B; …
Job Opportunity, Medical Databases
The Division of Surgery at Rush-Presbyterian-St. Luke's Medical Center is seeking an imaginative, creative programmer to help with its Surgical Information System project. This project already manages most surgery and pathology information for one of the largest surgical divisio…
help:memory space error
Hai, Iam a novice user of informix-4gl ver 1.10 .When i try to load a file by the modify option, Iam getting the error "Insufficient memory space".Part of the program is culled out .The number of lines so loaded varies from 140 to 150 for different programs.Iam not able to trac…
Dirty Read & Upd.Statistics
Hey expert ! I have a question, which you may be able to answer. Could there be any problem if in an online system you have to processes, which executes in parallel, when the 2 processes are: 1 Update statistics ... …
Re: "WordWrap" and temporary string storage
> ... I am a die-hard supporter >of Informix-4GL because it is superior to the other tools I have used. Ditto. I agree or I wouldn't be wasting this much energy talking about the changes I would like to see. >One of the things I like about Informix…
SQL 4.0 QUESTION
STUPID QUESTION: I am teaching myself Informix-SQL ...I am trying to find out if and how to do it- CAN AND HOW CAN I TAKE A SYSTEM DBASE PROGRAM FROM DBASE III AND TRANSFER IT TO INFORMIX-SQL? I have not tried, but I guess I can transfer the data into ASCII and then upload it t…
Re: Excellent article on Temp. String Space
In <1992Dec9.231353.2343@panix.com> clay@panix.com (Clay Irving) writes: >I've found this to be an excellent discussion of temporary string space in >Informix-4GL. The author is Loren West of FourGen Software, Inc. >(uunet!4gen!lorenw) > Temporary Strin…
VAX COBOL TO INFORMIX CONVERTERS
VAX COBOL Does anybody know of a Converter from Vax Cobol to Informix Obviously I would prefer a conversion to 4GL but I imagine this is being a little to hopeful so ESQL-C / ESQL-Cobol would do. I know that there is a company in the US doing this but I don't know any names. P…
SQL 2.10.03 problem: cannot UPDATE table
A user wants to delete a row from a table. The query: delete from ft where entry_name = "P90589"; dies with: 263: Could not lock row for UPDATE. There is no possibility the table or row is being used by anyone else. A number of other rows have been deleted from the same t…
Re: Suggesting changes to 4gl
Quoting David Stockel... } } >The top of my list is the input array statement. It is just } >good enough to get you in trouble. For example, it's a drag } >only being able to display all the elements of a program array } >to a screen array. } } How about a Highlite Row option i…
Re: Display array highlist
>>> Anyway, how many people would like a generator that >>> creates popup style lookup windows that have a full reverse video line and >>> use dynamic memory? > >> !!!!!! ME !!!!!! (Pathetic aren't I) > >Well, me too, but I _really_ want a little more... > > - I want a gene…
re: Re: Another one for the panel.
I posted an earlier message which read, in part: [more stuff deleted] >> OPTIONS MENU LINE OFF/ON >> PROMPT LINE OFF/ON >> COMMENT LINE OFF/ON >> ERROR LINE OFF/ON >> >> These would give us programmers full control over the 4GL screen >> …
Strange Informix form behavior.
I have a perform problem that I can't resolve. I have a form that has a master/detail relationship. The master table has three screens of data and the detail table has one screen. The problem I have occurs when I do the following: 1 - Enter sperform to display the form. The …
INFORMIX 4.1 (ISQL & ESQL/C) FOR MS-DOS
I need Informix's 4.1 SE ISQL & ESQL/C for DOS - single user version. I currently have: Cost to upgrade to 4.1 (with 1 yr support): upgrade docs total ISQL 2.10.06 $218 + $55 $273 ESQL/C 2.10.06 …
Re: Display array highlist
In <memo.800021@cix.compulink.co.uk> shemminga@cix.compulink.co.uk (Stuart Hemming) writes: >In-Reply-To: <1g3gavINNg35@emory.mathcs.emory.edu> dave.snyder@snide.com (Dave Snyder) >TITLE: Re: Display array highlist >> Anyway, how many people would like a generator that >> crea…
Re: How can i ...
> I'm programming in SQL Windows on a PC. I acces an Informix Database on a > Unix machine via a gateway. > > I want to insert a record in a table with a primary key of type SERIAL and > obtain the generated value of the primary key in a variable in my > application. If I do a > …
Re: Suggesting changes to 4gl
>The top of my list is the input array statement. It is just >good enough to get you in trouble. For example, it's a drag >only being able to display all the elements of a program array >to a screen array. How about a Highlite Row option in DISPLAY ARRAY/INPUT ARRAY? How abou…
PERFORM Gurus -- Please help
Fellow Informixers, Here is an implementation question using informix forms. I have one field in an informix forms screen that is a join between two tables, and other fields are populated based on the join between the two tables. HOW DO I populate the screen based on the reco…
multi-user Wingz application
A question to any Wingz gurus out there: I am developing an application in Wingz which I am now making multi-user. More then one user would open the same worksheet and front end to a database. The worksheet will NOT have write permission set, but currently is set at 666 (read/…
Re: Another one for the panel.
In-Reply-To: <1g2pfmINNm3c@emory.mathcs.emory.edu> bwilliam@ssblan.ssc.af.mil TITLE: Re: Another one for the panel... In <1g2pfmINNm3c@emory.mathcs.emory.edu> bwilliam@ssblan.ssc.af.mil writes: [Stuff deleted] > Yes, it would. I've been begging Informix for this kind of …
Re: Display array highlist
In-Reply-To: <1g3gavINNg35@emory.mathcs.emory.edu> dave.snyder@snide.com (Dave Snyder) TITLE: Re: Display array highlist In <1g3gavINNg35@emory.mathcs.emory.edu> Dave Snyder writes: [Stuff deleted] > Anyway, how many people would like a generator that > creates popup style lo…
How can i ...
Hi, I'm programming in SQL Windows on a PC. I acces an Informix Database on a Unix machine via a gateway. Here is my problem: I want to insert a record in a table with a primary key of type SERIAL and obtain the generated value of the primary key in a variable in my applicatio…
study on replacement of information technology
At the Haas School of Business, University of California at Berkeley, we are doing a study of what factors influence the decision to replace old information technology/products with new information technology/ products. If you were involved with such a technology replacement sit…
Re: "WordWrap" and temporary string storage
In article <1992Dec7.181455.1520@anasaz> briand@anasaz (Brian Douglass) writes: >>According to a mail response I've received, what I'm seeing may be bug #13375. >>I haven't been able to get on to INFORMIX-LINK to confirm this; could some one >>post, or mail me, the description of…
Re: PC DOS 4GL
In article <503@rhlab.UUCP> kuhn@rhlab.UUCP (mjk Michael Kuhn) writes: >When using the "run" command in 4gl application > that executes a .bat file > that does > set DBPRINT=lpt1 > 4glprog parm1 parm2 parm3 > >I get this error message > Spawn failed…
tbinit suid root (Problem?)
I was recently talking to a site running online 5.0 and the site administrator mentioned that he didn't like application software which was set user id to root. He was particularly concerned with tbinit since it was "a little more complex than cat(1)". No amount of reassurance wo…