IBM SC41-5210-04 manual Command

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