IBM SC41-5210-04 manual Creating a Query for iSeries query definition

Part 2. Defining and using Query for iSeries query definitions

Chapter 3. Creating a Query for iSeries query definition	.	.	.	.	27
Starting Query for iSeries query definition	.	.	.	.	27
Selecting definition steps when defining a Query for iSeries query	.	.	.	.	28
Selecting options for a Query for iSeries query definition	.	.	.	.	29
Moving through the Query for iSeries definition displays	.	.	.	.	30
When you return to the Query for iSeries Define the Query display	.	.	.	.	30
Considerations for creating Query for iSeries queries	.	.	.	.	30
Selecting files, records, and fields for Query for iSeries	.	.	.	.	30
Suggested sequence of tasks for creating Query for iSeries queries	.	.	.	.	31
Chapter 4. Specifying and selecting files for a Query for iSeries query	.	.	.	.	33
Specifying file selections for a Query for iSeries query	.	.	.	.	33
Choosing a file for a Query for iSeries query	.	.	.	.	34
Choosing a library for a Query for iSeries query	.	.	.	.	34
Choosing a member or record format for a Query for iSeries query	.	.	.	.	35
Selecting multiple files for a Query for iSeries query	.	.	.	.	35
Using file IDs for a Query for iSeries query	.	.	.	.	36
Confirming your options for a Query for iSeries query	.	.	.	.	36
Removing a option for a Query for iSeries query	.	.	.	.	36
Handling errors on the Query for iSeries Specify File Selections display	.	.	.	.	36
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
Example: Selecting matched records from all selected files in a Query for iSeries query	.	.	.	.	47
Example: Selecting matched records using a primary file in a Query for iSeries query .	.	.	.	.	48
Example: Selecting unmatched primary file records in a Query for iSeries query . . .	.	.	.	.	48
Sequencing secondary files for a primary join in a Query for iSeries query	.	.	.	.	49
Example: Sequencing secondary files 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 concatenation operation	.	.	.	.	60
Query for iSeries character functions	.	.	.	.	61
SUBSTR Query for iSeries function	.	.	.	.	61
DIGITS Query for iSeries function	.	.	.	.	62
VALUE Query for iSeries function	.	.	.	.	62
VARCHAR Query for iSeries function	.	.	.	.	63
VARGRAPHIC Query for iSeries function	.	.	.	.	65
Date, time, and timestamp expressions in Query for iSeries	.	.	.	.	66

© Copyright IBM Corp. 2000, 2002 21