Change the CCSID

The CCSID (coded character set ID) designates the binary code page in which the AS/400 returns data. The default is 65535. If you do not change the CCSID, the access service returns character data from the AS/400 in binary form. When mapped to ASCII format, this data appears as hexadecimal characters.

Changing the CCSID does not affect how the AS/400 stores data. AS/400 programs set the CCSID to a value appropriate to its function. The DirectConnect access service does not require a specific CCSID. For English installations, use code page 37 or 500.

Changing the CCSID at the User Profile level

To change the CCSID at the user profile level, your user ID must have QSECOFR authority.

To change the CCSID at the user profile level

1. Log on to the AS/400 at the main console, a 5250 terminal, or a 5250 emulator.

2. To display the Work with User Profile window, enter the following:

   WRKUSRPRF USER_ID
   

   where USER_ID is a valid user ID for the AS/400 with QSECOFR authority.

3. Select option 2.

4. Press F10 to view additional parameters. Page down until you find the CCSID setting.

5. Change the CCSID and press Enter.

Any physical file that is created with this user profile has the new CCSID assigned to the file character fields.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF