IBM SC41-5210-04 manual CCSIDs Conversion Problems-Run-Time Consequences

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