Filter
Top Products
Selecting files on the Query for iSeries Select File display .................37
Selecting file members on the Query for iSeries Select Member display ............39
Selecting record formats on the Query for iSeries Select Record Format display .........40
Displaying all files selected on the Query for iSeries Display File Selections display ........41
Joining files in a Query for iSeries query ........................42
Types of joins in a Query for iSeries query ......................43
How to join files in a Query for iSeries query .....................43
Rules for joining files in a Query for iSeries query ...................44
Examples of joining files in a Query for iSeries query ..................46
Sequencing secondary files for a primary join in a Query for iSeries query ..........49
Displaying all join tests in a Query for iSeries query ....................53
Handling missing fields in a Query for iSeries query ....................54
Handling missing fields during file selection process of a Query for iSeries query ........55
Handling missing fields when starting to change or display a Query for iSeries query ......55
Chapter 5. Defining result fields in Query for iSeries ..................57
Creating results fields in Query for iSeries .......................57
Query for iSeries result field name .........................58
Query for iSeries expressions ...........................58
Query for iSeries numeric expressions........................59
Query for iSeries character expressions .......................60
Query for iSeries character functions ........................61
Date, time, and timestamp expressions in Query for iSeries ................66
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
Time arithmetic operation in Query for iSeries .....................73
Durations in Query for iSeries ...........................73
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
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
iv Query for iSeries Use V5R2