DSXchange

Hi,

I have one routine with the below code.

Ans = Iconv(Arg1[1,8], "D")

The same routine with same passing values is returning different results on DataStage 7.1 without NLS and DataStage 7.5 with NLS enabled is giving different results. Please advice how to overcome this issue.

Examples?

Hi,

Examples:

DS 7.1 without NLS

Value Result
20060902 00:00:00.000 14125
19671231 00:00:00.000 0

DS 7.5 with NLS

Value Result
20060902 00:00:00.000 -389172
19671231 00:00:00.000 Nothing

What happens when you correctly specify "D4YMD" instead of "D"? I'm not at a DS client now, but by setting NLS the default date format can change.

Hi ArndW,

The routine works fine in DS 7.51 with NLS version for the following codes:

Ans = Iconv(Arg1[1,8], "DYMD")

Or

Ans = Iconv(Arg1[1,8], "D ")

But if I want to use the same below code in both the versions, can you please tell me what I need to do.

Ans = Iconv(Arg1[1,8], "D")

If you really need to keep the date format you will have to change your NLS locale so that the default date format matches the non-nls one. This is certainly not what I would recommend - using a "D" conversion, particularly on output, is an invitation for big trouble. Be as specific as you can. If you use ICONV/OCONV in a transform you should always make use of the STATUS function to see if the conversion was successful.

Hi,

Otherwise please tell me how to disable the NLS settings for a particular project.

You can do almost everything for NLS with your administrator client. Please refer to the PDF online document NLS Guide for details on how to change your locales.

The difference is because of "with NLS enabled and without NLS". Without NLS the expected format of a date (since you only have "D" as the second argument of Iconv) is specified in a file called msg.text; with NLS enabled the default date format is specified in the TIME locale category. The first is probably month-day-year order, the second probably year-month-day order. You can check by trying Oconv(13579,"D") - this will generate a date using your default date format.

Can u please tell me how to change default date format when the NLS option is enabled. I just want to change the time from 24 hour format to 12 hour format.

Zabeerulla,

did you look at the NLS Guide as suggested earlier? Look at page 2-4 to start with.

You change the TIME category of your locale. This is probably most easily managed using the NLS.ADMIN menu in the UV account. You will, however, need some familiarity with the ED command line editor in DataStage or with DataStage SQL, since the category definition is a record in a hashed file.