Character conversion between CCSID 1208 to 850 requested by DSNXRST is not supported

895 pts.
Tags:
DB2
IBM
z/OS
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.
I think I'm missing some character conversion. OS: Windows 8 DB2 version: 8.1 Can someone kindly let me know? What do I have to do here? Thanks!


Software/Hardware used:
Mainframes Db2
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Attempting to convert from 1208 to 850 could be tricky. CCSID 850 probably has less than 0.2% of the potential characters that CCSID 1208 might have.

    If you could ensure that only 7-bit ASCII characters would ever be found in the data, it might be possible. (But then in that case, why would CCSID 1208 ever be used for the SQL data?)

    Have you tried converting to CCSID 819 instead of 850? There's a better chance of only having matching characters, though it's still a huge difference.
    37,065 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: