List out Columns used in datastage job (XMETA/DSODB/UNIX)
Moderators: chulett, rschirm, roy
List out Columns used in datastage job (XMETA/DSODB/UNIX)
Is there a way to list out all columns used in job level/stage level either using DSODB / XMETA / DSJOB Command from unix ? Kindly advise if there is any other approach to get this information.
Thanks & Regards!
BJ
BJ
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
You can get those details from XMETA. I do not have an xmeta to play with at the moment but I might be worth looking at DSLINKS and DSFLOWVARIABLES tables in xmeta, you can apply %% on both sides to search for these tables.
There might be case where the list of RIDs are present in single clob which you may need to break.
There might be case where the list of RIDs are present in single clob which you may need to break.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
My bad. There is also a job report that actually includes column details. From Designer, go to the File menu and Generate a Report. There is a dsdesign.exe command line option for generating a job report as well, which you can run from the Client tier. It is documented in the Designer Client Guide.
Choose a job you love, and you will never have to work a day in your life. - Confucius