informix file definitions
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
informix file definitions
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.