IBM SC41-5210-04 manual Report

report (continued)
summary function						237
specifying					135
types			135
using F13 to display layout								8
using F5 to display							8, 169
restriction
migration definitions							197
result field
adding		86
CCSID (coded character set identifier) 252
character			60
character constant							60, 66
column heading						85
concatenation () operation								60
creating			57
date	66
decimal position						85, 188
defining
DBCS			187
unique name						57
differences between Query/36 and Query for
iSeries			196
example of defining							86
expression
character				60
numeric				59
operator				58
length		85, 188
multilingual environment
naming conventions 58
naming			58
numeric constant						59
numeric fields					59
other data types						68
removing			86
SUBSTR (substring) function								61
time	66
timestamp				66
tips and techniques							235
result fields
decimal precision						190
results
checking query					8
returning to Define the Query Display 30
rounding numeric field value 164
rule
function
char			74
concatenation						60
DATE			75
day		75
days			76
digits			62
hour			76
microsecond						77
minute 77
month			78
second				78
SUBSTR (substring) function 61
time			79

rule (continued)
function	(continued)
timestamp 79
value	62
year	80
joining files		44
Run Query (RUNQRY) command				11, 171
run-time record selection
CCSID (coded character set identifier) 251
running query		8
example	206
Exit This Query display			169
interactively
limiting		243
Query for iSeries menu			169
Query Utilities menu 11
RUNQRY (Run Query) command 171
using F5	169
with a different language			115
Work with Queries display 13, 170
RUNQRY (Run Query) command				11, 171

S

saving query definition			167
SECOND function
argument rules	78
syntax diagram	78
secondary file
definition 238
multiple join file considerations					49
used in file join operations 43
secondary file sequencing rule
example of correct method				50
example of incorrect method				51
rules for correct joins			49
Select and Sequence Fields display						87
Select Collating Sequence display					113
Select Definition Type (IDDU) display						200
Select File display	37
Select Member display			40
Select Record Format display				41
Select Records display
CCSID (coded character set identifier)							97
comparison field	92
comparison tests	91
select/omit criteria		43
Select Report Summary Functions display							136
Select Sort Fields display 105
Select System Sort Sequence display						118
Select Translation Table display				116
select/omit access path			232
select/omit criteria
primary records	43
selecting
collating sequence		111, 113
field for query 87
performance recommendations						235
files for a query
Select File display			37
Specify File Selections display						33

276Query for iSeries Use V5R2