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

From: Will Johnson <pitt!VM.CC.PURDUE.EDU!JOHNSON> 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. This did not bother the previous versions of INFORMIX-4GL, but the 4.0 SE engine is another matter. Well, having found this, the obvious solution was to rename the column. Unfortunately, INFORMIX-4GL considers it a syntax error to have 'length' in the following statement: RENAME COLUMN media.length TO media_length You might try unloading the table, dropping it and building a new table from a corrected schema.