IBM SC41-5210-04 manual For displayed output, the run request continues, but all

Table 14. CCSIDs Conversion Problems-Run-Time Consequences (continued)

Item 1	Item 2	Consequence
Collating sequence	Job	Cannot convert table for performing break, minimum, or
		maximum for field. The run request fails for printer output.
		For displayed output, the run request continues, but all
		values and summaries are shown as replacement strings
		(+++).

Note: For output to display, Query uses a single diagnostic message to warn you to look for unwanted dots and missing edit word text. There is no warning when you print a report.

1.This can happen when you specify that character substitution warnings not be ignored on the Specify Processing Options display.

Table 15 shows what happens at run time when items are marked with compatible substitution CCSIDs, but conversion of Item 1 to the CCSID of Item 2 requires use of a substitution character for some value, and character substitution warnings are not ignored.

Table 15. Compatible with Substitution CCSIDs, Conversion Failure-Run-Time Consequences

Item 1	Item 2	Consequence
Field 2	Field 1	Cannot perform comparison for join. Run ended (output is
		incomplete).1
Field 2/constant	Field 1	Cannot perform comparison for record selection. Run
		ended (output is incomplete).1
Field 2/constant	Field 1	Cannot calculate result field value for sorting. Run ended
		(no records returned).1
Field 2/constant	Field 1	Cannot calculate result field value for use in record
		selection (the error could occur for the tested field or test
		value). Run ended (output is incomplete).1
Field 2/constant	Field 1	Cannot calculate result field value for output.
		Replacement string displayed or printed for value and for
		any subsequent break, minimum, or maximum value for
		the field. Output to database ended (output is incomplete;
		possibly some, but not all, records added).1
Field data	Job	Cannot convert selected field value to the job CCSID,
		therefore it cannot be displayed or printed. Replacement
		string displayed or printed for value and for any
		subsequent break, minimum, or maximum value for the
		field.1
Collating sequence	Job	Cannot perform break, minimum, or maximum on value
		converted for display or print. Run request ended for print
		(output is incomplete). Replacement string displayed for
		value and for any subsequent break, minimum, or
		maximum value for the field.1
Collating sequence	Field	Cannot perform break, minimum, or maximum for
		displayed or printed output for a user with job CCSID
		65535, or for summary only to database. Output is
		incomplete for printer or database. Replacement string
		displayed for value and for any subsequent break,
		minimum, or maximum value for the field.1

1.This can happen when you specify that character substitution warnings not be ignored on the Specify Processing Options display.

Table 16 on page 257 shows the different options allowed for several combinations of process (job) and Query definition CCSIDs. The capital letters A and B represent different CCSIDs neither of which is 65535. The queries with no tags are from a previous release.

256Query for iSeries Use V5R2