Hi,

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
Mahesh.B.S

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.