Metadata of DS_JOBOBJECTS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Sunshine2323
Charter Member
Charter Member
Posts: 130
Joined: Mon Sep 06, 2004 3:05 am
Location: Dubai,UAE

Metadata of DS_JOBOBJECTS

Post by Sunshine2323 »

Hi Friends,

How to get the names of all the columns in DS_JOBOBJECTS i.e How to get the schema or metadata of DS_JOBOBJECTS?

Thanks,
Warm Regards,
Amruta Bandekar

<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
dslearner
Premium Member
Premium Member
Posts: 67
Joined: Thu May 26, 2005 3:09 am

Post by dslearner »

Hi,

You can get from the administrater by using command

LIST DICT DS_JOBOBJECTS

DSLearner
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

These have not been published, and do not exist anywhere.

You can deduce some them from the header files in dsinclude.

DS_JOBOBJECTS is not a conventional table. It has many different record structures, ranging from nine to 308 columns, depending on the particular object type. Further, some of those columns may contain collections (for example there is a collection of column definitions within the definition of a link used as an Input).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply