Filter
Top Products
list (continued)
selecting items
how 10
library name 10
queries 10
query name 10
selecting items from 16
library 14
subset
Work with Queries display 14
LIST (list) comparison test 95, 97, 165
LOCAL time standard
date and time 67
logical file
definition 5
using with Query or DB2 UDB for iSeries
programs 55
long comment
using F23 to display 10
LT (less than) comparison test 95, 96, 165
M
marking
CCSID (coded character set identifier) 247
matched records join
use every record 43
matched records with primary file join 43
field length restrictions 44
maximum record length
database output 30
maximum summary function
null value 136
member
selecting for file selection 35, 39
menu
IDDU (interactive data definition utility) 199
Query for iSeries Utilities 11
merge
column spacing exception 119
message
Query for iSeries 18
Query for iSeries status 241
message response
differences between Query/36 and Query for
iSeries 196
MICROSECOND function
argument rules 77
syntax diagram 77
migrating query definition
restriction 197
migration
NtoN-1 241
minimum summary function
null value 136
MINUTE function
argument rules 77
syntax diagram 77
MONTH function
argument rules 78
syntax diagram 78
moving
through definition display 30
multilingual environment
result field
naming conventions 58
multiple
Query for iSeries task 13
selecting files for a query 35
N
name
generic 9
numeric field 59
query definition 27
result field 58
special library 10
naming conventions
result field
multilingual environment 58
NE (not equal) comparison test 95, 96, 165
negative sign
editing numeric field 125
NLIKE (not like) comparison test 95, 98, 165
NLIST (not list) comparison test 95, 165
null field
*ALL join 44
joining 45
types 8
null value
average summary function 136
count summary function 136
maximum summary function 136
minimum summary function 136
record selection test 95
total summary function 135
null-capable field
release restrictions 241
numeric
calculations
length and decimal positions 189
constant
record selection test 94
rules for using 59
expression 58
field
converting to a date 71
describing editing 124
editing 122
ignoring error in during processing 164
length and decimal positions 85, 189
numeric dates, working with 71
rounding during processing 164
using in result fields 59
operators 58
numeric expression
result field 59
numeric field 233, 234
numeric formats
packed decimal 233
zoned decimal 233
Index 273