Oninit cdi / Archive
Talk to an expert →

rowid

Posted in 2003

Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Versions, Editions & End-of-Life

Smitty — — source: Usenet: comp.databases.informix

We have 1800+ 4GL programs written using Informix SE 4.0 and have needed to upgrade for a LONG time. We have a 5-user version of Informix IDS 7.31.UD5-1 to test with. Someone told us that the newer versions of Informix don't support "rowid", which is included in a lot of our code thanks to the FourGen CASE tools. We are having trouble getting a definitive answer to this question, does anyone know when or if Informix products stopped using rowid? Thanks! Joseph Dobbs

↪ replying to Smitty
rkusenet — — source: Usenet: comp.databases.informix

"Smitty" <wolphie@hotmail.com> wrote in message news:4f39af7f.0305190604.414c07a@posting.google.com... > We have 1800+ 4GL programs written using Informix SE 4.0 and have > needed to upgrade for a LONG time. We have a 5-user version of > Informix IDS 7.31.UD5-1 to test with. Someone told us that the newer > versions of Informix don't support "rowid", which is included in a lot > of our code thanks to the FourGen CASE tools. We are having trouble > getting a definitive answer to this question, does anyone know when or > if Informix products stopped using rowid? > Thanks! rowid will not work if your table is fragmented, unless you create the table WITH ROWID clause. Now given that you are currently using SE 4.0, if you move your schema as it is, then there is no question of fragmentation. Hence your old programs can safely use rowids, as long as you don't change the schema and start fragmenting. Ravi

Glossary