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
Error: Deploy M4567TY.PROCEDURE1
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?