Filter
Top Products
CCSID (coded character set identifier) (continued)
definition 246
displaying 17
displaying query 249
edit word 132
file selection 252
footing 253
join tests 252
language code page 256
marking 247, 254
page heading 253
query
options list 256
running 256
table 256
query display
table 249
record selection 253
report break 253
result field 252
run-time record selection 251
Select Records display 97
sort field 253
summary function 253
translation table 116
VALUE function
results 63
changing query
CCSID (coded character set identifier) 250
definition 12
changing query definition 173, 211
CHAR function
argument rules 74
syntax diagram 74
character
constant 60
record selection test 94
expression
result fields 60
field 60
name 60
character comparisons 165
character constant
declaring 94
rules for using 60
shift-in character 60
shift-out character 60
character data
Display Report Layout display 8
character field 248
differences between Query/36 and Query for
iSeries 196
substring
example 61
valid comparisons 46
character field name
valid entries 60
value
description 61
character result field
rules for creating 60
character set support
UCS2 level 1 4
character substitution warning 165
checking query results 8
choices
selecting options 29
CL (control language) 5
creating database files 5
code
Dec field
E 121
J 121
L 121
O 121
T 121
V 121
Z 121
edit 129
L, T, or Z
join test 45
code page
definition 114
example 114
coded character set identifier (CCSID)
break text 253
changing query 250
collating sequence 112, 256
conversion 249
DBCS character field 248
default 248
defining 114
hexadecimal 248
language 248
SBCS character field 248
selecting 111, 114
translation table 248
user-defined 248
column formatting 253
compatibility for conversions 254
cover page 253
definition 246
displaying format 17
displaying query 249
edit word 132
file selection 252
footing 253
join test 252
language code-page 256
marking 247, 254
page heading 253
query
options list 256
running 256
table 256
query display
table 256
record selection 253
report break 253
result field 252
run-time record selection 251
Select Records display 97
264 Query for iSeries Use V5R2