Command to import table definition from Sequential File?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dvitalbo
Participant
Posts: 1
Joined: Thu Aug 02, 2007 11:46 am

Command to import table definition from Sequential File?

Post by dvitalbo »

I'm looking for a DS routine or code that wll create a table definition from a sequential file, without having to do it manually.

ie, can I call a routine somewhere, passing it the information that the 'import table def/seq file definition' needs (directory, file, to folder, delimiter, first line col names, etc), and have the function create the table definition within the repository? i'm trying to avoid having to perform an import table def for every file we receive. Instead, find a routine that will accept the above parms as input, and have the table def created automatically.

The only other option i can think of is to build a *.dsx file(containing the table def) via a new program, then import it into the repository.

Any suggestions or help is appreciated! Thanks!
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard. I am not aware of any such routine. The structure of the tables in which table definitions are stored is not documented. Further, the table definition must be stored twice, once in the project's local repository and once in the common Information Server repository.

You would be well advised to use the Import menu in Designer.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply