Results 1 to 2 of 2
  1. #1
    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

  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts