Re: Informix IDS 7.31 TYPE reserved word

Indeed - but what does one do when there is no source code to modify because the application is a shrink-wrapped package...! In article <385955A2.41778B43@bloomberg.net>, kagel@bloomberg.net wrote: > If type is indeed a keyword you would have to qualify the column name with a > table name or alias everywhere in your code. > > Art S. Kagel > > bill_allison@my-deja.com wrote: > > > > We need to upgrade to 7.31 UC4 an existing > > instance of 7.23 UC1 which supports several > > (mainly bespoke) applications and install a new > > instance of 7.31 TC4 for an application currently > > running on an evaluation copy of 7.2x and which > > must go live immediately. > > > > We have received 7.3x evaluations at the 11th > > hour and have been told that 7.2x is "no longer > > orderable", despite Y2k releases having been > > announced, and have desperately little time to > > upgrade and migrate. Now we're also being told > > that we don't get tech support with evaluations... > > > > Some or our tables have columns named "type". Can > > anyone say whether that is an issue for us with > > 7.31? Do any of you have tables with columns > > named "type"? The release notes say that if a > > table is named type there will be problems but > > also imply that there are other problems. > > > > TIA for a prompt response, > > Bill Allison > > BSW Timber plc > > +44 (0)1896 849255 > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.