sqlexec 2.10

hello, i'm trying to convert old dat/idx files made with sqlexec 2.10 (18 years old!). it seems that quering with dbaccess 7.25 doesn't work. Does it exists a way to convert it or do i need to install a previous version ? thanks for your help.

On Nov 23, 3:33 am, vomari...@yahoo.com wrote: > hello, > i'm trying to convert old dat/idx files made with sqlexec 2.10 (18 > years old!). it seems that quering with dbaccess 7.25 > doesn't work. Does it exists a way to convert it or do i need to > install a previous version ? > thanks for your help. Those files are from the Informix SE engine not IDS. Dbaccess cannot access that engine unless you have a network product running (iNet). You can probably export the data using the dbexport module included in your 2.10 software and then import it into a more recent Informix DB engine (SE 7.2, Online 5.20, or IDS 11.10). Art S. Kagel

"Art S. Kagel" <art.kagel@gmail.com> wrote in message news:26436b59-c766-4d9f-b8df-073ff45a3294@v4g2000hsf.googlegroups.com... > On Nov 23, 3:33 am, vomari...@yahoo.com wrote: >> hello, >> i'm trying to convert old dat/idx files made with sqlexec 2.10 (18 >> years old!). it seems that quering with dbaccess 7.25 >> doesn't work. Does it exists a way to convert it or do i need to >> install a previous version ? >> thanks for your help. > > Those files are from the Informix SE engine not IDS. Dbaccess cannot > access that engine unless you have a network product running (iNet). > You can probably export the data using the dbexport module included in > your 2.10 software and then import it into a more recent Informix DB > engine (SE 7.2, Online 5.20, or IDS 11.10). Art, you forgot to add: "That'll be $500 please". You're going to find this new life in Consultancy quite difficult, aren't you? ;-)

On Nov 23, 1:20 pm, "Captain Pedantic" <theharlequi...@hotmail.com> wrote: > "Art S. Kagel" <art.ka...@gmail.com> wrote in messagenews:26436b59-c766-4d9f-b8df-073ff45a3294@v4g2000hsf.googlegroups.com... > > > On Nov 23, 3:33 am, vomari...@yahoo.com wrote: > >> hello, > >> i'm trying to convert old dat/idx files made with sqlexec 2.10 (18 > >> years old!). it seems that quering with dbaccess 7.25 > >> doesn't work. Does it exists a way to convert it or do i need to > >> install a previous version ? > >> thanks for your help. > > > Those files are from the Informix SE engine not IDS. Dbaccess cannot > > access that engine unless you have a network product running (iNet). > > You can probably export the data using the dbexport module included in > > your 2.10 software and then import it into a more recent Informix DB > > engine (SE 7.2, Online 5.20, or IDS 11.10). > > Art, you forgot to add: "That'll be $500 please". You're going to find this > new life in Consultancy quite difficult, aren't you? ;-) Advice is always free. Ask me to research something or actually perform the export/import THEN you'll have to fork over $$! I used to charge for advice, but since noone took it then, I started giving it away and lo and behold folk started listening. Since that's FAR less frustrating, I'll take can it. Art S. Kagel

Art S. Kagel wrote: > On Nov 23, 3:33 am, vomari...@yahoo.com wrote: >> i'm trying to convert old dat/idx files made with sqlexec 2.10 (18 >> years old!). it seems that quering with dbaccess 7.25 >> doesn't work. Does it exists a way to convert it or do i need to >> install a previous version ? >> thanks for your help. > > Those files are from the Informix SE engine not IDS. Dbaccess cannot > access that engine unless you have a network product running (iNet). > You can probably export the data using the dbexport module included in > your 2.10 software and then import it into a more recent Informix DB > engine (SE 7.2, Online 5.20, or IDS 11.10). Sentence 1 is correct. Sentence 2 is not - you could use the DB-Access distributed with SE 5.x or 7.x to access the SE database via the corresponding (newer) sqlexec (though DB-Access itself never directly accesses any database, of course). Moreover, the conversion from 2.10 to 5.x would pretty much occur automatically; I'm 95% sure it would work with 7.x as well, but it is a decade and more since I had a copy of 2.10 to play with, so I can't be absolutely certain. DB-Export arrived on the scene with 2.10.03x, IIRC, and probably was not available with 2.10.00. That is a hazy recollection (we are talking about 1987 vintage code, though). Hmmm, some documentation I wrote back in Feb 1990 shows some output from DB-Schema 2.10.03F and that includes the copyright date 1988. The earliest version of the code that is documented is a year earlier - Feb 1989. So, depending on which 2.10 version the OP (Vomaringo) actually has, there may or may not be a DB-Access to use. Since Vomaringo mentions DB-Access 7.25, it should mean he or she has SE 7.25 on hand; there never was an IDS 7.25. Vomaringo, Was the data produced on the same machine as where you are running SE 7.25? Or was the old machine a PC (Intel x86) machine and is the new machine also x86? If so, you are far from irrecoverable - as long as you've been messing with a copy of the database and not the only copy of the data. When you say "querying with DB-Access doesn't work", what error message do you get? What have you got set in the environment? Which directory is your current directory; which directory contains the database directory? What is the value of DBPATH? Can you use the 7.25 DB-Access to get at other, not so ancient databases? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0914 -- http://dbi.perl.org/ publictimestamp.org/ptb/PTB-1860 tiger160 2007-11-24 00:00:06 85AE2B8A910813198E727ABA815C05D5985492E3