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

Will Johnson <JOHNSON@VM.CC.PURDUE.EDU> writes... > ...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 > > . > . > . > > Has anyone else encountered this kind of problem? How about a simple > circumvention? I ran across this one when I was converting my database to version 4.0 about 8 months ago. I solved the problem by unloading the table, like so: UNLOAD TO "media.dat" SELECT * FROM media I then dropped my old table, created a new one with the new column name, and loaded the data back in: LOAD FROM "media.dat" INSERT INTO media There may be other ways to do this, but this worked fine as a quick-and-dirty one-time solution. Roger ------------------------------------------------------------------------------- Roger Boissonnas roger@tc.cornell.edu Cornell Theory Center (607) 254-8703