copy or download tabledefinition into excel

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
userds
Participant
Posts: 19
Joined: Mon Feb 14, 2005 1:39 pm

copy or download tabledefinition into excel

Post by userds »

Hi,

Is there any way to copy or download the table definition into excel format. Please let me know.

Thanks.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Ray posted code to take DS_METADATA and save it as XML. That should get you close. Either that or you could save as comma delimited and import that into Excel.
Mamu Kim
pnchowdary
Participant
Posts: 232
Joined: Sat May 07, 2005 2:49 pm
Location: USA

Post by pnchowdary »

Hi Kim,
Either that or you could save as comma delimited
Could you please tell me how to save the metadata in a comma delimited format ?
Thanks,
Naveen
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Do an exact search for DS_METADATA where Ray is the poster. Modify his code.
Mamu Kim
pnchowdary
Participant
Posts: 232
Joined: Sat May 07, 2005 2:49 pm
Location: USA

Post by pnchowdary »

Hi Kim,

I couldnt find the topic which contains code to extract metadata from DS_METADATA posted by ray. I did find a link in one of the posts, but it says that the topic no longer exists. Anyway, thanks for your help.
Thanks,
Naveen
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

viewtopic.php?t=89234 is where it is.
Mamu Kim
pnchowdary
Participant
Posts: 232
Joined: Sat May 07, 2005 2:49 pm
Location: USA

Post by pnchowdary »

Hi Kim,

Thank you very much for the link. Somehow I missed it in my search, sorry for the trouble.
Thanks,
Naveen
Post Reply