Figure 7. Working with and without CCSID Conversion. Conversion, when necessary and possible, is done automatically by the system.

Query for iSeries recognizes when conversion of data, collating sequences, and text is needed, and performs the conversion. The system notifies you if the conversion fails. You may not be able to work on a query or run a saved query depending on the CCSIDs involved. Four conditions can result from CCSID comparisons:

vThey match identically, which means no conversion is necessary.

vThey are compatible, which means complete conversion is possible.

vThey are compatible with substitution, which means conversion is possible but substitution characters might be used. Substitution characters, depending on where they occur, can give unpredictable results, particularly in sorting and testing character fields.

vThey are incompatible, which means conversion is impossible.

This appendix explains how CCSIDs affect what Query for iSeries does in specific circumstances. For more information, see the Query for iSeries section of the National Language Support topic.

246Query for iSeries Use V5R2

Page 258
Image 258
IBM SC41-5210-04 manual Query for iSeries Use V5R2