Hi,
Can anyone help me?
I need to know what is the equivalent of NLS_LANGUAGE or
NLS_CHARACTER _SET parameter of Oracle in DB2.
I want to see the current date in language other than english.
say in Arabic , so how do I do that?

For your information
the query
SELECT TO_CHAR(SYSDATE,'MON','NLS_DATE_LANGUAGE=ARABIC') FROM DUAL;
will return the month name (first 3 letters of the month) in Arabic language.
I wish to do the same in DB2.

Thanks in advance
mailar

there is none
you have to bind the cli or your application with the option date ....
to get the data in a specific format
Best Regards, Guy Przytula

Can you please tell me more about this binding?
An example would be highly helpful I suppose

Hi,

Try this out:
Note: date is written in ISO standard format: year-month-day.

Hope this helps,
Grofaty

Hey Grofaty,
Thanks for the query but I want to know the date in various languages like Arabic , Chinese which I can specify using NLS_DATE_LANGUAGE parameter of TO_CHAR function (in Oracle). So, please tell me how can I do the same in DB2

I don't think this is possible
the only formatting possibilities are with date format at bind time
[DATETIME {DEF | USA | EUR | ISO | JIS | LOC}]
if the client is english you will get months... in english ..
Best regards, Guy Przytula

Hi all!

I am sorry for mine poor English!

I have DB2 UDB 8.2 for Win2000.

I while the beginner in DB2 (9 years of experience in Oracle) also. I too have the same problem and can only offer as workaround (checked up only in my environment), set country, necessary for you, in Local preferences of the DB2 instance user account. After that a title month, day of week will be mapped in language of the established country.

P.S. See also http://www-128.ibm.com/developerworks/forums/dw_thread.jsp?forum=291&thread=64959&message=51326 73. Here my problem, which has remained without the answer.

Best regards, Dmitriy.