IBM SC41-5210-04 manual Ccsid and result field column headings in Query for iSeries

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