Re: INFORMIX-4GL 4.0 upgrade problem - reserved words/column names

Will Johnson, in your mail you wrote: > > I am in the process of converting a client's INFORMIX-4GL application > from the INFORMIX 2.10 level to release 4. I have encountered a > problem with programs that have been working for 4 years, but now fail > with SQL -201 errors (SQL syntax) on UPDATE statements. After much > head scratching I decided to review the reserved words list against the > column names in the tables. I found that I had long ago created this > table with a column named length, which also is a reserved word. > > Has anyone else encountered this kind of problem? How about a simple > circumvention? If not, be forewarned about this kind of a problem > that can break previously functioning programs. > Yes, this is a known problem that I've already addressed. What you need is my "dbreserved" program. This program will search SYSTABLES and SYSCOLUMNS for over 400 reserved words. These words are from every RELEASED version of Informix software to date. Here's the poop on how to get your own version of "dbreserved"... You can reach "das13" through the archive-server or ANONUUCP (ANONFTP is out of the question on an AT&T 3B1), the info you need follows... ANONUUCP: Create one or more of the following entries in your Systems (or L.sys) file: das13 Any;1 FAST 9600 1-2154614007 "" \\r\\c in:-\\r-in: anonuucp das13 Any;1 ACU 2400 1-2154614007 "" \\r\\d\\r\\c in:-\\r-in: anonuucp das13 Any;1 ACU 1200 1-2154614007 "" \\r\\d\\r\\d\\r\\c in:-\\r-in: anonuucp The first file you'll need is: das13!~/ls-lR.Z BTW, this is a call to Philadelphia, PA USA ARCHIVE-SERVER: To access the archive-server send mail to: archive-server@das13.snide.com In the Subject: put the word "help" (w/o the quotes). Leave the rest of your mail blank since it'll be ignored anyway. You will receive mail back explaining in detail what the archive-server is and how to use it. Any problems or questions should be mailed to: dave.snyder@das13.snide.com DAS -- David A. Snyder @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!das INTERNET: das@trac2000.ueci.com