IBM SC41-5210-04 manual Defining result fields in Query for iSeries

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

ivQuery for iSeries Use V5R2