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

> 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 > > despite the fact that there is no way a LENGTH function makes any > sense in a RENAME statement, except that it is a reserved word. So > much for a simple exit from this cul-de-sac. All in all, a nasty > upgrade surprise. > > 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. Note that this problem also seems to exist in ISQL... I know, it happened to me just a couple of days ago. What I did was to drop the table previously created with version 2.xx? and recreate it with version 4.0. Be sure to copy data out first to a temp table.... it isn't really a simple circumvention. Persons with an impending upgrade may want to review their table.columnnames versus the 4.0 reserved word list and take care of the problem before the upgrade is performed. ---------------------------------------------------------------------------- Tim Tow | Intergraph Corporation | "Injustice anywhere is a Huntsville, AL | threat to justice everywhere" Mailpath:..timtow@timtow.b1.ingr.com | Voice: 205-730-2117 | - Dr Martin Luther King, Jr ----------------------------------------------------------------------------