coded character set identifier (CCSID) (continued)
sort field
253
summary function
253
translation table
116
collating sequence
87, 111, 112, 249
affecting query
112, 165
CCSID (coded character set identifier)
114
collating sequence
256
default
248
hexadecimal
248
language
248
translation table
248
user-defined
248
considerations when changing for query
176
date, time, or timestamp fields
112
default
111
defining your own
115
English language default
113
hexadecimal
113, 114
language sequence
114
performance recommendations
237
purpose
111
selecting
111, 113
setting default
111
system sort sequence
117
translation table
116
using for character comparisons
165
collating sequence affects
112
collating sequence and comparisons
EQ
112
GE
112
GT
112
LE
112
LIKE
112
LIST
112
LT
112
NE
112
NLIKE
112
NLIST
112
RANGE
112
column
formatting for report spacing
119
heading for report
119
heading result field
85
spacing for reports
119
summarizing in reports
137
column formatting
CCSID (coded character set identifier)
253
column heading
specifying
85
command
Create Table (CRTTBL)
112
creating database files
5
CRTTBL (Create Table)
112
Delete Query (DLTQRY)
11, 178
DLTQRY (Delete Query)
11, 178
Override with Database File (OVRDBF)
187
OVRDBF (Override with Database File)
187
Query
deleting
11
running
11
command (continued)
Query/36 procedure equivalents
197
Run Query (RUNQRY)
11, 171
RUNQRY (Run Query)
11, 171
Start Query (STRQRY)
7, 11
STRQRY (Start Query)
7, 11
Work with Query (WRKQRY)
7, 11
WRKQRY (Work with Query)
7, 11
comparison
92
date
96
field
92
test
92
time
96
timestamp
96
value
93
comparison test
EQ (equal)
95, 96, 165
GE (greater than or equal)
95, 96, 165
GT (greater than)
95, 96, 165
IS (is)
95, 96
ISNOT (is not)
95, 96
LE (less than or equal)
95, 96, 165
LIKE (like)
165
DBCS
99
similar patterns
95, 98
LIST (list)
95, 97, 165
LT (less than)
95, 96, 165
NE (not equal)
95, 96, 165
NLIKE (not like)
95, 98, 165
NLIST (not list)
95, 97, 165
comparisons and collating sequence
EQ
112
GE
112
GT
112
LE
112
LIKE
112
LIST
112
LT
112
NE
112
NLIKE
112
NLIST
112
RANGE
112
compatibility
conversions
254
concatenation
60
DBCS-graphic field
limitations
60
mixing DBCS fields and SBCS fields
results
187
Confirm Delete of Queries display
179
confirming selection
creating or changing query definition
36
connection
record selection test (AND and OR)
101
constant
character
60
DBCS
60
record selection test
94
result fields
60, 66
date, time, and timestamp
record selection test
95
Index
265