List of tables

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
adams06
Participant
Posts: 92
Joined: Sun Mar 12, 2006 3:00 pm

List of tables

Post by adams06 »

How get list all tables(Target) used in a project?
Top
rameshv
Participant
Posts: 11
Joined: Wed Feb 27, 2008 11:14 pm

Re: List of tables

Post by rameshv »

You can check the corrsponding file names in the unix using ls commend
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You'd need either a pretty complex repository query or a good hard look at a .dsx export of your project. Once you find one you can find them all.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Chuck Smith (http://www.anotheritco.com) has a utility that can probably be adapted to your purpose.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Too true! Been awhile and (sorry) forgot to mention that as another option. I spooled the output from his utility to a db table so I could query the results. 8)
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”