IBM SC41-5210-04 manual Dec column data type

date, time, and timestamp field								(continued)
migrating
N to N-1			241
date, time, and timestamp value
average summary function								136
comparing to null					96
IS, ISNOT test				96
total summary function							135
date/time field
editing	127
separator		128
DAY function
argument rules				75
syntax diagram				75
DAYS function
argument rules				76
syntax diagram				76
DB2 UDB for iSeries program
relational database terms
file	5
relationship to OS/400 terms									5
DB2 UDB for iSeries views							237
DBCS (double-byte character set)
bracket characters					9
character constant
shift-in character						60
shift-out character						60
defining result fields
considerations					187
Display Report Layout display 8
LIKE comparison test						99
NLIKE (not like) comparison test									99
pictograph		4
rules for join tests					45
shift-in character				60
shift-out character					60
sorting character data							111
space requirements						9
symbolic characters						4
DBCS (double-byte Character set)
data representation						8
DBCS-either field				8
DBCS-graphic field				9, 45
character constant
requirements				60
concatenation
limitations			60
LIKE, NLIKE pattern
special characters						100
release restrictions					241
DBCS-only field			8
DBCS-open field			8
LIKE, NLIKE pattern
special characters						100
DDS (data description specifications)
introduction			5
Dec column
data type

E45, 182 G 45

J 45, 182

Dec column (continued) data type (continued)

L 182

O45, 182 T 182

V 182 Z 182

Dec field code

E121 J 121 L 121 O 121 T 121 V 121 Z 121

decimal
data error
migration from System/36							234
processing			238
point edited numeric fields						125
position
fields in a report 120
for result field				188
result field			85
decimal data
differences between Query/36 and Query for
iSeries	196
decimal data error
ignoring	164
decimal positions and length
used for internal numeric calculations 189
decimal precision for result fields							190
decimal separator
displaying format				17
default
collating sequence
hexadecimal				248
saving		111
determining order of records for query									105
field selection and sequencing for query									87
record selection for query						91
default values		7
Define Collating Sequence display								115
Define Database File Output display								155
Define Numeric Field Editing display								122
Define Printer Output display						148
Define Report Breaks display						139
Define Result Fields display						57
Define Spooled Output display 151
Define the Query display					28
defining
result field		57
your own collating sequence							115
definition
CCSID (coded character set identifier)									246
code page		114
deleting query
DLTQRY command					11
expression		58
query 176

Index 267