IBM SC41-5210-04 manual Index Special Characters, Date

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