Ccsid marking in query for iseries – IBM ISERIES SC41-5210-04 User Manual

Page 259

Advertising
background image

CCSID marking in Query for iSeries

The following bulleted objects contain CCSID tags used by query processing. Each item inherits its CCSID
from the containing item unless marked with an asterisk. An asterisk indicates that the object has its own
CCSID tag. The bulleted items inherit their CCSID from the user profile or job, unless specifically changed.
Numbers in parentheses refer to notes explaining how you can determine CCSID values for the item.
v Query definition ( 1, 6) *

Override column heading ( 5)

Override edit word ( 5)

Constant in expression ( 8)

Constant in value for record selection test ( 8)

Result field name ( 5)

Concatenation symbols ||

First 50 positions in expression, used as result field text ( 5)

Result field column heading ( 5)

Break text

Final totals text (found at break level 0)

Cover page text

Page heading text

Page footing text

Collating sequence (user-defined, or snapshot of translation table, or system sort sequence) ( 2, 7,
8)
*

v Translation table and system sort sequence

Collating sequence ( 8 9) *

v Query user profile

Collating sequence (user-defined default) ( 7, 8) *

v Query program object containing preconfigured language sequences. That is, the module that contains

the sequences for option 2 on the Select Collating Sequence display.

Collating sequence (for language) ( 7, 8) *

v Job description ( 8) *

Data (in printer or display buffers)

Collating sequence (job) *

v File definition *

– File record format ( 8) *

- Text about the format *

- Data (in members) * ( 3, 5)

- Field

v Name ( 5)
v (Original) Column heading ( 5) *
v (Original) Edit word ( 5) *
v Text about the field ( 5) *
v Long comment *
v Null default
v Data (in members)
v Sort sequence for * file ( 4, 5, 8) *

– File member

Appendix E. Coded character set identifiers (CCSIDs) in Query for iSeries

247

Advertising