DSXchange

Hi everybody!

I worked for a project to migrate servers.

At the old one there were only server jobs and routines in basic, it was not the Enterprise Platform.

This week we are observing the processes at the new server in which runs the Enterprise platform v.8.5 and the same servers jobs and basic routines.

We noticed that a simple routine in basic returns different results when it runs at the old server and at the new one.

Follow the example:

Routine:
x = Iconv(Arg1, "D-E")
Ans = Oconv(x,"D-YMD[4,2,2]")

Arg1 = 01-02-2013

Results:

* OLD server .......... 2013-02-01
* NEW server ......... 2013-01-02

What can it be?
Is it about any NLS configuration?

Thank you guys!

Best regards,

Out of curiousity, what version of DataStage was your old server running?

Nice bit of detective work.

Yeah, now I have a lot of work....

Or you could simply change the NLS locale, particularly the TIME category.

Thank you Ray for complementing.

I remember disabling NLS for TIME datatypes ( Under LOCALE, TIME/DATE -set to "OFF") for an entire project . Some of the 'out of the box' transforms using DateGeneric***** will not work the same way if migrated from an non NLS to NLS enabled environment.