Note: This example uses the German CCSID 273, but these instructions also work for other system CCSID values. 
 
  1. Install the 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)

    For example: The version for Germany CCSID - 273 is:

    RPG2SQL Version V1.18 - 273      

  3. Create a source physical file, where 273 is your CCSID:

    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 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) 

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016