Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2014
    Posts
    294

    Unanswered: Character conversion between ccsid 1208 to 850 requested by dsnxrst is not supported

    Hi,

    I am trying to create some native sql procedures on db2 Z/os. I have connected to the Mainframe machine through IBM data studio. I can able to connect to the machine.
    When I m trying to compile the Stored procedure.I am getting the below error.

    procedure:

    CREATE PROCEDURE PROCEDURE1 ()
    RESULT SETS 1
    LANGUAGE SQL
    FENCED
    COLLID TEST
    WLM ENVIRONMENT WLMENV1
    RUN OPTIONS 'NOTEST(NONE,*,*,*)'
    P1: BEGIN
    -- Declare cursor
    DECLARE cursor1 CURSOR WITH RETURN FOR

    SELECT NAME FROM SYSIBM.SYSTABLES;

    -- Cursor left open for client application
    OPEN cursor1;
    END P1

    Error:
    Deploy M4567TY.PROCEDURE1

    Running
    M4567TY.PROCEDURE1 - Deploy started.
    CHARACTER CONVERSION BETWEEN CCSID 1208 TO 850 REQUESTED BY DSNXRST IS NOT SUPPORTED. SQLCODE=-332, SQLSTATE=57017, DRIVER=4.17.30
    M4567TY.PROCEDURE1 - Deploy failed.
    M4567TY.PROCEDURE1 - Roll back completed successfully.

    We have set enough CCSID settings on the mainframe server.
    Do I need to change anything on my windows OS or on IBM Data studio ?

    I think i m missing some character conversion.
    OS: Windows 8
    db2 version : 8.1

    Can someone kindly let me know. What I have to do here.

    Thanks
    Last edited by HABBIE; 08-11-15 at 12:53.

  2. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    db2 version : 8.1 ?
    I presume this refers to the m/f level. If so, then you are running a level that is 3 years out of support!
    And did you look up the SQL error code info?
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Tags for this Thread

Posting Permissions

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