Re: C-ISAM to Informix conversion ???

In article <bmourn.50.2FBA83C7@omni.voicenet.com> bmourn@omni.voicenet.com "Bob Mourning" writes: > anyone- > i am working for a client that has some C-ISAM files that they would like to > convert to Informix databases. > > They have Informix-SE, Viewpoint, DB-Access, C-ISAM, ESQL-C, and the related > products. > > They were led to believe by a sales person that there was a very easy way to > access the C-ISAM files with ViewPoint. > > After researching this for a few days, I see no alternative but convert the > C-ISAM files to ASCII delimited files for a LOAD in ISQL or dbload under > dbaccess. > > Any other ideas? > > The C-ISAM files are rather large and since they had a dynamic access method > in mind, time is a big factor. > > Anyone have any sample code to convert from C-ISAM or ascii to Informix? > > > ------------------------------------------------------------------------ We use an accounting system with CISAM files and ISQL databases to run the Diocese. We directly do custom reports and searches on the A/Cs data from ISQL/ I4GL. Assuming you have the sources for the CISAMS and can look at, or know the data structure the process is fairly simple. The setup goes as follows Create a new database, Create all the new tables using schemas to match the CISAM definitions, but omit all indexes. Copy the xxx.dat files from the CISAM into the newly created dat tables ( ie xxxx_101.dat etc ) in the .dbs directory. Use form build to create a default form and query the table to make the definition is correct. Any errors drop and rebuild the table. Is suggest you add indexes after. For the brave --- you can link the xxx.dat CISAM to the xxx_nnn.dat ISQL and get the best( worst?) of both worlds. the.dbs Snags - None that I know of but I am led to beleive by my 2nd line support Co that the CISAM and ISQL versions need to be close in origin. I suspect this is true only if you want to share not re build tables. -- Regards Martin How Diocese of London and Buonacorsi Consulting