Oninit cdi / Archive
Talk to an expert →

Re: moving from 7.31

Posted in 2005

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion, Platform-Specific Issues, Versions, Editions & End-of-Life

Obnoxio The Clown — — source: Usenet: comp.databases.informix

John Lynch (IS) said: > > Hi , > > We are currently migrating our 4gl application from Hp_UX , IDS > 7.31.Fd6 > to IDS 9.4 (also on HP-UX) for the moment. > One thing we noticed is a syntax error now occurs at runtime on a > SELECT > stmt such as > > SELECT ref FROM table1 (works under 7.31 compiled with r4gl 7.30 > FC4 , but not on IDS 9.40 compiled with r4gl 7.32)> > On 9.4 we need to say SELECT table1.ref from table1 for it to work. > Is ref a reserved word under 9.4 and if so > are there any more new Reserved words we should know about. I'm surprised they weren't in the release notes. You did read the release notes, didn't you? Or the section in the migration guide that tells you these things? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list

↪ replying to Obnoxio The Clown
ogj@tollpost.no — — source: Usenet: comp.databases.informix

"Obnoxio The Clown" <obnoxio@serendipita.com> writes: > John Lynch (IS) said: >> >> Hi , >> >> We are currently migrating our 4gl application from Hp_UX , IDS >> 7.31.Fd6 >> to IDS 9.4 (also on HP-UX) for the moment. >> One thing we noticed is a syntax error now occurs at runtime on a >> SELECT >> stmt such as >> >> SELECT ref FROM table1 (works under 7.31 compiled with r4gl 7.30 >> FC4 , but not on IDS 9.40 compiled with r4gl 7.32)>> >> On 9.4 we need to say SELECT table1.ref from table1 for it to work. >> Is ref a reserved word under 9.4 and if so >> are there any more new Reserved words we should know about. > > I'm surprised they weren't in the release notes. You did read the release > notes, didn't you? Or the section in the migration guide that tells you > these things? We went through this years ago when going from 7.something to 9.21, I think. Can not recall seeing anything in the release notes. It wasn't even mentioned in the the list of reserved words in 9.21. I beleive it first appeared in the the list of reserved words in 9.3. -- 'yvind

Glossary