IBM SC41-5210-04 manual Ccsid compatibility considerations in Query for iSeries, Consequence

CCSID compatibility considerations in Query for iSeries

CCSID marking makes it possible for conversions to be performed before presentation of marked material or use of marked material in comparisons, but can also restrict the use of various combinations of marked items. The following tables show what can occur when pairs of items are marked with different CCSIDs, neither of which is 65535.

Table 13 shows what happens at definition time if item 1 cannot be converted to the CCSID for Item 2.

Table 13. CCSIDs Not Compatible-Definition-Time Consequences

Item 1	Item 2	Consequence
Long comment	Job	Diagnostic shown (not long comment) for F23.
Format text	Job	Format text shown blank on Select Format display.
Format text	Job	Format cannot be specified for file selection. Error
		diagnosed and displayed on Specify File Selections,
		Change File Selections, or File Selection Status displays.
Member text	Job	Member text shown blank on Select Member display.
Original column heading	Job	Format cannot be specified for file selection.
Original edit word	Job	Format cannot be specified for file selection.
Collating sequence	Job	Cannot use sequence to initialize Define Collating
		Sequence display (substitution character involvement is
		always treated as an error in this case). The
		consequence depends on the origin of the collating
		sequence and what you are doing.
		(sequence origin)
		consequence
		(user-defined)
		after a warning, prompt bypassed in display
		mode
		(user-defined)
		after a warning, prompt initialized from other
		source for first showing in change mode
		(language sequence)
		F15 request rejected
		(user-defined default)
		F16 request rejected.
		(job sequence)
		F17 request rejected.
Collating sequence	Field	Cannot perform comparison for join. Error diagnosed and
		displayed on Specify How to Join display or indicated on
		Define the Query or Exit the Query displays.
Field 2	Field 1	Cannot perform comparison for join. Error diagnosed and
		displayed on Specify How to Join display or indicated on
		Define the Query or Exit This Query display.
Field 2/constant	Field 1	Cannot derive expression CCSID. Error diagnosed and
		displayed on Define Result Fields display or indicated on
		Define the Query or Exit This Query display. (Can occur
		when Query definition constant inherits job CCSID of
		changing user.)1
Collating sequence	Constant	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

254Query for iSeries Use V5R2