The schema file has more than 300 columns. Is there any way that I can import this metadata directly into datastage without manually entering all the 300 cols. Any inputs or alternatives. Pls advice?
Hi,
This fixed file was created by some other program there for the creator must have the file definitions file.
assuming this is a file built by a cobol program it should have a copy book or copy member that defines it.
If you get the definition file you should be able to import it and get the table definition you need.
IHTH (I hope This Helps),
Roy R.
Time is money but when you don't have money time is all you can afford.
vskr72 wrote: Is there any way that I can import this metadata directly into datastage without manually entering all the 300 cols.
Possibly, possibly not. If what you're seeking is something that will read a file of column names and start and end positions, and convert that into a DataStage table definition, then you're out of luck. Though it would be a reasonably easy routine to write for someone experienced with the repository structure of a table definition.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.