Re: Informix C_ISAM

Posted in 2004

Summary

gsturkenboom asked how to determine the structure of C-ISAM v4 files on SCO. Jonathan Leffler said raw C-ISAM files hold little structure information; bcheck shows indexed fields and record length, and with SE the systables.dat and syscolumns.dat files describe tables. Apsik suggested SE 5/7 dbschema with DBPATH set to the directory. David Snyder offered help.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

gsturkenboom@lic.co.nz — Mon, 28 Jun 2004 09:42:12 +1200 — source: Usenet: comp.databases.informix

Informix C-ISAM V4 SCO V5.61 Does anyone know of a method of determining the structure of C-ISAM files? Perhaps C-ISAM provides some functionality itself or can I use Informix SDK (demo3.ec) against these files. Thanks in advance... sending to informix-list

↪ replying to gsturkenboom@lic.co.nz

David Snyder — Sun, 27 Jun 2004 18:31:59 -0400 — source: Usenet: comp.databases.informix

I can probably help. What exactly are you trying to do? DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Email: dave@snide.com Web: http://www.snide.com gsturkenboom@lic.co.nz wrote: > Informix C-ISAM V4 > SCO V5.61 > > Does anyone know of a method of determining the structure of C-ISAM files? > > Perhaps C-ISAM provides some functionality itself or can I use Informix SDK > (demo3.ec) against these files. > > Thanks in advance... > > > > sending to informix-list

↪ replying to gsturkenboom@lic.co.nz

Jonathan Leffler — Mon, 28 Jun 2004 06:29:34 GMT — source: Usenet: comp.databases.informix

gsturkenboom@lic.co.nz wrote: > Informix C-ISAM V4 > SCO V5.61 > > Does anyone know of a method of determining the structure of C-ISAM files? > > Perhaps C-ISAM provides some functionality itself or can I use Informix SDK > (demo3.ec) against these files. C-ISAM v4.anything is pretty archaic. Raw C-ISAM files contain little information about the data inside. You can use bcheck to establish the indexed fields (types and positions within the record), which can be helpful but is seldom complete. It also tells you the record length. This often allows you to eyeball the (hex) dump of the data file and determine where the field must be. If the C-ISAM files are used in conjunction with SE, then the systables.data and syscolumns.dat files tell you about the structure of the tables - table names, number of columns, types and names of each column and so on. This is a whole heap easier to deal with. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to gsturkenboom@lic.co.nz

Apsik — Mon, 28 Jun 2004 14:44:20 +0200 — source: Usenet: comp.databases.informix

Use dbschema from SE5/7. Set before DBPATH variable to directory containing ISAM files. Uďż˝ytkownik <gsturkenboom@lic.co.nz> napisaďż˝ w wiadomoďż˝ci news:cbngsr$a5i$1@news.xmission.com... > > > Informix C-ISAM V4 > SCO V5.61 > > Does anyone know of a method of determining the structure of C-ISAM files? > > Perhaps C-ISAM provides some functionality itself or can I use Informix SDK > (demo3.ec) against these files. > > Thanks in advance... > > > > sending to informix-list