EasyManuals Logo

IBM ISERIES SC41-5210-04 User Manual

IBM ISERIES SC41-5210-04
294 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #59 background imageLoading...
Page #59 background image
You can obtain several different results from a file join when you use different combinations of join tests
and options on the Specify How to Join Files display.
Following are some examples of how you might use the three different types of joins. All of the examples
assume that A.NAME EQ B.NAME was specified on the Specify How to Join Files display.
Example: Selecting matched records from all selected files in a Query for iSeries
query
Typea1ifyouwant records selected from each file only if they have a match with at least one record in
each and every one of the other selected files. That is, for a record to be selected, all the files must have
a matching record as determined by the join specification(s). A match occurs when, for each file used in
the query, the contents of its fields selected for comparison match the test condition(s) given on the
Specify How to Join Files display. (This type, option 1, has no primary or secondary files; all files are
treated equally.)
In this example, if you join files A and B using option 1 (Matched records), the query report contains the
following records. (The report fields and layout are not important here.)
Chapter 4. Specifying and selecting files for a Query for iSeries query 47

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM ISERIES SC41-5210-04 and is the answer not in the manual?

IBM ISERIES SC41-5210-04 Specifications

General IconGeneral
BrandIBM
ModelISERIES SC41-5210-04
CategoryServer
LanguageEnglish

Related product manuals