Page 1 of 1

access to unix isam file

Posted: Mon May 15, 2006 6:01 am
by gbusson
Hi all,

is it possible to access a unix isam file using datastage? (PX or server)

thaks all.

Posted: Mon May 15, 2006 6:15 am
by ArndW
UNIX has no ISAM file structure builtin, this would always be some structure generated by a software vendor. Depending upon that implementation it might be possible for DataStage to read these files sequentially and skip over any internal indexing objects. Do you know your program or application that created the ISAM file?

Posted: Tue May 16, 2006 2:09 am
by gbusson
this is C-ISAM developped by Informix.

I would like to read and write to it.

thanks for your help.

Posted: Tue May 16, 2006 2:43 am
by ArndW
There are ODBC drivers out there for C-ISAM files; I'm not sure but assume the IBM/Informix have them but there are 3rd party tools out there as well. This would be easier than using a DataStage programming to manually disect the internal formats.