Filter
Top Products
CCSID and result field column headings in Query for iSeries
A column heading in a result field definition is converted, if necessary, to the job or document CCSID when
it is passed back to the document or shown in a report. Dots (...) are shown if the conversion fails.
CCSID and sort fields in Query for iSeries
If the CCSID of the sort field is different from the collating sequence CCSID, the sequence is converted to
the field CCSID. If the conversion fails, an error message is sent to the user.
CCSID and record selection tests in Query for iSeries
Query for iSeries users in countries other than the United States should type field names and keywords
(for example, NULL) in uppercase to ensure correct results.
At create time, the constants are assumed to be in the job CCSID. At change time, the constants are
assumed to be in the job CCSID of the changing user if the create time CCSID is 65535. If the fields or
constants used do not have compatible CCSIDs, or if any collating sequence table to be used cannot be
converted, you see an error message.
CCSID and summary functions in Query for iSeries
Conversions are performed as needed to evaluate the minimum and maximum functions selected for
character fields. For displayed or printed output, evaluation occurs after the data is converted to the job or
document CCSID after records are sorted. Minimum and maximum function evaluation is done on
unconverted data for summary output to a database file. Any conversion needed to put the results into an
existing file is done later.
If a collating sequence is involved, it is converted as needed to the CCSID in which the data is being
evaluated. If a conversion error occurs while the collating sequence is being converted, you see an error
message. This happens only while a query is running.
CCSID and column formatting and editing in Query for iSeries
Column headings and edit words are converted, if necessary, to the document or job CCSID when passed
back to a document or shown in a report. Dots are used if the conversion fails. For an edit word, this
forces an error that causes edit code J to be used.
CCSID and report breaks in Query for iSeries
Conversions are performed as needed to evaluate the report break functions selected for character fields.
For displayed or printed output, evaluation occurs after the data is converted to the job or document
CCSID after records are sorted. Report break evaluation is done on unconverted data for summary output
to a database file. Any conversion needed to put the results into an existing file is done later.
If a collating sequence is involved, it is converted as needed to the CCSID in which the data is being
evaluated. If a conversion error occurs while the collating sequence is being converted, you see an error
message. This happens only while a query is running.
CCSID and break and final text in Query for iSeries
Break text is converted, if necessary, to the document or job CCSID when passed back to a document or
shown in a report. Dots are used if the conversion fails.
CCSID and cover page, page headings and footings in Query for
iSeries
Page text is converted, if necessary, to the document or job CCSID when passed back to a document or
shown in a report. Dots are used if the conversion fails.
Appendix E. Coded character set identifiers (CCSIDs) in Query for iSeries 253