RPGLE with Embedded SQL using Unicode

["Andrew Lutz" <andrew.lutz@xxxxxxxxxxxx>]

I have been testing whether I can convert existing RPGLE programs with
Embedded SQL to use tables that have converted to Unicode.

 

 

Here is what I have:

 

 

            Table defined as such:

 

CREATE TABLE CURRENCY_TABLE ( 

            CURRENCY_ID FOR COLUMN CURRENCYID GRAPHIC(3) CCSID 13488 NOT
NULL DEFAULT '' , 

            DESCRIPTION FOR COLUMN DESCRIP    VARGRAPHIC(40)
ALLOCATE(20) CCSID 13488 NOT NULL DEFAULT '' , 

            PRIMARY KEY( CURRENCY_ID ) ) ; 

 

The problem that I am discovering is:

 

            RPGLE variables defined against the externally defined data
structure are correct for example

 

            wCURRENCY_ID is        C(3) CCSID(13488)

            wDescription is              C(40) VARYING CCSID(13488)

 

 

            Embedded SQL variables however are not correct?

 

            G(3) for the SQL variable for CURRENCY_ID

            G(40) varying for SQL variable for DESCRIPTION

 

 

            In the compile I now get a RNF7416 types don't match on EVAL
error message

 

 

 

 

HELP

 

 

 

 

 

 

 

Andrew Lutz

Database Administrator

PMI Mortgage Insurance Company

11050 White Rock Road, Suite 100

Rancho Cordova, CA 95670

916.851.7140 (direct)

925.437.5715 (mobile)

866.472.6246 (toll free)

Andrew.Lutz@xxxxxxxxxxxx