Excel output from DS 7.5 Table Definitions

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
flashgordon
Premium Member
Premium Member
Posts: 99
Joined: Tue Aug 17, 2004 7:50 am
Location: Boulder, Colorado

Excel output from DS 7.5 Table Definitions

Post by flashgordon »

Hi,

We had the ability to take Ascential Datastage Table Definitions and turn them into excel spreadsheets before but we have lost the recipe. Is there some kind of shareware that does this, or a sequence of things you do in Datastage and then on the excel side. The output excel file would have the column name, Declaration, length, etc.. We only have Excel 2000 (not 2003) so I don't think we can read XML directly.

Thanks.

Flash Gordon
Flash Gordon
Hyperborean Software Solution
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Try reporting assistant from DataStage Manager.
Post Reply