Charset issue in RPG program runtime on iSeries db2 store procedure call

CAN EMRE ÜNAL

Charset issue in RPG program runtime on iSeries db2 store procedure call

Hi,

i've a db2 store procedure like below. This proc is calling a CL to invoke a rpg program.

CREATE PROCEDURE bsm4obj/TXCL4055
(
INOUT POCNO CHAR (10),
INOUT POCRN DEC ( 2 , 0 ),
INOUT PSPNO CHAR (10),
INOUT PMTAD CHAR (1),
INOUT PYREX CHAR (1),
INOUT PMTYR CHAR (1),
INOUT PKMLK CHAR (10),
INOUT HATVR CHAR (1)
)
LANGUAGE CL NOT DETERMINISTIC NO SQL EXTERNAL
NAME bsm4obj/txCL4055 PARAMETER STYLE GENERAL
and i call this proc from server. (ODBC language ID Turkish);

OdbcCommand cmd = new OdbcCommand("{CALL BSM4OBJ.TXCL4055(?,?,?,?,?,?,?,?)}", as400con);
cmd.CommandType = CommandType.Text;
when executing the RPG program (in step like below) variable 'ŞŞ' is not recognizing by compiler like it is but '@@'

>TSDEPR IFEQ 'ŞŞ'

> //Reading like TSDEPR IFEQ '@@'


the program is executing perfect in QPADEV session on As400 but on call does not behave like this.

i replaced turkish static chars with equivalent char for temporary in RPG.
But i want to find exact solution.
I will be very pleased if you suggest

Thank you,

Can Emre Ünal