How to save Soruce/Output Seq File Table def to a word file?

DS_MJ · Post by **DS_MJ** » Thu Apr 21, 2005 11:08 am

Hello:

Is there a way to save the table definitions used in Datastage Server 7.5 to a word or text format....?

When I generate a report using Datastage I am able to get the input or source colums saved as text files ....however the output files are not so straight forward.....(go figure...) some of the output columns are straight maps and some are derived columns. In the report these derived columns are displayed but they dont show up in the right order as in the output view. So this is out of the window.....

Need to find a easier way to get the source and output columns to be save as word or text......Any suggestions would be highly appreciated.

The reason I want to do this is because we want to compare Mainframe table definitions, Server table definitions, DDL that the company gave and the DB2 tables.

Thanks in advance and would appreciate any response at the earliest convenient time.

MJ

ArndW · Post by **ArndW** » Thu Apr 21, 2005 11:37 am

You can export the table definitions (from the manager -> Export -> DataStage Components and then choose table definitions) into an XML formatted file, an excerpt of the output look like:

<Property Name="Name">IDIATCTY</Property>
<Property Name="Description" PreFormatted="1">CITY CODE Searchable? N\(20)</Property>
<Property Name="SqlType">1</Property>
<Property Name="Precision">3</Property>
<Property Name="Scale">0</Property>
<Property Name="Nullable">0</Property>
<Property Name="KeyPosition">0</Property>
<Property Name="DisplaySize">3</Property>
<Property Name="PadChar" />

With very little manipulation this can be formatted any way you wish. Heck, you could even write a short DataStage job to do this.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Apr 21, 2005 12:20 pm

Take a look at DataStage's reporting tool in Manager.

DS_MJ · Post by **DS_MJ** » Thu Apr 21, 2005 12:52 pm

ArndW wrote:You can export the table definitions (from the manager -> Export -> DataStage Components and then choose table definitions) into an XML formatted file, an excerpt of the output look like:
<Property Name="Name">IDIATCTY</Property>
<Property Name="Description" PreFormatted="1">CITY CODE Searchable? N\(20)</Property>
<Property Name="SqlType">1</Property>
<Property Name="Precision">3</Property>
<Property Name="Scale">0</Property>
<Property Name="Nullable">0</Property>
<Property Name="KeyPosition">0</Property>
<Property Name="DisplaySize">3</Property>
<Property Name="PadChar" />
With very little manipulation this can be formatted any way you wish. Heck, you could even write a short DataStage job to do this.

hi ArndW/Sainath.Srinivasan:

Thanks for the prompt reply, I export it as XML and shows as above ... but would appreciate it if could you show me what manipulation can be done....?

As for using DataStage Reporting tool... I already used but as mentioned above having problems displaying the output columns (straight map thrus and derived columns) in the correct order as seen from the view tables since they show up as 2 seperate tables.

Thanks,
MJ

ray.wurlod · Post by **ray.wurlod** » Thu Apr 21, 2005 1:41 pm

There was a routine posted some time ago for dumping a table definition in CSV, XML or IMF format. Search for it. (IMF format is used by QualityStage.)

DS_MJ · Post by **DS_MJ** » Thu Apr 21, 2005 4:45 pm

ray.wurlod wrote:There was a routine posted some time ago for dumping a table definition in CSV, XML or IMF format. Search for it. (IMF format is used by QualityStage.)

Hi Ray:

There was a link but it say that that topic is no longer avaliable hence unable to download your code.

MJ

DS_MJ · Post by **DS_MJ** » Thu Apr 21, 2005 4:47 pm

the Link:

The link is viewtopic.php?t=85791 .

ray.wurlod · Post by **ray.wurlod** » Thu Apr 21, 2005 5:50 pm

That's the one.

Create a new server job.
Fill in the short and long description fields.
Paste the code into the Job Control tab in Job Properties.
Create the ten job parameters mentioned in the code.
Put an annotation in the canvas to warn future developers that this job consists solely of job control code.
Compile, run and marvel! :D

kduke · Post by **kduke** » Thu Apr 21, 2005 8:10 pm

I took Ray's code and created a routine named KgdCreateDdlMetadata. This will create the DDL to create a table from these records. It sounds like you already have the DDL on one side. This routine has been posted already but if you cannot find it then I will post it again.

DS_MJ · Post by **DS_MJ** » Fri Apr 22, 2005 9:09 am

Hi Ray and kduke:

I cannot access the routine when I click on that link... it gives the following message:

"The topic or post you requested does not exist "

kduke, would appreciate if you could re-post that routine again.

Thank you much in advance.

MJ

kduke · Post by **kduke** » Fri Apr 22, 2005 10:08 am

It is on my tips page.

DS_MJ · Post by **DS_MJ** » Fri Apr 22, 2005 11:07 am

Thank you much kduke........MJ