Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009
    Posts
    4

    Question Unanswered: Problem With Date Data Type

    Hello,
    i have a problem with stored procedure.
    i need to send date as a input parameter ,so if i try to run with date value run got failed ,if i run with null value it got work.
    if i put any date in input parameter i am getting run time error as:
    SQL0332N There is no available conversion for the source code page "5348" to the target code page "37". Reason Code "DSNXVDTT". SQLSTATE=57017

    can you help me in this.

    Thanks in advance
    Subbu

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Are you going to tell us what data type you used and what input literals gave you the error?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2009
    Posts
    4
    Hi,
    I AM USING ZOS V8.1
    i have used date as a data type for input parameter I_PROCESS_DATE.
    IF I PASS NULL VALUE TO PARAMETER THEN RUN IS WORKING.
    IF I PASS SOME DATE TO PARAMETER THEN I AM GETTING THE ERROR WHILE RUNNING.
    ERROR AS
    SQL0332N There is no available conversion for the source code page "5348" to the target code page "37". Reason Code "DSNXVDTT". SQLSTATE=57017

    PLEASE HELP ME IN THIS.
    THANKS & REGARDS,
    SUBBU.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You care to tell us some more details like:
    - the code of the stored procedure (stripped down to the bare minimum that exhibits the problem
    - the code how you call the procedure, including the literals that Marcus asked for?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by SUBRAHMANYAM
    Hi,
    I AM USING ZOS V8.1
    i have used date as a data type for input parameter I_PROCESS_DATE.
    IF I PASS NULL VALUE TO PARAMETER THEN RUN IS WORKING.
    IF I PASS SOME DATE TO PARAMETER THEN I AM GETTING THE ERROR WHILE RUNNING.
    ERROR AS
    SQL0332N There is no available conversion for the source code page "5348" to the target code page "37". Reason Code "DSNXVDTT". SQLSTATE=57017

    PLEASE HELP ME IN THIS.
    THANKS & REGARDS,
    SUBBU.
    For DATE data type, use a CHAR(10). The input should look something like this:
    '2009-02-24'

    In your SP, you can then compare any DATE column to the the CHAR(10). If you have a timestamp, use CHAR(26).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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