IBM SC41-5210-04 manual List

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