Filter
Top Products
Query for iSeries date .............................67
Query for iSeries time .............................67
Query for iSeries timestamp ..........................68
Displaying constants format in Query for iSeries ....................69
Date, time, and timestamp arithmetic operations in Query for iSeries .............69
Date arithmetic operation in Query for iSeries .....................70
Subtracting dates in Query for iSeries .......................70
Incrementing and decrementing dates in Query for iSeries ...............71
Converting a numeric field to a date field in Query for iSeries ..............71
Working with numeric dates in Query for iSeries ...................71
Time arithmetic operation in Query for iSeries .....................73
Incrementing and decrementing times in Query for iSeries ...............73
Timestamp arithmetic operation in Query for iSeries..................73
Durations in Query for iSeries ...........................73
Labeled duration in Query for iSeries .......................73
Date duration in Query for iSeries ........................73
Time duration in Query for iSeries ........................73
Timestamp duration in Query for iSeries ......................74
Date, time, and timestamp functions in Query for iSeries ..................74
CHAR Query for iSeries function ..........................74
DATE Query for iSeries function ..........................75
DAY Query for iSeries function ..........................75
DAYS Query for iSeries function ..........................76
HOUR Query for iSeries function..........................76
MICROSECOND Query for iSeries function ......................77
MINUTE Query for iSeries function .........................77
MONTH Query for iSeries function .........................78
SECOND Query for iSeries function.........................78
TIME Query for iSeries function ..........................79
TIMESTAMP Query for iSeries function .......................79
YEAR Query for iSeries function ..........................80
Additional date, time, and timestamp functions in Query for iSeries .............80
Converting date formats in Query for iSeries ......................80
Converting date for output to a database file in Query for iSeries ..............80
Converting date for output to a display or printer in Query for iSeries ............81
Example 1—Converting from MMDDYY to YYDDD format in Query for iSeries ........81
Example 2—Converting from MMDDYY to YYDDD format in Query for iSeries ........81
Example 3—Converting from YYDDD to MMDDYY format in Query for iSeries ........82
Example 4—Converting from MMDDYY to YYDD format in Query for iSeries ........82
General considerations when creating an expression in Query for iSeries ............83
Column headings in Query for iSeries .........................85
Length and decimal positions in Query for iSeries ....................85
Example of defining a result field in Query for iSeries ..................86
Adding or removing result fields in Query for iSeries ...................86
Chapter 6. Selecting and sequencing fields in Query for iSeries..............87
Letting Query for iSeries select and sequence fields....................87
Selecting fields and specifying their sequence in Query for iSeries ..............87
Chapter 7. Selecting records in Query for iSeries ...................91
Letting Query for iSeries select records ........................91
Selecting the records you want in Query for iSeries ....................91
Comparison fields in Query for iSeries........................92
Comparison values in Query for iSeries .......................93
Fields as values in Query for iSeries .......................94
Character constants as values in Query for iSeries ..................94
22 Query for iSeries Use V5R2