How to save Soruce/Output Seq File Table def to a word file?
Moderators: chulett, rschirm, roy
How to save Soruce/Output Seq File Table def to a word file?
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
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
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:
With very little manipulation this can be formatted any way you wish. Heck, you could even write a short DataStage job to do this.<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" />
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
hi ArndW/Sainath.Srinivasan: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:With very little manipulation this can be formatted any way you wish. Heck, you could even write a short DataStage job to do this.<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" />
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
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.