Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


DB2/400 databases use a specific term “CCSID” to describe the encoding used for the data stored in the database. CCSID can be defined in DB2/400 for each column separately.

It is worth noting that during the reverse of DB2/400 in Stambia, CCSIDs are not automatically reversed. Therefore, all intermediary tables will be created with the default CCSID of the database.

In most cases this won’t cause any problems, but sometimes it might lead to conversion problems like this:

java.sql.SQLException: [SQL0332] Character conversion between CCSID 1200 and CCSID 65535 invalid.

In case you ever experience any problems related to CCSID, it is worth trying to use the option “Reverse CCSID” to get the CCSIDs into your metadata.

This information will be then used by Stambia druing the creation of the intermediary tables and may ultimately solve your problem.

HOW TO REVERSE CCSID

To use the option, you need to go to your metadata and click on the schema. In the "Advanced" tab you will need to check the option “Reverse CCSID” and then reverse your metadata once again and save it:

 505 reverse ccsid option

 

You can consult the reversed CCSIDs in the “Advanced” tab when you click on the specific column that has a defined CCSID in your database.

505 reversed ccsid

Articles

Suggest a new Article!