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
userds
Participant
Posts: 19 Joined: Mon Feb 14, 2005 1:39 pm
Post
by userds » Thu Jul 21, 2005 12:42 pm
Hi,
Is there any way to copy or download the table definition into excel format. Please let me know.
Thanks.
kduke
Charter Member
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Post
by kduke » Thu Jul 21, 2005 2:00 pm
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 » Thu Jul 21, 2005 2:21 pm
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
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Post
by kduke » Thu Jul 21, 2005 3:02 pm
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 » Thu Jul 21, 2005 3:46 pm
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
Posts: 5227 Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:
Post
by kduke » Thu Jul 21, 2005 4:43 pm
Mamu Kim
pnchowdary
Participant
Posts: 232 Joined: Sat May 07, 2005 2:49 pm
Location: USA
Post
by pnchowdary » Thu Jul 21, 2005 4:50 pm
Hi Kim,
Thank you very much for the link. Somehow I missed it in my search, sorry for the trouble.
Thanks,
Naveen