Filter
Top Products
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.
256 Query for iSeries Use V5R2