Search found 1 match
- Fri Jul 07, 2006 5:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting the job properties using the sql on file system.
- Replies: 2
- Views: 691
Getting the job properties using the sql on file system.
I have a quire to get the all the hash file used in the jobs. SELECT CATEGORY AS CATGRY, DS_JOBS.NAME AS JOB_NAME ,EVAL DS_JOBOBJECTS.'@RECORD<6>' COL.HDG 'LINK_NAME' ,'File Created in this Job ' AS FILE_TYPE FROM DS_JOBOBJECTS, DS_JOBS WHERE DS_JOBOBJECTS.OBJIDNO=DS_JOBS.JOBNO AND DS_JOBOBJECTS.OLE...