IBM ISERIES SC41-5210-04, User Manual

Page: 275 / 294

Index
Special Characters
*ALL authority 159, 168
*ALL join 44, 188
*ALL special library name 10
*ALLUSR special library name 10
*CHANGE authority 159, 168
*CURLIB special library name 10
*EXCLUDE authority 159, 168
*LIBCRTAUT authority 159, 168
*LIBL special library name 10
*QRYDFN (query definition)
object 5
*USE authority 159, 168
*USRLIBL special library name 10
|| (concatenation) operator 60
A
access path
creating 232
floating point fields 236
keyed sequence
definition 231
select/omit 232
size limitations 236
access plan
description 232
updating 233
adding
file selections 35
record selection test (comparison) 103
result field 86
ALL join 188
AND connection
record selection test 101
argument rules
function
char 74
concatenation 60
DATE 75
day 75
days 76
digits 62
hour 76
microsecond 77
minute 77
month 78
second 78
SUBSTR function 61
time 79
timestamp 79
year 80
ascending sequence
sorting records 105
assumed values 7
authority
for query database file output 159
authority (continued)
giving to others for your query 168
security 159
authorization list name authority 159, 168
average summary function
date, time, and timestamp value 136
null value 136
B
batch processing
choosing a query task 12
performance recommendations 240
bibliography 259
bracket characters
DBCS (double-byte character set) 9
bracketed DBCS data
Display Report Layout display 8
length restrictions 44
LIKE comparison test 99
LIKE, NLIKE pattern
special characters 100
NLIKE (not like) comparison test 99
rules for join tests 45
break
level 139
text
CCSID (coded character set identifier) 253
defining report break formatting 144
break, report
definition 139
differences between Query/36 and Query for
iSeries 196
example 140
C
CCSID (coded character set identifier) 114
break text 253
changing query 250
table 250
collating sequence 112, 256
conversion 248, 249
DBCS character field 248
default 248
defining 114
hexadecimal 248
language 248
SBCS character field 248
selecting 112
translation table 248
user-defined 248
column formatting 253
compatibility for conversions 254
concatenation
results 61
cover page 253
© Copyright IBM Corp. 2000, 2002
263