Page 1 of 1

informix file definitions

Posted: Mon Apr 30, 2007 9:44 am
by kirankota79
I have informix file definitions in a text file. Is there a way to import it into the datastage. I have tried it but it is not working

Posted: Mon Apr 30, 2007 2:58 pm
by ray.wurlod
What did you try?

The short answer is that there's nothing provided out of the box.

Easiest for an inexperienced user is to create the table in Informix, then to import it into DataStage from there.

Needless to say it can be done, but requires detailed knowledge of the Repository structures. A table definition record in a DataStage 7.5 repository has 212 fields - you would need to know what to put into each. Further, some of these fields contain structures (lists), rather than atomic values.