IBM ISERIES SC41-5210-04, User Manual

Page: 282 / 294

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
270
Query for iSeries Use V5R2