Search found 20 matches
- Tue Jun 16, 2015 7:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Milli Seconds in time stamp
- Replies: 4
- Views: 2978
Usefull
Thanks
- Fri Jun 21, 2013 7:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: getting data for the last three months
- Replies: 13
- Views: 10846
- Wed Jun 19, 2013 7:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: getting data for the last three months
- Replies: 13
- Views: 10846
Re: getting data for the last three months
Thanks bhasds. We use different date-formats but your example has set me in the right direction. prepBeginMaand_uv.UV_beginMaand : if DSJobStartTimestamp[6,2]-3 <= 0 then (DSJobStartTimestamp[6,2] + 9) else ('0' : DSJobStartTimestamp[6,2]-3) prepBeginMaand_uv.UV_beginJaar : if DSJobStartTimestamp[6,...
- Tue Jun 18, 2013 7:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: getting data for the last three months
- Replies: 13
- Views: 10846
- Tue Jun 18, 2013 6:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: getting data for the last three months
- Replies: 13
- Views: 10846
- Tue Jun 18, 2013 5:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: getting data for the last three months
- Replies: 13
- Views: 10846
- Tue Jun 18, 2013 3:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: getting data for the last three months
- Replies: 13
- Views: 10846
getting data for the last three months
I have the following requirement. I need to extract data for the last three months. So today (18-06-2013) I have to extract data from 01-03-2013 to 31-05-2013. I managed to get the enddate : OConv((MONTH.FIRST(MONTH.TAG(DATE()))) ,'D-YMD[4,2,2]') :' ':Oconv(Time(),'MTS.') gives me "2013-06-01 1...
- Thu Jun 13, 2013 1:49 am
- Forum: Site/Forum
- Topic: Dad's and Grad's webinar
- Replies: 0
- Views: 6362
Dad's and Grad's webinar
I won't be able to attend the Dad's and Grad's webinar. Is it possible to see this webinar later ?
- Fri Mar 08, 2013 8:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reject link creates a file
- Replies: 6
- Views: 2979
- Fri Mar 08, 2013 6:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reject link creates a file
- Replies: 6
- Views: 2979
reject link creates a file
I'm implementing jobs that check datainconsistenties between tables. For example : I check if all instanties of a column in one table also exist in another table. I use a lookup-stage for this. The reject link creates a file with all the inconsistenties. However, when no record is rejected, an (empt...
- Mon Jan 07, 2013 2:33 am
- Forum: General
- Topic: Triggers in a Sequence job
- Replies: 11
- Views: 4717
Re: solved
If have used OK and Otherwise again and now it works. I'am pretty sure that I had tested this but anyway, at least now it works as I want it. Thanks for the replies ! The problem is that I can't use OK en Otherwise for the last job in a sequence. I tried "<> DSJS.RUNOK" but that doesn't w...
- Thu Jan 03, 2013 8:58 am
- Forum: General
- Topic: Triggers in a Sequence job
- Replies: 11
- Views: 4717
- Thu Jan 03, 2013 6:21 am
- Forum: General
- Topic: Triggers in a Sequence job
- Replies: 11
- Views: 4717
solved
If have used OK and Otherwise again and now it works. I'am pretty sure that I had tested this but anyway, at least now it works as I want it.
Thanks for the replies !
Thanks for the replies !
- Thu Jan 03, 2013 3:02 am
- Forum: General
- Topic: Triggers in a Sequence job
- Replies: 11
- Views: 4717
We are using version 8.7. We have not selected any compilation settings. The warning in the job: ADNrKey_sp,0: Warning: debFaktuurDim_File_to_Stage.ADNrKey_sp: [DataDirect][ODBC lib] Invalid argument value The warning in the sequence: debFaktuurDim_File_to_DWH..JobControl (DSWaitForJob): Job debFakt...
- Wed Jan 02, 2013 8:22 am
- Forum: General
- Topic: Triggers in a Sequence job
- Replies: 11
- Views: 4717
sequencer triggers
I've tried OK and Otherwise with the same result.
This is what I want to implement : if a job in a sequence ends with status "OK", the following job can be launched. In all other cases, a notificiation and terminator job must be launched.
This is what I want to implement : if a job in a sequence ends with status "OK", the following job can be launched. In all other cases, a notificiation and terminator job must be launched.