List out Columns used in datastage job (XMETA/DSODB/UNIX)

bj_ds7 · Post by **bj_ds7** » Fri Oct 03, 2014 9:25 am

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.

qt_ky · Post by **qt_ky** » Sat Oct 04, 2014 6:38 am

The dsjob command has a -report option. You may want to try it using the DETAIL report type.

bj_ds7 · Post by **bj_ds7** » Mon Oct 06, 2014 8:57 am

Thanks for the response. But this command provides link level details, but column level details. Is there any other way if can pull column level details used in a job ?

priyadarshikunal · Post by **priyadarshikunal** » Tue Oct 07, 2014 3:51 am

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.

qt_ky · Post by **qt_ky** » Tue Oct 07, 2014 5:51 am

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.