Hi
Can you tell me how to specify column name in job sequencer - nested condition - expression and based on condition(that i am specifying in expression) i want either run the job or
abort the job. Which commands can i use to run or abort job?
Niloy
Search found 2 matches
- Wed Mar 12, 2008 3:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How2 specify column in sequencer-nested condition-Expressin?
- Replies: 1
- Views: 864
- Mon Feb 18, 2008 5:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Month end date
- Replies: 14
- Views: 6648
Re: Month end date
Declare 2 stage variables as follows: svYear=If MonthFromDate(RUN_DT) <12 then YearFromDate(RUN_DT) else YearFromDate(RUN_DT) + 1 svMonth=If MonthFromDate(RUN_DT) <12 then MonthFromDate(RUN_DT)+1 else 1 Then in the output derivation for RUN_DT, put: If MonthFromDate(RUN_DT) = 9 or MonthFromDate(RUN_...