06-23-06, 07:16 #1Registered User
- Join Date
- Mar 2006
Unanswered: Anything equivalent to nlsparam parameter of to_char of oracle in DB2
Is there anything equivalent to nlsparam parameter of to_char of oracle in DB2.Iam using MTK for conversion from oracle to DB2.
There is a UDF ora.to_char with the nlsparam parameter,but then for nls_calendar='persian' value for nlsparam in Oracle,there is no equivalent in ora.to_char of DB2.
It returns the american calendar and not the persian calendar.Hence anybody please provide the necessary solution on this.
Thanks in advance
06-29-06, 11:01 #2Registered User
- Join Date
- Sep 2004
AFAIK, there is no such thing in DB2 as to_char's nlsparam of Oracle.
And certainly for calendars, I believe DB2 only knows the Gregorian calendar.
Most likely there will be UDFs around to convert between calendars, but it seems that you will need to either manually apply this UDF after running ora.to_char, or modify ora.to_char such that it calls that UDF when necessary.--_Peter Vanroose,
__IBM Certified Database Administrator, DB2 9 for z/OS
__IBM Certified Application Developer
__ABIS Training and Consulting