Code Pages

CONNX supports CODEPAGE and SBCCSID settings. The various code pages are stored in c:\connx32\sbtabs (if the installed database supports code pages). Code pages can be recognized by the R2D extension, where the first four hex numbers of the file represent the server SBCCSID, and the last four hex numbers represent the Client (or Windows) SBCCSID translation. The default code page setting in CONNX is 37 (United States EBCDIC).

 

The SBCCSID can be changed using the SBCCSID configuration setting.

 

The following list includes some widely used code page settings:

37- United States - EBCDIC

273 Austria, Germany - EBCDIC

278 Finland, Sweden - EBCDIC

285 United Kingdom - EBCDIC

Please see IBM's web site for a complete list of code pages that run on IBM mainframes.

 

For the Windows client machine, the client-based SBCCSID is often obtained when CONNX performs a Windows call that sets the proper code page. If you wish to override the default value, specify the SBCCSID in the CONNX section of the registry.

You can also set the code page for individual columns of a table by using the CONNX Configuration Manager, and specifying it to a value that is appropriate. The code page is specified in the Table Columns tab for the table in the Code Page column.  

If the database is located on a server machine, the code page will be obtained from that system's operating system.  Please note: Normally, you should not have to do anything. The code page will be set automatically at import time.  If you need to change the code page either by changing the code page on the server or by changing the client SBCCSID value, you may need to re-import all the tables in the CDD if you wish the new code page value to be set in all the tables.