DSXchange

Thanks

We don't have experience with added routines. How does this work with upgrades ?

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,...

It's a server job. We were told only to use serverjobs. We started working with datastage with version 8. I have to admit that I don't understand the distinction between the two fora.

substract 3 from the current month.

This solves my first question. I'm a bit embarressed it was so simple . Now my second question?

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...

I won't be able to attend the Dad's and Grad's webinar. Is it possible to see this webinar later ?

not the answer I was hoping for but thanks anyhow

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...

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...

oops

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 !

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...

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.