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

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
254 Query for iSeries Use V5R2