DSXchange

I always keep the jobs as small as possible and then put them all into a bigger sequence(s).
I find it easier to fault find when supporting jobs in testing/production this way...

IMHO you should always keep things simple.

Ray

thanks for the help chaps.

problem resolved by inserting the following line into the .profile:

export NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1";

i then restarted DataStage and all was fine.

thanks

Ray

Thanks guys, it's good to know i don't have to reinstall DataStage anyway, i wasn't looking forward to that. My first thought was that it was an Oracle issue, so i'll keep plugging away in that direction. Thanks for the replies. If anyone else has any advice, that would be great. If/when i find the ...

Hi again,

It was a bracket missing,
Top fix ArndW.

The cheque is in the post...

Ray

ArndW,

Thanks for the quick reply,
i have tried your suggestion but it doesn't seem to like it (goes red).

I'm just playing with your code to see if there is a bracket mssing or something.

Cheers

Ray

Hi, i was wandering if anyone could help? I have to add one day to a given date. i have found a way of doing this: Oconv(DateTimeStampToInternal(DSLink7.Date) + 1,"D/YMD[4,2,2]" ) but... When i change the date to 2005/02/28 the output is 2005/02/02? it's pretty much the same for 2005/04/30...

Hi, I was wandering if anyone could help... I have used the search function on this site to no avail. I have a sequence that processes a massage from MQ, transforms it into a flat file then maps data to a target file. When i try to transform the the xml file into a flat file the job aborts with the ...