IBM ISERIES SC41-5210-04 - Manual (Page 267)

Table 13. CCSIDs Not Compatible-Definition-Time Consequences (continued)
Item 1 Item 2 Consequence
Collating sequence Field Cannot perform comparison for record selection. Error
diagnosed and displayed on Select Records display or
indicated on the Define the Query or Exit this Query
display. (Can occur when Query definition constant
inherits job CCSID of changing user.)
Field 2/constant Field 1 Cannot perform comparison for record selection. Error
diagnosed and displayed on Select Records display or
indicated on the Define the Query or Exit this Query
display. (Can occur when Query definition constant
inherits job CCSID of changing user.)
1
Field 2/constant Field 1 Cannot calculate expression for key field when building
access plan. Save request rejected; user must submit
request again to save with newly discovered error.
1
1. This can happen when you specify that character substitution warnings not be ignored on the Specify Processing
Options display.
Table 14 shows what happens at run time if Item 1 cannot be converted to the CCSID for Item 2.
Table 14. CCSIDs Conversion Problems-Run-Time Consequences
Item 1 Item 2 Consequence
Field 2 Field 1 Cannot perform comparison for join. Run request
rejected.
Field 2/constant Field 1 Cannot perform comparison for record selection. Run
request rejected.
1
Field data Collating sequence Cannot perform comparison involving dependent value.
Run request fails. No column list results returned.
Field 2/constant Field 1 Cannot calculate expression for key field when building
access plan. Run request fails.
1
Field 2 Field 1 Cannot convert data to CCSID of receiving record field.
Run request fails. (No records added to new file or
member.)
1
Field data Job Cannot display or print field values. Run request fails. 1
Column heading Job Column heading line shown as dots in displayed or
printed report.
Edit word Job J edit code used, not edit word, in displayed or printed
report.
Break text Job Text line segment shown as dots in displayed or printed
report.
Cover page Job Cover page shown as dots in displayed or printed report.
Final text Job Text line segment shown as dots in displayed or printed
report.
Page heading Job Page heading text shown as dots in displayed or printed
report.
Page footing Job Page footing text shown as dots in displayed or printed
report.
Collating sequence Field Cannot perform break, minimum, or maximum on field
for:
v Summary-only output to database
v A user with job CCSID 65535, to printer or display
The run request fails for database or printer output. For
displayed output, the run request continues, but all values
and summaries are shown as replacement strings (+++).
Appendix E. Coded character set identifiers (CCSIDs) in Query for iSeries 255