IBM SC41-5210-04 manual Field

field (continued)

length and decimal position in report 120 missing from file definition

during file selection process						55
starting to change or display a query								55
name
numeric		59
null 8
numeric
editing		122
using in result fields					59
omitting from report				121
result
creating		57
DBCS		187
decimal precision				190
defining		57
differences between Query/36 and Query for
iSeries		196
naming		58
tips and techniques					235
selecting for query 87, 235
selection
default		87
sequencing for query				87, 235
sort
example of how used					106
performance recommendations							236
selecting for query				105, 236
specifying ascending or descending
sequence			105
time
expressions			66
using result fields				66
timestamp
expressions			66
using result fields				66
value record selection test 94
Fields Missing from File Definition display								54
file
adding for query			35
database
creating example				203
defining for query output					154
definition	3
deleting file selection from a query							36
differences between Query/36 and Query for
iSeries	195
displaying selections for a query							41
ID (identifier) 36
identifier (ID)
differences between Query/36 and Query for
iSeries		195
using in a query definition						36

joining

differences between Query/36 and Query for iSeries 195

secondary file sequence rule 49 selecting 47

selecting matched records using a primary file 48

file (continued) joining (continued)

selecting unmatched primary file records 48 sequencing secondary files for a primary join 49

specifying join selections						42
linked
differences between Query/36 and Query for
iSeries			195
logical	5, 55
multiple record formats					187
output to database
differences between Query/36 and Query for
iSeries			196
overriding		187
physical	5
primary	43
relational database				5
secondary		43
Select Member display					39
Select Record Format display							40
selecting file members
Specify File Selections display								35
selecting for a query
Select File display					37
Specify File Selections display								33
selecting for query output 145
sharing	187
Specify File Selections display							35
structure example				3
file ID (identifier)			36
file selection
CCSID (coded character set identifier) 252
footing
printing on a report				153
format 187
Format Report Break display						143
formatting
report break			143
report column spacing					119
function
average summary
date, time, and timestamp value								135
null value			135
CHAR
argument rules				74
syntax diagram				74
count summary
null value			135
DATE
argument rules				75
syntax diagram				75
DAY
argument rules				75
syntax diagram				75
DAYS
argument rules				76
syntax diagram				76
DIGITS
argument rules				62
syntax diagram				62

270Query for iSeries Use V5R2