Search found 1 match
- Sun May 04, 2008 6:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How can i get all the jobs name in a sequence
- Replies: 23
- Views: 14843
find out jobs from master seq
Code: select DS_JOBS.NAME JobName FMT '40L', DS_JOBOBJECTS.NAME LinkName FMT '30L', EVAL DS_JOBOBJECTS."@RECORD<12>" AS JobActivtyJobName FMT '40L' from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE = 'CJSJobActivity' and DS_JOBS.NAME = 'Control_Sequence' and DS_JOBOBJECTS.OBJIDNO = D...