access to unix isam file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gbusson
Participant
Posts: 98
Joined: Fri Oct 07, 2005 2:50 am
Location: France
Contact:

access to unix isam file

Post by gbusson »

Hi all,

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

thaks all.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post 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?
gbusson
Participant
Posts: 98
Joined: Fri Oct 07, 2005 2:50 am
Location: France
Contact:

Post by gbusson »

this is C-ISAM developped by Informix.

I would like to read and write to it.

thanks for your help.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post 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.
Post Reply