How to fetch Meta data of souce or target stage to a file

[rhaddur]

we able to get job parameters using

SELECT
EVAL DS_JOBOBJECTS."@RECORD<14>" AS Param_Name,
EVAL DS_JOBOBJECTS."@RECORD<16>" AS Prompt,
EVAL DS_JOBOBJECTS."@RECORD<19>" AS Type,
EVAL DS_JOBOBJECTS."@RECORD<17>" AS Default_Value,
EVAL DS_JOBOBJECTS."@RECORD<18>" AS Help_Text
FROM
DS_JOBOBJECTS , DS_JOBS
WHERE
DS_JOBOBJECTS.OLETYPE='CJobDefn' AND DS_JOBS.JOBNO=DS_JOBOBJECTS.OBJIDNO AND DS_JOBS.NAME='<jobName>';



then what is the way to get the

fetch Meta data of souce or target stage to a file

[kduke]

The metadata stored in DS_JOBOBJECTS is in multiple record types and not published. Some of us have figured out how to get some of this. The SQL posted here will not work without adding the dictionary items. The same is true for what you are asking for here. The multiple record types are based on OLETYPE field. You need to know the OLETYPE and job type like PX or server to narrow down what you are asking for to a more specific solution.