List Of All Source 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
snassimr
Premium Member
Premium Member
Posts: 281
Joined: Tue May 17, 2005 5:27 am

List Of All Source Tables

Post by snassimr »

Hi !

I wonder if I can to get list of all tables are defined on DS Project as Source or on ODBC Stages ?
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Maybe you can look for 'SELECT' or 'FROM' in your export file.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Using my 6th scense I think whatever you want to get is do-able via the MetaStage, or perhaps some other means staded in Vincent's post at the FAQ forum (do read it - as there are only several posts there you'll find it quickly ;))


IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
chucksmith
Premium Member
Premium Member
Posts: 385
Joined: Wed Jun 16, 2004 12:43 pm
Location: Virginia, USA
Contact:

Post by chucksmith »

Try my List all files and tables used by jobs in a dsx file. You will find it on the DataStage Tools page of www.anotheritco.com.
Post Reply