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
N to N-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