After Migration Iconv & Oconv have different results.

joycerecacho · Post by **joycerecacho** » Tue Mar 19, 2013 8:48 am

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,

chulett · Post by **chulett** » Tue Mar 19, 2013 10:18 am

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

chulett · Post by **chulett** » Tue Mar 19, 2013 12:51 pm

Nice bit of detective work.

joycerecacho · Post by **joycerecacho** » Tue Mar 19, 2013 12:57 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Mar 19, 2013 1:22 pm

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

joycerecacho · Post by **joycerecacho** » Tue Mar 19, 2013 1:38 pm

Thank you Ray for complementing.

rameshrr3 · Post by **rameshrr3** » Tue Mar 19, 2013 3:00 pm

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.