Note: This example uses the German CCSID 273, but these instructions also work for other system CCSID values.
- Install the RJSRPGSQL library provided by Fortra for your CCSID (code page).
- Make sure the version is correct by displaying the version data area:
DSPDTAARA DTAARA(RJSRPGSQL/VERSION)
For example: The version for Germany CCSID - 273 is:
RPG2SQL Version V1.18 - 273
- Create a source physical file, where 273 is your CCSID:
CRTSRCPF FILE(RJSRPGSQL/SOURCE273) RCDLEN(132) CCSID(273)
- To verify the CCSID for a source file, use the following command and then search for the CCSID value:
DSPFD FILE(RJSRPGSQL/SOURCE273)
- Copy any samples from the file SOURCE in library RJSRPGSQL to your new source file and compile them.
- Set the EBCDIC/Translation Tables to use your CCSID. 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)
Last Modified On:
No, open a new Support Case