Threads from 1993
Browse by month: Jun · Jul · Aug · Sep · Oct · Dec
Informix Product Architecture v. Oracle 7 (and others)
Hello to all you architecture folks . . . I'm trying to compare the components of Oracle and Informix (I'll add Sybase for interest's sake, but Oracle and Informix are my focus for now). The example requirements: one or more MS Windows PCs communicating over TCP/IP with two or…
Re: Informix jobs 2/2
In article <yosemiteCIvtyE.FCM@netcom.com> yosemite@netcom.com (Scott Davis) writes: >In article <bobbCICpJB.D5H@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: >|First of all, I thought it was illegal to advertise on the internet for >|commercial purposes? I cannot advertise…
Informix Online 4.0
Hello, everyone! Is there a central place I can get a text listing of the current but list for Informix Online 4.0 for Interactive Unix 3.2? I also would be interested in a listing for Informix ESQL/C 5.00.UD2. Thanks! Have a safe and happy New Year! Ray eapc-amo2@korea-emh7…
Re: Bugs/Tricka with Informix 5.xx
Yogen Sangani writes: >1> I-STAR 5.01.UD3 has a bug that doesn't allow more than one client >connection at a time. The only way around is to install I-STAR or >I-NET 5.01.UD2 in a seperate directory, copy sqlexecd from that >directory to your $Informix/lib directory. It took 8…
Re: Informix jobs 2/2
In article <bobbCICpJB.D5H@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: |First of all, I thought it was illegal to advertise on the internet for |commercial purposes? I cannot advertise my business on the net via the news |feed, so what gives? How about we just let everyo…
Re: 4gl improvement thoughts
How about a full maths function library? Rob. -- \\ = ,_|\\ < []_[]= | Rob Mascaro email: Rob@DIALix.oz.au / \\ /\\/(_)\\|/|\\ Systems Administrator phone: +61 9 4251804 <* …
Re: Back-ups to Disk?
John Powell (johnpo@vcd.hp.com) wrote: : This post is related to an earlier one about logical logs and named pipes. : I realize that Informix only supports archives and logical logs going to : tape (via tbtape on Rel. 5) at this time. However, I would like the archive : and …
Re: INFORMIX ON-LINE (v5.0) asyncronous backups
>From: artur@morgaine.fct.unl.pt (Artur Romao) >Subject: INFORMIX ON-LINE (v5.0) asyncronous backups >Date: Thu, 30 Dec 1993 11:43:15 GMT > >Hi, > >I would like to know if anyone could help me in the following question: > >Is it possible to make on INFORMIX ON-LINE version 5.0, a…
Re: Bugs/Tricks with Informix 5.xx
In article <1993Dec30.181559.15028@cronkite.ocis.temple.edu>, yogen@astro.ocis.temple.edu (Yogen Sanghani) write > > Quality of Informix Tech support > ------------------------------- > From my experience with Imformix tech support during the course of this > project I think that…
Re: Informix jobs usa
In article <1993Dec29.171250.2205@fripp.ri.cadre.com> 75110.1120@compuserve.com writes: > >In article 000A1B38@promus.com, mbehna@promus.com (Michel Behna) writes: >>In article <bobbCIqKoD.G9D@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: >>>From: bobb@netcom.com (Bob Beauli…
Bugs/Tricks with Informix 5.xx
I am presently involved in migrating a client's computing environment from Sparc 10/SunOS 4.1.3/Informix OnLine 4.11/FourGen accounting to Sparc 1000/Solaris 2.3/Informix OnLine 5.01/FourGen Accounting and there are a lot of glitches that I have encountered, some of which are wor…
INFORMIX ON-LINE (v5.0) asyncronous backups
Hi, I would like to know if anyone could help me in the following question: Is it possible to make on INFORMIX ON-LINE version 5.0, asyncronous backups, i.e., create a batch-job on crontab (or something similar). The objective is to avoid the necessity of backups during the dai…
ESQL-C - Errormessages
Hello Informix users from the "C" world! I have a problem to get the correct error messages in to my "C" world. When using the "rgetmsg"-function (ESQL/C, p7-13), I get e.g. the following result: The specified table (%s) is not in the database My problem is how to resolve th…
Re: Back-ups to Disk?
I received the forwarded message with this question so I am responding to the list. We have done the backups to disk and restored from them. To do this you need to create an empty file such as with touch. You then set your device to be the filename with the full path. I think…
Re: Back-ups to Disk?
Ok we do automated level 0 backups of informix DBSpaces using tbtape to disk. We dont do logs. However, i would imagine this will work either way. Set you tape device to /filesystem/filename, then touch /filesystem/filename as informix (eg owner informix.informix). This works u…
Wingz/Datalink Date Download problem
I recently tried to download a bunch of data from my Informix Online database into Wingz 1.1. In the data was a date field which contained dates from the 21st century (i.e. 1/1/2012). The only problem was it converted all my 21st century dates to 20th Century dates (1/1/2012 be…
re: informix jobs
gentlemen, mr carroll's most recent posting to the informix list has generated no less than 9 responses - most complaining this is not the forum for such postings and the excess bandwidth that is being used. if you object to this type of posting, mail directly to the person pos…
Back-ups to Disk?
I have doing backups to disk for about 2-1/2 years. I created a very large disk partition for my archive to go to. After the archive runs at night, this unix file is taken off on tape. The only problem I have had is when my backup partition is not large enough. My current bac…
Re: Informix jobs
In article <1993Dec28.151735.9599@fripp.ri.cadre.com> you write: } } Let them post. I have been using Informix 4GL now for almost nine full years and maybe one of the longest users of Informix 4GL from when I beta tested it back in 1985, and if helps the users (including program…
C-Isam_2_Sql converters ?
Hello, I am looking for a converter tool(s) that could translate C_ISAM programs into SQL programs. If you have any info on freeware or commercial products please let me know, Because this is _VERY_ important for a friend. The dbms that was used is Informix,(i.e C-ISAM stuff r…
Informix Client/Server products on unsupported network
Hi, I need to implement Informix client/server products such as 4GL for Windows in the following environment: Token Ring network with several OS/2 Servers running IBM LAN Server, 1 SCO Unix Server running TCP/IP, truckloads of PCs running IBM LAN Support Program and Frontier …
Re: Automated On/Offline during Machine reboot/shutdown, how?
In <CIrEBE.Gqr@Colorado.EDU> huangp@nots.Colorado.EDU (Pei-yu Huang) writes: | I wrote the following script and saved it in /etc/init.d/informix: | and had /etc/rc0.d/K01informix and /etc/rc2.d/S99informix linked to it. | The "stop" switch appeared to work, for I got a new "shu…
Re: Shutdown/Startup Script
Pei-yu Huang writes: [stuff deleted] >case "$1" in > 'start') > if [ -f /usr/informix/bin/tbinit] > then > /usr/informix/bin/tbinit > echo 'startup INFORMIX engine'>>/etc/tmp.log > date >>/etc/tmp.log > else > …
Back-ups to Disk?
This post is related to an earlier one about logical logs and named pipes. I realize that Informix only supports archives and logical logs going to tape (via tbtape on Rel. 5) at this time. However, I would like the archive and logical logs to go to disk from which they can b…
prepared insert into a synonym
I have a question about preparing an insert into a synonym. I have created a synonym to a table in another database on another platform. When I prepare an insert statement into that synonym I get a "table not found in database" error. The error message contains garbage charact…
Automated On/Offline during Machine reboot/shutdown, how?
I wrote the following script and saved it in /etc/init.d/informix: ------------------------------------------------------------------- #! /sbin/sh #Tag 0x00000f00 # # startup/shutdown INFORMIX engine # $Revision: 0.1 $ case "$1" in 'start') if [ -f /usr/informix/bin/tbinit]…
Re: Informix jobs usa
In article <mbehna.17.000A1B38@promus.com> mbehna@promus.com (Michel Behna) writes: >In article <bobbCIqKoD.G9D@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: >>From: bobb@netcom.com (Bob Beaulieu) >>Subject: Re: Informix jobs usa >>Date: Tue, 28 Dec 1993 08:24:10 GMT > >>>Se…
4gl improvement thoughts
I was chatting with tech support a while back, and mentioned I had a "wish list" for enhancements to 4gl to turn it into a significantly more enjoyable language to program in... I was asked to mail it, but I thought since there are so many @informix.com's on here I'd also post i…
re: How to determine the DBSpace a table...
Glen, if you are looking at a specific table(as apposed to all tables in a dbspace), then do the following: isql databasename select tabname, hex(partnum) from systables where tabname = 'your_table' this should yield the following output (your only interested in the…
Re: OnLine 5.00 database corruption [BUG FIXED]
>>>>> On 24 Nov 1993 14:16:57 GMT, Jim Burks <jburks@promus.com> said: > NNTP-Posting-Host: jburks.promus.com > In article <OLIVER.93Nov19180330@test.infix.de> (Oliver Okrongli) writes: >>We just experienced inconsistencies in OnLine 5.00 databases on two >>different ports. It …
Re: Informix jobs usa
In article <bobbCIqKoD.G9D@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: >From: bobb@netcom.com (Bob Beaulieu) >Subject: Re: Informix jobs usa >Date: Tue, 28 Dec 1993 08:24:10 GMT >>Send your resume to: Donna Frappier >>SYSTEMS PERSONNEL Phone: 413-592-406…
Re: Informix jobs usa
>Send your resume to: Donna Frappier >SYSTEMS PERSONNEL Phone: 413-592-4069 >P.O. Box 63 Fax: 413-592-9255 >Chicopee, MA 01014 BBS: 413-592-9208 >-------------------------------------------------------------- Ed must wheel…
SCO MPX 3.0
Has anyone had any experience running the version 5 Online engine on an SCO Unix system with the latest MPX 3.0? Did you notice any peculiarities that had not existed before?…
4gl problem-jmuss
4gl problem of not seeing "updated" data when doing a next and previous fetch after doing an update. What you are fetching has already been retrieved from the database when you prepared and carried out cursor activities. The "old" data is still in the memory locations you fetche…
Re: 4gl problem
John Musselman writes: > My Prob: The date is updated, BUT if a user updates a row and the does a next > followed by a previous (fetch_next and then a fetch_prev) the data displayed is > the OLD data... but if the user selects the same row on a subsequent query, it > refelects t…
Re: 4gl problem
In article <CInMq8.C5q@news.direct.net> you write: } I have 4gl 4.00.UC1 for Interactive Unix... I am having the following problem. } } I have written a module that queries from 2 tables (using an outer join) with a } scroll cursor. The user (after querying) can then update one o…
Re: How to determine the DBSpace a table is in?
Glen Gordon (ggordon@agsm.ucla.edu) wrote: : Using Online 5.0, how can one determine which DB Space a table resides : in? Any help greatly appreciated. In 4.1 (presumably the same in 5.0) it's almost impossible without getting really ugly. What I do is: Every morning c…
How to determine the DBSpace a table is in?
Using Online 5.0, how can one determine which DB Space a table resides in? Any help greatly appreciated. --Glen -- Glen Gordon | Internet: ggordon@agsm.ucla.edu Computing Services | Bitnet : ggordon@uclagsm.bitnet Anderson Graduate School of Management | AT&Tnet : (310) 2…
4gl problem
I have 4gl 4.00.UC1 for Interactive Unix... I am having the following problem. I have written a module that queries from 2 tables (using an outer join) with a scroll cursor. The user (after querying) can then update one of the rows that are returned by using fetch_next and fetch…
Re: WingZ - nobody knows ???
Well, they're raking in the cash from their database licenses and new support contract proceedures. Why should they waist their time with Wingz when they can keep hosing us? -- Unix at Home perk machine Joseph A. Miele jam@perk.jpr.com Dir MIS Spectraserv, Inc. …
convert interval to decimal
I need to do some simple arithmetic using a field defined as INTERVAL in the instructions section of a form specification. The INTERVAL field contains hours and minutes. I need to convert this to minutes or hours so that I can multiply it by a field defined as MONEY. Can anyon…
Re: DBEXPORT and UPDATE STATISTICS
Dear Everybody, Several people have commented (very gently, and thank you for being careful of my ever so delicate feelings;-) that dbexport is unlikely to do UPDATE STATISTICS on any of several grounds -- such as not being able to find the string 'update statistics' in the exec…
Re: dbexport + update statistics
> >From: brunner@gdc.COM (Paul Brunner) > >I have a simple question about the dbexport utility as a point of curiosity. > > I have a simple answer which may satisfy your curiosity: Yes. > > Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> I'm sorry to take exception…
Re: Tracing sqlturbos on hosts to client processes
> Jim Gordon writes: > > The sqlturbo is the server process for the client program. Its parent > > is the client process, on a unix box the PPID of the sqlturbo is the > > PID of the client process if they are running on the same box. Use ps > > -fu. > Fine if you're on the sam…
ISQL Select Database slow
Hi, I'm running Online 5.1, HP 9000/755, HP-UX 9.01, 512 MB RAM. Two machines with identical installations of Online, same database schemas, different data. On one of the machines, when I run ISQL, Database menu, "Select", ISQL sits there for a looong time or until I pres…
Re: dbexport + update statistics
> I have a simple question about the dbexport utility as a point of curiosity. > Does it issue a 'update statistics' command as part of its work? > > -- > Paul D. Brunner, Software Engineer | "... for whom talk is like a sea on No, Informix tends towards minimalism. They al…
Re: Memory problems. . .
>From: M23443@mwvm.mitre.org (Michael Gibson) >Subject: Memory problems. . . >Date: Tue, 21 Dec 93 14:25:44 EST >X-Informix-List-Id: <news.5156> > >I am trying to increase the amount of memory Informix can use. So far I >have had no luck. I attempted to create a new dbspace and…
Re: dbexport + update statistics
>From ilist@rmy.emory.edu Wed Dec 22 23:22:16 1993 >From: brunner@gdc.COM (Paul Brunner) >Subject: dbexport + update statistics >To: informix-list@rmy.emory.edu X-Informix-List-Id: <news.5152> > >I have a simple question about the dbexport utility as a point of curiosity. I have…
Re: WingZ - nobody knows ???
In comp.databases.informix, spitz@GAN03X (Richard Spitz) writes: >Brian O'Sullivan (bosulliv@mitre.org) wrote: >: I've become increasingly frustrated with Informix for the way they >: have dragged this out. We met with our sales rep & VP sales in early >: November to discuss our…
Re: WingZ - nobody knows ???
Brian O'Sullivan (bosulliv@mitre.org) wrote: : I've become increasingly frustrated with Informix for the way they : have dragged this out. We met with our sales rep & VP sales in early : November to discuss our concern that Informix would not continue to : support us Mac users. …
Re: Tracing sqlturbos on hosts to client processes
Jim Gordon writes: > > Ed Hobbs writes:- > > Question: Is there a way to trace an sqlturbo on the host to it's > > server process? > > The sqlturbo is the server process for the client program. Its parent > is the client process, on a unix box the PPID of the sqlturbo is the > P…
Monthly Posting from Snide Computer Services
Last-Modified: Thu Nov 18 10:33:13 EST 1993 This is a monthly posting from Dave Snyder, keeper of db4glgen. Although this is probably old information for alot of you, I find that about once a month or so, I'm asked, "What is db4glgen?"... "Where can I get dbinfo?" Well here are…
faq?? raw device vs. cooked file
Sorry if this is a faq, I do remember seeing this discussed a while back ago, but I didn't keep any of the articles. If there is a compilation of this topic, can some please send it to me. Q. How much of an increase in perfomance can one expect by switching to a raw device? Bac…
Re: Tracing sqlturbos on hosts to client processes
Ed Hobbs writes:- > Question: Is there a way to trace an sqlturbo on the host to it's > server process? The sqlturbo is the server process for the client program. Its parent is the client process, on a unix box the PPID of the sqlturbo is the PID of the client process if they a…
termcap vt220
Hi netters, My termcap entry for a vt220 does not have the graphic and color capabilities, and I don't have the manual for a vt220 terminal. Anybody have a vt220 entry already set up? Thanks in advance for any help. Chuck Drolsbaugh…
Re: Informix jobs
Alan Popiel (alan@po.den.mmc.com) wrote: : ->From: Dave Snyder <dave.snyder@das13.snide.com> : ->Subject: Re: Informix jobs 1/2 : ->To: ed.carroll@channel1.com : ->Date: Mon, 20 Dec 1993 10:02:32 -0500 (EST) : ->Cc: informix-list@rmy.emory.edu (INFORMIX Mailing list) ...…
dbexport + update statistics
I have a simple question about the dbexport utility as a point of curiosity. Does it issue a 'update statistics' command as part of its work? -- Paul D. Brunner, Software Engineer | "... for whom talk is like a sea on General DataComm Industries, Inc. | which to float. T…
Need help with DISPLAY ARRAY problem.
Subject: Need help with DISPLAY ARRAY problem Date: 22 Dec 1993 10:48:03 -0500 Hi John, Here is a solution to your problem. Just include CALL SET_COUNT() to your code as described below. > I need some help. I am new to Informix - so new I am using > Informix 4GL 1.10. I a…
Re: Need help with DISPLAY ARRAY problem
From John O'Sullivan: * * * * Hi, * * I need some help. I am new to Informix - so new I am using * Informix 4GL 1.10. I am learning this using the Users Guide but applying * it to my own application. I am having the following problem: * * OPEN FROM fba_stats FROM "fba_stats"…
Tracing sqlturbos on hosts to client processes
Background: We're running Online 5.00, I-Star 5.00 and 4GL/SQL 4.10 on RS/6000's. Question: Is there a way to trace an sqlturbo on the host to it's server process? -- / __ \\/ /__ ___ / /_____ ____ ____ ___ Ed Hobbs / /_/ / / _ \\/ __/ __/ ___/ __ \\/ __ `__ \\ Database…
Re: Question about "prepare statements"
From A. J. Dibbins: * * Hi, * * My question is this, I am assured that both of these examples work on most * machines, but my Sun running Sunos 4.1.1 and I4GL v4.0 complains about the * first example. * * Eg1 * * prepare s1 from "insert into fred values (?,?,?,?) * …
Re: Informix jobs
In article <2f8gufINNa4p@emory.mathcs.emory.edu> dave.snyder@das13.snide.com (Dave Snyder) writes: >In article <2f75iaINN4h2@emory.mathcs.emory.edu> you write: >} >} If everybody would just relax and ignore the postings that irritate you, life >} would be a lot less stressful. T…
Re: Need help with DISPLAY ARRAY problem
}Date: Wed, 22 Dec 93 7:25:48 PST }From: John O'Sullivan <johno@access.isc-br.com> }Subject: Need help with DISPLAY ARRAY problem }X-Informix-List-Id: <list.3255> } I need some help. I am new to Informix - so new I am using }Informix 4GL 1.10. I am learning this using the User…
Online 5.01 Installation problems on SPARC 2000
Hello Informix-Installation specialists!! We have a problem with the installation of Informix 5.01 on a SPARC station 2000 under Solaris 2.2. The problem only occurs when trying to install it for about 60 or 70 users, for 32 it works fine. The messages seem to indicate a proble…
Re: Question about "prepare statements"
>Date: Wed, 22 Dec 93 09:54:39 GMT >From: andy_d@rapier.demon.co.uk (A. J. Dibbins) >Subject: Question about "prepare statements" >X-Informix-List-Id: <list.3251> > >Hi, > >My question is this, I am assured that both of these examples work on most >machines, but my Sun running Su…
Re: Question about Backing-up using a named pipe
I think using a named pipe (instead of a real tape device) is not supported by Informix. This fact is documented in the 5.0 DBA guide. The difficulty in using named pipe arise when dealing with multi-volumes operation. I would be interested to know if this has changed in the O…
Re: Need help with DISPLAY ARRAY problem
->Subject: Need help with DISPLAY ARRAY problem ->To: informix-list@rmy.emory.edu ->Date: Wed, 22 Dec 93 7:25:48 PST ->From: John O'Sullivan <johno@access.isc-br.com> -> ->Hi, -> -> I need some help. I am new to Informix - so new I am using ->Informix 4GL 1.10. I am learning th…
INFORMIX error -837 in MS Windows -- makes no sense
We have been having a random but persistent problem with what appears to be bogus -837 errors appearing on our MS Windows machines. This error purports to be an out-of-memory error. However, we are using 486 machines with 8MB real RAM and plenty of swap space. Furthermore, syst…
Need help with DISPLAY ARRAY problem
Hi, I need some help. I am new to Informix - so new I am using Informix 4GL 1.10. I am learning this using the Users Guide but applying it to my own application. I am having the following problem: OPEN FROM fba_stats FROM "fba_stats" DISPLAY FORM fba_stats DISPLAY ARRAY…
SQL 2.10.03G to Oracle V7.0
I would like email from anyone with experience switching from Informix 2.1 to Oracle 7.0, or perhaps anything close. What tools are available to make this easier? Can one use ANYTHING from Informix database directly, or must it all be re-created. We have no 4GL, only sperform fo…
Question about Backing-up using a named pipe
Hi, Sometime ago somebody mentioned backing up the log files to a named pipe, but they gave a very brief description of how this is done. Could somebody offer a fuller explanation of how to implement this. Thanks Andy ---------------------------------------------------------…
isqlperl 1.2
I've just released version 1.2 of isqlperl. It's available by anonymous ftp from: ftp.demon.co.uk [158.152.1.68] in pub/perl/db/isqlperl/isqlperl-1.2.shar.Z There are quite a lot of new features, mostly things that I've found I needed to add to make it more useful to…
Re: INFORMIX 5.00.UC3 & SunOS 4.1.3 cache long name performance
Are you using and Informix raw partition for the database? If not, I suggest you do. This may solve your problem.…
Question about "prepare statements"
Hi, My question is this, I am assured that both of these examples work on most machines, but my Sun running Sunos 4.1.1 and I4GL v4.0 complains about the first example. Eg1 prepare s1 from "insert into fred values (?,?,?,?) execute s1 using "andy_d","CUSTOMER",…
Re: Informix jobs
In article <2f75iaINN4h2@emory.mathcs.emory.edu> you write: } } If everybody would just relax and ignore the postings that irritate you, life } would be a lot less stressful. The amount of extra email (including this } letter) created by these discussions is silly. } } You also …
Re: NOTRANS in tbstat -u & Extra Back-ends
Edwin Hobbs (ewh@alert.com) wrote: : Background: We're running OnLine 5.00, I-Star 5.00 and 4GL/SQL 4.10 : on RS/6000's. : Also does anyone know why isql/dbaccess takes sooo long sometimes : to exit? I wonder if there's a connection? Is this over an I-Star link? I…
Wildcards in Hyperscript ??
Netters, I am using Informix Hyperscript Tools with I-Net PC 4.10 and SE 4.0 and would like to know if there is a wildcard available in Hyperscript similar to the wildcard * used with "MATCHES" in SQL Helen Beens CSIRO Division of Entomology CANBERRA ACT 2601…
NOTRANS in tbstat -u & Extra Back-ends
Background: We're running OnLine 5.00, I-Star 5.00 and 4GL/SQL 4.10 on RS/6000's. Question: Is there a relationship between "tbstat -u" transaction entries with a NOTRANS isolation level and runaway turbos (turbos with no front-end process.) I have noticed a definite…
Did Price Change Happen
Did a informix price change happen???…
Memory problems. . .
I am trying to increase the amount of memory Informix can use. So far I have h ad no luck. I attempted to create a new dbspace and a new chunk, but now for s ome inexplicable reason I get the following errors: 529: Cannot attach to shared memory 123: ISAM error: no sh…
Re: Informix jobs
In article <2f75iaINN4h2@emory.mathcs.emory.edu> khovanes@crackers.b30.ingr.com writes: >Dear Bob Beaulieu and the whole informix mailing list, Here I am to save the day! ;-) >[job junk from donna frappier deleted] >You say... >>First of all, I thought it was illegal to adverti…
Errcode -1268 **HELP**
SORRY :-( i forgot to mention that this only happens once in a while, I've seen it two times this month, the program runs every day. Original posting : Problem : Receiving error code -1268 when selecting field which is NOT a DATETIME or INTERVAL field. Descript…
Re: Informix jobs
Dear Bob Beaulieu and the whole informix mailing list, [job junk from donna frappier deleted] You say... >First of all, I thought it was illegal to advertise on the internet for >commercial purposes? I cannot advertise my business on the net via the news >feed, so what gives?…
RAIDs on large data bases
There are currently some significant discussions taking place on comp.databases.oracle and comp.databases.ingres about the use of RAIDs on large databases requiring really fast I/O. These discussions should also be of a lot of interest to Sybase and Informix users. There are, o…
Errcode -1268 ** HELP **
Problem : Receiving error code -1268 when selecting field which is NOT a DATETIME or INTERVAL field. Description : on a table made up by 110 fields total 616 Bytes, I select a CHAR(10) field which is the primary key, to check for existance : $prepare aq1 from…
THANKS for the help
Just a quick THANKS to those that responded with help on my "Urgent" Informix problem. Quite a few responded and I haven't been able to get back to everyone. Anyway, Happy Holidays to ALL. < Robert…
Simultaneous Access to SE and Online
Is it possible to access both an Online and a SE database from within the same program? I have to write an application that archives records from a SE database to an Online database (no, I cannot move the SE database itself to Online since there are C-ISAM applications running o…
Accounting Programs
Our company is currently running Fourgen Accounting on our Informix engine and we are not pleased with the Product. Does anybody know of any other Accounting Programs that runs under Informix and has a job costing module. -- Unix at Home perk machine Joseph A. Miele …
Re: Help with INFORMIX error message
}> I'm experiencing a problem with a INFORMIX 4GL program }> that I'm hoping someone has seen before and can offer a }> solution. }> }> The error message I'm getting is: }> }> SQL statement error number -242 }> ISAM error number -2 }> Could not open database table (profile). }…
Re: Help with INFORMIX error message
> > > I'm experiencing a problem with a INFORMIX 4GL program > that I'm hoping someone has seen before and can offer a > solution. > > The error message I'm getting is: > > SQL statement error number -242 > ISAM error number -2 > Could not open database table (profile).…
Re: Help with INFORMIX error message
>From: rmcewen@vms1.bbn.com (Regis McEwen) >Subject: Help with INFORMIX error message >Date: 20 Dec 1993 22:45:30 GMT >X-Informix-List-Id: <news.5133> > > I'm experiencing a problem with a INFORMIX 4GL program > that I'm hoping someone has seen before and can offer a > solution. …
INFORMIX 5.00.UC3 & SunOS 4.1.3 cache long name performance
We have a network management station controlling and collecting statistics from a 14 node Frame Relay Network. Data is received on a 9.6k link , and stored in the INFORMIX database. An application function seems to hang probably during a write to the database. sunOS performance …
Re: change compiler name in 4gl?
>From: bud@mtek.com (Bud Hovell) >Subject: change compiler name in 4gl? >Date: Mon, 20 Dec 93 16:37:48 GMT >X-Informix-List-Id: <news.5131> > >Can one change the name of the C-compiler name sought by Informix 4GL from >"cc" to, say, "gcc"? Is there an environmental variable that …
Re: Informix jobs
Bob Beaulieu writes: > > Thirdly, why not simplify the process with 1 posting that goes something like: > > Numerous computer related position available. If you want more info and/or > want to be included on a regular mailing list, e-mail me at: e-mail_address. > Or call Donna …
Help with INFORMIX error message
I'm experiencing a problem with a INFORMIX 4GL program that I'm hoping someone has seen before and can offer a solution. The error message I'm getting is: SQL statement error number -242 ISAM error number -2 Could not open database table (profile). Does any know the…
Re: Informix jobs 2/2
In article <40.37.1554.0NE15311@channel1.com> ed.carroll@channel1.com (Ed Carroll) writes: >>>> Continued from previous message >DUTIES: Design, development, of client server applications > using GUI and object-oriented techniques and tools. > Must h…
Re: Informix jobs
->From: Dave Snyder <dave.snyder@das13.snide.com> ->Subject: Re: Informix jobs 1/2 ->To: ed.carroll@channel1.com ->Date: Mon, 20 Dec 1993 10:02:32 -0500 (EST) ->Cc: informix-list@rmy.emory.edu (INFORMIX Mailing list) -> ->Quoting Ed Carroll... ->} ->} POSITION: Jr. …
Re: HELP: Building Custom runner for DOS
From Chris Silvester: * * Has anyone tried to do this (using the cfglgo comand)? Better still, * does anyone have an example makefile that does this? I keep running * into various and sundry problems...A makefile example would probably * answer most of my questions. If you are…
change compiler name in 4gl?
Can one change the name of the C-compiler name sought by Informix 4GL from "cc" to, say, "gcc"? Is there an environmental variable that can be set? Please email, since the news expires *very* quickly here. Thanks! -- _____________________________________________________________…
Re: WingZ - nobody knows ???
At the Informix Worldwide User Conference last July, the message was that Wingz would stop at version 2.0, and any future spreadseheet development from Informix would be included in HyperScript Tools. HST includes a spreadsheet tool which is essentially Wingz 2.0. Since then, I …
Re: Informix jobs 1/2
Quoting Ed Carroll... } } POSITION: Jr. and Sr. level Programmer/Analysts } LOCATION: New Hampshire } REQUIRED: C, Unix, RDBMS, 4GL } HELPFUL: Informix, CASE tools } DUTIES: Analysis, design, development of applications using } structured …
HSTools
Has anyone succseeded in compiling the external examples with visual C++ 1.0 (from MicroSoft). I don't know what compilerswitches are needed (Makefiles only cover Borland C/C++ and MSC8 (whatever this means)). thanx hb…
Problems with Informix 4.1
We have recently upgraded form informix 2.1 to informix 4.1. As a result we are encountering problems which were not present before. We would appreciate any suggestions or inputs in overcoming the same. 1. While compiling a program we encounter the following error "The right mar…
Informix jobs usa
POSITION: Jr. and Sr. level Programmer/Analysts LOCATION: New Hampshire REQUIRED: C, Unix, RDBMS, 4GL HELPFUL: Informix, CASE tools DUTIES: Analysis, design, development of applications using structured methodologies. JOB ID: CMA/SP/12/9/9…
Informix jobs usa 2/2
>>> Continued from previous message DUTIES: Design, development, of client server applications using GUI and object-oriented techniques and tools. Must have good appearance and communication skills. JOB ID: CMA/SP/12/9/93-12 Send your resume to: …
Informix jobs 2/2
>>> Continued from previous message DUTIES: Design, development, of client server applications using GUI and object-oriented techniques and tools. Must have good appearance and communication skills. JOB ID: CMA/SP/12/9/93-12 Send your resume to: …
Informix jobs 1/2
POSITION: Jr. and Sr. level Programmer/Analysts LOCATION: New Hampshire REQUIRED: C, Unix, RDBMS, 4GL HELPFUL: Informix, CASE tools DUTIES: Analysis, design, development of applications using structured methodologies. JOB ID: CMA/SP/12/9/9…
Re: Help with Error -4518
>From: aburt@mnemosyne.cs.du.edu (Andrew Burt) >>From:johnl@informix.com (Jonathan Leffler) >>}From: marchett@eng.gtefsd.com (Tony Marchetti) >>}I was wondering if anyone can help me with a problem I am having when >>}creating a report using INFORMIX-4GL. I am receiving error n…
Re: Help with Error -4518
In <2etm1sINNo8f@emory.mathcs.emory.edu> johnl@informix.com (Jonathan Leffler) writes: >}From: marchett@eng.gtefsd.com (Tony Marchetti) >}I was wondering if anyone can help me with a problem I am having when >}creating a report using INFORMIX-4GL. I am receiving error number -…
Re: WingZ - nobody knows ???
In the UK, Wingz is to be developed to a version 2.0 for Mac and Windows. After that the focus of Informix in this areas will be on Hyperscript Tools (if you like, Wingz, with the focus on hyperscript rather than Spreadsheet) and Viewpoint--a MIS tool for users and DBA's. This is…
Bugs in 5.0?
My site is contemplating upgrading to 5.01 of Informix ESQL/C and Server from version 5.0. One consideration is the bugs fixed in 5.01(5.02?). Can any of you who has information about any known bugs in 5.00 give me some details. Any feedback is much appreciated.…
Re: Help with Error -4518
}From: marchett@eng.gtefsd.com (Tony Marchetti) }Subject: Help with Error -4518 }Date: 17 Dec 1993 19:53:45 GMT }X-Informix-List-Id: <news.5120> }I was wondering if anyone can help me with a problem I am having when }creating a report using INFORMIX-4GL. I am receiving error nu…
Linking GRASS with Informix references wanted
I am trying to link Informix with GRASS using the commands created by Farley and Song, etal. I have read their article "Attribute Management, Data Integration and GIS Links to SQL Databases." It is a good overview, but lacking in any real guidance. Are there any other such ref…
HELP: Building Custom runner for DOS
Has anyone tried to do this (using the cfglgo comand)? Better still, does anyone have an example makefile that does this? I keep running into various and sundry problems...A makefile example would probably answer most of my questions. TIA, Chris S. -- ------------------------…
Re: ON-LINE Backup/Client Serv
Reply to item 8186283 from INFORMIX-LIS sent on 93/12/17 15:22 > Informix tech support told me to run "tbmode -ky" to bring ON-LINE > "off line", reinitialize and then run the dbexport. This doesn't work: > the system is not brought off-line and when I attempt to run "tbinit" …
Help with Error -4518
I was wondering if anyone can help me with a problem I am having when creating a report using INFORMIX-4GL. I am receiving error number -4518 - "The 4GL program cannot allocate any more space for temporary string storage." during executing of my application. Has anyone had any …
Query Optimizer or Lack Thereof
Yet another example of a slooooooow query. This does get frustrating because there are too many times that a perfectly good query has to be split into parts (ie. temp tables) in order to get some decent access time. In the query described below, Does anybody have a clue as to …
ON-LINE Backup/Client Server Technologies
1)I am the self-proclaimed db administrator of an ON-LINE 5.0 system running on an NCR 3450. I have created a shell script run by root's cron that will do a "dbexport" every night and dump the files to one of seven directories named for the day of the week when the "dbexport" occ…
Re: WingZ - nobody knows ???
In article <756072298snx@ubla.werries.de> Udo@ubla.werries.de (Udo Blatzheim) writes: > > Is there realy nobody, who knows about WingZ? > > Please, if you know anything about, give me a short reply! > > Thanks a lot! > > regards, > Udo > > >Subject: Future of Wing…
Question on Triggers/Stored Procedures
Informix users: I have a problem I think can be solved with stored procedures or triggers. We use Informix OnLine linked with Wingz to support a budget-tracking system. At different times in the budget process, several users of the system update a particular table in the databa…
Re: ISQLPERL - A FAVOUR
In-Reply-To: <2eai1dINN243@emory.mathcs.emory.edu> dave.snyder@das13.snide.com (Dave Snyder) TITLE: Re: ISQLPERL - A FAVOUR > +Message-ID : <2eai1dINN243@emory.mathcs.emory.edu> > +From : dave.snyder@das13.snide.com (Dave Snyder) > +Organization : Mailing List Gateway…
problems: DBA priviledges
We are running Online V5.0 and SQL V4.1 When tables go into more than 8 extents, I wanted to do the unloading, dropping, recreating (with original owner) and reloading of the tables from a usernumber which has DBA priviledge to all the databases on the system. Everything works f…
Bugs in 5.0?
My site is currently assessing whether to upgrade to 5.01 from 5.00 of ESQL/C and Online. One consideration is the additional feature (trigger) and another is the bugs that are fixed. Can any of you who knows of any bug in Version 5.0 of ESQL/C and Online give me some details? I …
Re: WingZ - nobody knows ???
In <756072298snx@ubla.werries.de> Udo@ubla.werries.de (Udo Blatzheim) writes: >Is there realy nobody, who knows about WingZ? >Please, if you know anything about, give me a short reply! >Thanks a lot! >>Subject: Future of WingZ >>Distribution: world >>Date: Thu, 09 Dec 93 20:07:…
CISAM 4.00 and NFS?
I am new to this list. The immediate reason I joined was to get the answer to this question (but I plan to stick around). After reviewing the list archives, I see that there has been some discussion recently regarding Informix SQL accessing NFS mounted files. Also some questio…
WingZ - nobody knows ???
Is there realy nobody, who knows about WingZ? Please, if you know anything about, give me a short reply! Thanks a lot! regards, Udo >Subject: Future of WingZ >Distribution: world >Date: Thu, 09 Dec 93 20:07:03 GMT > >i think there was a discussion about, but i don't have…
Re: Optimizing queries info
> > > } > }I suggest that Jonathan Leffler's book - "Using Informix-Sql" [ISBN > }0-201-51240-8] is *required* reading if you want to do anything with isql. > > Thank you very much. > Well deserved I might add (the compliment - not the thanks). j. _____________________________…
Re: Optimizing queries info
}From: bt@irl3b2c.att.com }Date: Thu Dec 16 9:15:34 GMT 1993 }Subject: Optimizing queries info }X-Informix-List-Id: <list.3228> } }Greg Shepard wrote } }> We've recently written a couple of reports which take }>FOREVER (hours) to run...and are getting very interested in streamlin…
Re: Optimizing queries info
Greg Sheppard (imop%uspfo.wa-ngnet.army.mil@wa-ngnet.army.mil) wrote: : We've recently written a couple of reports which take FOREVER (hours) : to run...and are getting very interested in streamlineing our queries : for speed and efficiency. Is there a book or useful info on ho…
faster finderr
If you have perl, and you have the informix errmsg.txt file, you might be interested in this perl version of finderr, which is *much* faster, by virtue of doing a binary search on errmsg.txt, rather than a linear search. consider: $ tail -4 $INFORMIXDIR/msg/errmsg.txt -2…
Optimizing queries info
Greg Shepard wrote > We've recently written a couple of reports which take >FOREVER (hours) to run...and are getting very interested in streamlineing >our queries for speed and efficiency. Is there a book or useful info on >how best to get the quickest results with queries using…
Optimizing queries info
We've recently written a couple of reports which take FOREVER (hours) to run...and are getting very interested in streamlineing our queries for speed and efficiency. Is there a book or useful info on how best to get the quickest results with queries using iSQL? Or is it just a…
Informix PROBLEM, error in distribution diskette?, HELP, poor csupport
I've installed and maintained many different Informix databases on SCO Xenix and Unix boxes without problem. Last year I recommended a church in my area buy Informix to develop some custom programs they needed. They did so at my recommendation. Now I am almost sorry... I had …
question
Folks, A not so interesting little thing. I need to do a sperform for a table with two fields; a key_field and a date. If the key_field value exists in a second table (which has no other columns but this key_field) then I want to ABORT add. If I had more than one column in the…
Effect of System Crash on RootDbSpace
Netters: At one of our customer sites, we have set up two *identical* systems serving as database servers. One is the primary machine and the other we use in case of a failure. Due to parity error on a RAM chip the main system paniced and the crash dump analysis showed that some…
Datetime/Interval - Help Requested!
Not having worked with the DATETIME/INTERVAL variables much, as I have always found them hard to understand, I am now forced into using them in order to speed up calculations of time and spans of time. The problem I have is getting the variables into something useful such as an …
Re: CRON and INFORMIX-4GL
In article 23147@ncar.ucar.edu, ebrad@eckhart.scd.ucar.edu (Eddie Bradford) writes: >I need to run a 4GL job under the control of cron. When I did this, INFORMIX >dumped a message to my log saying "Install an INFORMIX RUN-TIME product and >run this job again". I couldn't find a…
Re: Any third party tool for archiving OnLine?
: : do you know if there's any third party product to archive/restore an : : OnLine Database Server? : Try: : Inteligencia : 3434 West 6th Street : Suite 400A : Los Angeles, Ca, USA 90020 : 213-385-1600 : 213-385-1986 (fax) CORRECTION on their phone number: it's changed to 3…
Re: Bug in form!?
> Problem: > Message from form "This field requires an entered value" > when there _is_ a valid value there. > > Details: > Development system is SCO Unix 3.2.4, SE v4.11, RDS v4.10.UE2 > Production system is AIX 3.2.?, SE v5.01.UD2, runtime RDS 4.10.UD3 > > I have enco…
Re: Any third party tool for archiving OnLine?
Ing. Maximo Maldonado Boyso (mmaldona@andromeda.mty.itesm.mx) wrote: : Hi, : do you know if there's any third party product to archive/restore an : OnLine Database Server? Try: Inteligencia 3434 West 6th Street Suite 400A Los Angeles, Ca, USA 90020 213-385-1600 213-385-1986 (…
Running 4GL progs with stderr redirection
Hello! Why is it impossible to start a 4GL program (or a program that calls 4GL functions) with redirection of stderr? I have several such programs (each of them do screen I/O with 4GL forms) that run without a glitch when I start them without such redirection. If I do "prognam…
Bug in form!?
Problem: Message from form "This field requires an entered value" when there _is_ a valid value there. Details: Development system is SCO Unix 3.2.4, SE v4.11, RDS v4.10.UE2 Production system is AIX 3.2.?, SE v5.01.UD2, runtime RDS 4.10.UD3 I have encountered the foll…
S.JERSEY C'TRACTORS/STAFF
**************************************************************************** Posted date: 12/13/93 Makefield Software Systems, Inc., a software consulting firm located in suburban Philadelphia, managed by software engineers, is attempting to locate SEVERAL independent contractor…
PageUp/PageDn in GX Menus
I have but a minor question to anyone with a hopefully helpful answer. Can the Page Up/Page Down mouse buttons be active for a MENU in GX? So the: COMMAND KEY ( NEXTPAGE ) COMMAND KEY ( PREVPAGE ) will work ? They work fine in character mode. We are using: …
Re: 4GL mode file for EMACS
Here's what I use, attached below. It works with GNU emacs 18.57. Disclaimer: I wrote this several years ago, don't remember how it works, and would probably approach the problem differently if I worked on it again. It's incomplete, does various things wrong, and isn't easy to c…
Re: 'create database' with ISQL + ONLINE
olhe4000@mailszrz.zrz.tu-berlin.de (Olaf Hendel) writes: > >Hi, > >we changed from Informix SE to Informix Online 5.0 with all this >developing tools like r4gl, isql, etc. >My question is: > >When you create a database from the isql menu, is there any possibility >to change the …
I-NET and PC/TCP
I have I-NET 4.10 and both PC/TCP 2.05 patch 4 and the new 2.2. I can get a connection with Wingz and download the data but the the connection will not cleanup. It just hangs. This is consistent with both versions. Any help would be greatly appreciated. Brendan…
Re: Does Informix do feature request
> I found a bug in the SE 5.0 for AIX that makes it impossible for my application > to run in my environment. I called Informix service and they said, that's not > a bug but we can make a feature request that will enable your application > to run. They then explained that a fea…
DEFER QUIT and INTERRUPT: I4GL 4.10
We're developing an I4GL application for a client who would like the Interrupt and Quit keys remapped in a particular way: the Quit key should not end your application immediately, but should instead act as an alternate Interrupt key. (The application has already been developed …
Informix pricing changes???
I just heard (conference call between Informix and some Wall St. firm that begins with an 'M' but really works on the West coast) that Informix is planning to hold a conference call with the press Monday (12/20) to announce sweeping (read: both Unix and NT) and aggressive (read: …
Does Informix do feature request
I found a bug in the SE 5.0 for AIX that makes it impossible for my application to run in my environment. I called Informix service and they said, that's not a bug but we can make a feature request that will enable your application to run. They then explained that a feature req…
Re: Informix 4gl -- Autistic Compiler?
In <2eirogINN43e@emory.mathcs.emory.edu> jgordon@ssf-sys.dhl.com (Jim Gordon) writes: >> Case in point. >> >> Try: delete from bogus (Note: bogus does not exist in the database.) >> >> Regardless of your database, this should pass with flying colors durring the >> compile. But…
Re: Simple UNIX Text Editor
This really belongs in a comp.unix.* thread, but: In article <2e2gqf$7iq@charm.magnus.acs.ohio-state.edu>, Atul Patankar <apatanka@magnus.acs.ohio-state.edu> wrote: >There appears to be no easy way of preventing a user from escaping to the shell >from within either "vi" or "ema…
Client-server schema (INFORMIX NET + INFORMIX SE) provide access
to remote database with tcp/ip channels.…
Asynchronous Recoverable OLTP with Graceful Degradation
I am looking for references, papers, etc. to the theoretical, practical, and performance problems involved in implementing fully recoverable _asynchronous_ OLTP distributed over an internet. I am interested both in systems with communicating state machines, and stateless systems…
Re: Unload problems
Naomi Walker (naomi@anasazi.com) wrote: : I am in dire need of a program to ease unloading errors. When I unload : certain tables, I get errors complaining about the data in certain fields. : Either its "Too Large for An INT", or doesnt convert to DATETIME as it should, : or so…
Re: Software to link Access & Informix?
Cary R. Stephan (cary@access2.digex.net) wrote: : The title and summary pretty much spell it out: can anyone suggest a : package that will let Access act as a front-end and Informix as a back-end? On the machine running Informix, you need I-Net (or I-Star, if the machine is run…
Re: Migration from SE 4.0 to Online 5.0
Viktor, just switching your backends (SE to Online) should not be too much of a hassle. We have done it before, however within the same release level (SE 4.0 to Online 4.0). The steps to move your data from one system to the other are described very well in the Online admin hand…
BUG IN v5
I've heard reports that a statement like UPDATE cust SET balance = (balance * 0.23) can produce (rather profound) errors if balance is type float. I've also heard that this problem is limited to a few ports. The point is I don't seem to be able to find out which ports. Does any…
WHAT'S IN v6
The title says it all really. Can anyone give me a quick resume of what we can expect in v6? TIA ********************************************************************** * #Include disclaimer.h PGP sig in my resume * * Stuart Hemming. The Data Base (Nottin…
Re: <No Subject Supplied>
Reply to item 0096261 from INFORMIX-LIS sent on 93/12/13 12:22 > Andrew, > Some humor for your Pentium situation. > Let me tell you a story about informix "user" licensing. > I recently upgraded from SE on a 3B2 to ONLINE 5.0 on a Starserver E 660. > Although I was very pleas…
Re: Urgent help. SUM/TOTAL/PERCENT & variables. What a mouth full.
In article <2ei9smINNg1a@emory.mathcs.emory.edu> johnl@informix.com (Jonathan Leffler) writes: >>From: rjc@cbnewsf.cb.att.com (robert.cook) >>Subject: Urgent help. SUM/TOTAL/PERCENT & variables. What a mouth full. >>Date: Mon, 13 Dec 1993 06:59:46 GMT >>X-Informix-List-Id: <news.…
Software to link Access & Informix?
The title and summary pretty much spell it out: can anyone suggest a package that will let Access act as a front-end and Informix as a back-end? Thanks, -CARY…
Re: Informix 4gl -- Autistic Compiler?
From Harry Skelton: * * * After many man hours of trying to clean up code with Informix 4gl and ID, * I have become of the personal opinion that the 4gl compiler is radically * impaired with regards to checking for pre-runtime errors. It is also very * unfortunate that Informix …
Re: Informix 4gl -- Autistic Compiler?
> Case in point. > > Try: delete from bogus (Note: bogus does not exist in the database.) > > Regardless of your database, this should pass with flying colors durring the > compile. But is picked up durring runtime. > > Same with an order by statement and other key statements. …
Re: 'create database' with ISQL + ONLINE
In article <2ehbdnINNmph@emory.mathcs.emory.edu>, Verschraegen Luc <Luc.Verschraegen@rug.ac.be> wrote: > > >On Fri, 10 Dec 1993, Jonathan Leffler wrote: > >> }Hi, >> }When you create a database from the isql menu, is there any possibility >> }to change the default dbspace? (I kn…
Migration from SE 4.0 to Online 5.0
[Hmmm. It's possible that this went out with an unfotunate .sig. I cancelled it, and am hoping that it will go away :-) ] Our organization is planning to upgrade the database we are using. We will either upgrade to Informix Online 5.x from 4.00 UH1 SE, or we will switch to …
Re: Urgent help. SUM/TOTAL/PERCENT & variables. What a mouth full.
>From: rjc@cbnewsf.cb.att.com (robert.cook) >Subject: Urgent help. SUM/TOTAL/PERCENT & variables. What a mouth full. >Date: Mon, 13 Dec 1993 06:59:46 GMT >X-Informix-List-Id: <news.5074> >... >I'm doing a query and one field is "priority", a number. I need to get the >total cou…
[Verschraegen Luc: Re: 'create database' with ISQL + ONLINE]
Second this vote!!! Ann ----------------------------------------------- >It would be nice if there was some possibility to: > (1) prevent users from creating a database in the root dbspace > and more > (2) ensure that certain users or group of users can only create database…
Unload problems
I am in dire need of a program to ease unloading errors. When I unload certain tables, I get errors complaining about the data in certain fields. Either its "Too Large for An INT", or doesnt convert to DATETIME as it should, or something of that flavor. What I REALLY need is an…
Re: query problem with multiple tables
}From: ericd@cats.ucsc.edu (Eric D Davis) }Subject: query problem with multiple tables }Date: 11 Dec 1993 00:11:36 GMT }X-Informix-List-Id: <news.5063> } }Here's a sample application for you, with the }problem described later. This is for SE and ACE. } }I have a school schedule …
Segmentation fault (core dumped) HELP!!!
We have an Informix Online database. We are having a problem with two of our databases. They are up and limping. When I run a tbcheck -cc dbname on the database, I get the following: Validating database dbname Validating systables for database central ISAM error: no record …
<No Subject Supplied>
Andrew, Some humor for your Pentium situation. Let me tell you a story about informix "user" licensing. I recently upgraded from SE on a 3B2 to ONLINE 5.0 on a Starserver E 660. Although I was very pleased with the performance increase. Getting their definition on what a "user"…
VLDB'94 Call for Papers (reminder)
**************************************************************************** * * * VLDB'94 * * …
Informix 4gl -- Autistic Compiler?
After many man hours of trying to clean up code with Informix 4gl and ID, I have become of the personal opinion that the 4gl compiler is radically impaired with regards to checking for pre-runtime errors. It is also very unfortunate that Informix has taken the stand that they si…
Re: Informix pricing on Pentium
In article <2dk5a0$b2m@aggedor.rmit.EDU.AU> s900387@minyos.xx.rmit.EDU.AU (Craig Macbride) writes: >Does anyone know what the pricing category for Informix products is >when they are running on a Pentium-based machine running SCO Unix? >What about multi-processor Pentium machines…
Help! Visual Basic + ODBC.
Dear netters! Could anybody help us? We've got a problem when we try to update a record within Visual Basic. We use OnLine 4.10, Star 4.10 at the server (486, Interactive Unix SVR3.2 version 4.0), Visual Basic 3.0 and Q+E ODBC and Net PC 4.10 at the client (486, Windows 3.1, F…
Re: ODBC with Oracle and Informix on the same server.
In article <8IZJBLGP@niva.han.de>, axel@niva.han.de (Axel Wilzopolski) writes: > Were we to use DBA.D - would we have to install any additional products > on the server's side apart from the backends ? > You would have to install the DBA server products for the databases you wan…
Urgent help. SUM/TOTAL/PERCENT & variables. What a mouth full.
I hate to ask stupid questions. However, I need to compensate the the poor documentation I have on Informix. Or, any other excuse will do, I suppose. Anyway, here's the brief and thanks in advance. I'm doing a query and on field is "priority", a number. I need to get the tot…
tbcheck on mips R4000
The -cd option of tbcheck always bombs out with a memory allocation error. We are running RISC/os 5.01 on mips R4000 and Informix Online 4.1 using raw disk. Has anyone come across this? If so is there a solution or workaround that will allow me to repair a table ?. Thanks Stu…
Re: Books for ANSI SQL
In <2ea4s0$ni3@crchh823.bnr.ca> gcote@bnr.ca (Gary Cote) writes: >Anybody got some references to books that deal with >writing ANSI compliant SQL/ESQL-C code? The following book is good, but only if you know some "SQL" - it serves as a reference book. It is based on the new SQL…
Strange Problem RDS/Indexes
For those who may have seen this before I appologise! unfortunately my internet s/w got itself corrupted so have lost track of any conversation. This is a request for help from those very familiar with RDS and indexing. The problem concernes failure of a system developed using R…
Performance problem with scrollable cursor?
Hi all, Can anyone clarify this issue please. We've been benchmarking dynamic SQL with WATCOM SQL and Informix 4.1. Our application set up a spreadsheet control in Visual Basic talking to a DLL for openning cursor and fetching rows. The test table has 5000 rows and 37 columns. …
Re: ODBC with Oracle and Informix on the same server.
In article <CHGoHL.3AE@informatik.uni-muenchen.de> spitz@ana.med.uni-muenchen.de writes: >enrico badella (L.R.) (badella@polec1.polito.it) wrote: >: Yesterday an itinerating consultant came in and told >: us that I will need SQL-Net and xxx (I forgot the Informix product) on >: …
Re: query problem with multiple tables
In article <2eb37o$7eo@darkstar.UCSC.EDU> ericd@cats.ucsc.edu (Eric D Davis) writes: [...] >So I setup my ace report as follows: > BEFORE GROUP OF pupil.name > PRINT pupil.name [...] >Here's the problem we have: > What if I have two students with the exact same name? >The BE…
Re: schema design question
In article <2eb24q$6vr@darkstar.UCSC.EDU> ericd@cats.ucsc.edu (Eric D Davis) writes: [...] >The way it was done before was to issue each new record >an informix serial number, and hand-issue the membership >numbers when needed. Unfortunately (actually, it's >fortunately), the …
Re: Telnet keyboard mapping
Peter Botcherby (pkb@uk.ac.umds.pru1) wrote: : I have started to use PCNFS v5.0 and telnet to connect PCs to an Informix : RDS application running on a Sun SS2 and have experienced problems in : mapping the extended PC keyboard keys for delete and insert. Has anyone : solved th…
Re: Informix pricing on Pentium
In article <2e47gj$646@aggedor.rmit.EDU.AU> s900387@minyos.xx.rmit.EDU.AU "Craig Macbride" writes: >I have been trying to find out what pricing Informix is using on >Pentium-based machines. Informix people on the net have not commented >on this query and, believe it o…
Re: ODBC with Oracle and Informix on the same server.
Franz Krojer (franz.krojer@mch.sni.de) wrote: : Your consultant is right. The ODBC drivers for ORACLE and INFORMIX : need the net products SQL*Net and Informix-Net for remote : access. But there are alternatives. : We, i.e. Siemens Nixdorf Informationssysteme, have developed : …
Windows 4.11 RT slow?
On a Compaq 386DX2/66 with 4 meg, I have installed SE RT 4.10 and Windows 4GL 4.11 RT on Compaq's version of Windows 3.1. I have moved several simple programs (RDS 4gi's) compiled to p-code on SCO Unix 3.2r4.2, on Informix RDS 4.10.UE2. I invoke the program "4glgx programname" an…
query problem with multiple tables
Here's a sample application for you, with the problem described later. This is for SE and ACE. I have a school schedule database, with the following tables: - Pupils ID Name - Classes ID Class Name - X-Ref Pupil ID Class ID To run a report of all students enrolled in …
schema design question
We're trying to design a table to keep track of names and addresses for a membership group and also people who inquire about membership. Obviously, only members would have member numbers, but everyone should have their own serial numbers. The way it was done before was to issue…
Any third party tool for archiving OnLine?
Hi, do you know if there's any third party product to archive/restore an OnLine Database Server? Any experience with that? -- Maximo Maldonado B. Information Services ITESM-Campus Monterrey Mexico mmaldona@mtecv2.mty.itesm.mx…
Re: ISQLPERL - A FAVOUR
In article <memo.106195@cix.compulink.co.uk> you write: } } } OK, here it is. I want to use isqlperl but I don't have ESQL/C so I } can't make it. Is there any kind soul out there who is willing and } able to supply an executable copy of this for SCO unix? I'd also } (said he, pu…
4GL mode file for EMACS
While the editor wars go on nearby, I just made the jump from vi to Lucid Emacs and really like it. Do anyone out there have a i4gl-mode file you would be willing to share or post to the informix archives? Thanks. BTW, if you are using some form of x-environment, look into the…
Stored Procs and Triggers ?
Always in search of the bleeding edge, my programmers have decided that our applications must now take advantage of stored procedures/triggers. We are planning the migration to 5.01 (RS/6000) and I'm looking for any experiences/bugs/hints anyone can give on the benefits/pitfalls…
null values for ESQL/C variables
Is it possible to assign a null value to an ESQL/C variable in version 4.1? I have some integer columns where I'd like to set them to null when the input file does not assign them a value. I see that you can use the keyword NULL in where clauses, or insert & update statements, b…
Re: 'create database' with ISQL + ONLINE
}From: olhe4000@mailszrz.zrz.tu-berlin.de (Olaf Hendel) }Subject: 'create database' with ISQL + ONLINE }Date: 10 Dec 1993 12:09:18 GMT }X-Informix-List-Id: <news.5053> } }Hi, } }we changed from Informix SE to Informix Online 5.0 with all this }developing tools like r4gl, isql, et…
Telnet keyboard mapping
Hi, I have started to use PCNFS v5.0 and telnet to connect PCs to an Informix RDS application running on a Sun SS2 and have experienced problems in mapping the extended PC keyboard keys for delete and insert. Has anyone solved this problem? The telnet is emulating a VT100 term…
Externals with HSTools1.0 (Windows)
I tried to build the examples (use of externals) from the HSTools distribution using visualC++ 1.0 but the dll's doesn't work (No memory available for this environment)(launch example). When i use the dll's supplied by Informix all is fine. I think there is a bug in the msc8.bat…