Setting the CCSID for Tables and Columns

Syniti Data Replication allows you to set the CCSID (language) for tables and/or columns using the Table Properties dialog. This is useful if you are working with a table that contains columns with characters in different languages or if you need to change the language setting for the entire table. For example, if a column in a n IBM Db2 for i (iSeries/AS400) table is defined as CCSID 37, but in reality it contains data in Arabic, you can set the CCSID for that column to Arabic.

To set the CCSID for an entire table:

  1. Select the source table in the Management Center.

  2. Select Table Properties from the right mouse button menu.

  3. Edit the value of the Character CCSID property. You can obtain the CCSID values from your Db2 documentation.

  4. Click OK to close the dialog.

To set the CCSID for a specific column:

  1. Follow the steps above to display the Table Properties dialog.

  2. In the Character CCSID field, click to open the Field CCSID Settings dialog.

  3. Set the CCSID value for columns as needed.

  4. Click OK to close the dialog.

  5. Click OK to close the Table Properties dialog.

Related Topics
Table Properties Dialog