08-11-15, 08:41 #1Registered User
- Join Date
- Jul 2014
Unanswered: Character conversion between ccsid 1208 to 850 requested by dsnxrst is not supported
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.
CREATE PROCEDURE PROCEDURE1 ()
RESULT SETS 1
WLM ENVIRONMENT WLMENV1
RUN OPTIONS 'NOTEST(NONE,*,*,*)'
-- Declare cursor
DECLARE cursor1 CURSOR WITH RETURN FOR
SELECT NAME FROM SYSIBM.SYSTABLES;
-- Cursor left open for client application
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.
Last edited by HABBIE; 08-11-15 at 11:53.
08-11-15, 17:54 #2Registered User
Provided Answers: 6
- Join Date
- May 2012
- Canberra, Australia
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 cant get them together again, there must be a reason. By all means, do not use hammer. IBM maintenance manual, 1975 "