Hi,
I have a requirement to get the list of jobs using a particular column. I got some results using @RECORD field in DS_JOBOBJECTS tables. I got the query from dsxchange only. I have a general question in this. Does DS_JOBOBJECTS RECORD will have all the column details of all the stages of server and parallel jobs?
Also please tell me if there are options in XMETA to solve this requirement?
Thanks & Regards,
Poovalingam.
@RECORD
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
@RECORD is a system variable that contains the entire record (as a dynamic array) from a DataStage hashed file. DS_JOBOBJECTS is a hashed file.
There is no metadata associated with @RECORD. The structure of records in DS_JOBOBJECTS varies depending on what kind of job object is being stored. Metadata is - deliberately - incomplete.
There is no metadata associated with @RECORD. The structure of records in DS_JOBOBJECTS varies depending on what kind of job object is being stored. Metadata is - deliberately - incomplete.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.