Using RPG2SQL Source Samples with AS/400 System running a CCSID other than 037 (US)

This sample works for the German CCSID 273. These instructions should also work for other system CCSID values.

1.) Install RJSRPGSQL library provided by RJS for your CCSID (code page).

2.) Make sure the version is correct by displaying the VERSION data area

DSPDTAARA DTAARA(RJSRPGSQL/VERSION)

Example: This version is for Germany CCSID - 273

RPG2SQL Integrator Version V1.18 - 273

3.) Create a source physical file using your CCSID. This sample uses 273 (Germany)

CRTSRCPF FILE(RJSRPGSQL/SOURCE273) RCDLEN(132) CCSID(273)

4.) To verify the CCSID for a source file, use the following command and then search for the CCSID value.

DSPFD FILE(RJSRPGSQL/SOURCE273)

5.) Copy any samples from the file: SOURCE in library: RJSRPGSQL to your new source file and compile them.

6.) Set the EBCDIC/Translation Tables to use with your CCSID. Listed below are examples for multiple countries.

U.S. EBCDIC to ASCII:

CHGDTAARA DTAARA(RJSRPGSQL/SQLASCII) VALUE(Q037337850)

U.S. ASCII to EBCDIC

CHGDTAARA DTAARA(RJSRPGSQL/SQLEBCDIC) VALUE(Q850337037)

German EBCDIC to ASCII:

CHGDTAARA DTAARA(RJSRPGSQL/SQLASCII) VALUE(Q273BF850)

German ASCII to EBCDIC

CHGDTAARA DTAARA(RJSRPGSQL/SQLEBCDIC) VALUE(Q850337273)

Italian EBCDIC to ASCII:

CHGDTAARA DTAARA(RJSRPGSQL/SQLASCII) VALUE(Q280BF850)

Italian ASCII to EBCDIC

CHGDTAARA DTAARA(RJSRPGSQL/SQLEBCDIC) VALUE(Q850337280)