Filter
Top Products
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