Filter
Top Products
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(89)*
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