Filter
Top Products
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