-* Hold file 1
TABLE FILE CUSTOMERS
BY CUSTOMER_ID
BY LAST_NAME
ON TABLE HOLD AS HOLD_NAMES
END

-* Hold file 2
TABLE FILE CUSTOMERS
BY CUSTOMER_ID
BY COUNTRY
ON TABLE HOLD AS HOLD_COUNTRIES
END

-* Join hold files
JOIN CUSTOMER_ID IN HOLD_NAMES
TO CUSTOMER_ID IN HOLD_COUNTRIES AS J1
END

-* Output
TABLE FILE HOLD_NAMES
BY CUSTOMER_ID
BY J1.COUNTRY
ON TABLE PCHOLD FORMAT HTML
END

APP PREPENDPATH IBISAMP

-* Hold file 1
TABLE FILE CAR
BY COUNTRY
BY CAR
ON TABLE HOLD AS HOLD_NAMES
END

-* Hold file 2
TABLE FILE CAR
BY COUNTRY
BY MODEL
ON TABLE HOLD AS HOLD_COUNTRIES
END

-* Join hold files
JOIN COUNTRY IN HOLD_NAMES
TO COUNTRY IN HOLD_COUNTRIES AS J1
END

-* Output
TABLE FILE HOLD_NAMES
BY COUNTRY
BY J1.MODEL
ON TABLE PCHOLD FORMAT HTML
END

 (FOC003) THE FIELDNAME IS NOT RECOGNIZED: J1.MODEL
 BYPASSING TO END OF COMMAND
 (FOC009) INCOMPLETE REQUEST STATEMENT

 0 NUMBER OF RECORDS IN TABLE=        6  LINES=      6
 0 NUMBER OF RECORDS IN TABLE=        6  LINES=      6

 0 NUMBER OF RECORDS IN TABLE=       10  LINES=     10
 0 NUMBER OF RECORDS IN TABLE=       18  LINES=     18

-* Output
TABLE FILE HOLD_NAMES
BY COUNTRY
BY MODEL
ON TABLE PCHOLD FORMAT HTML
END

 JOIN COUNTRY IN HOLD_NAMES
TO COUNTRY IN HOLD_COUNTRIES TAG J1 AS J1 

 JOIN CLEAR J1 

quote:

Adding a Tag Name
How to:

Add a Tag Name


Tag names provide a way of making identical field names a single instance. They function as aliases for the file names in the Join. Tag names are useful when you join a file to itself because in such a Join all field names, segment names, and file names are the same in the host and cross-referenced files. For more information, see Joining a Data Source to Itself: The Recursive Join. Tag names are also useful if a file is used as a target more than once in the join structure.

A procedure can use the tag name of a file as a qualifier for field names and aliases in the file.

If you create a report using a recursive Join without tag names, the field names in the cross-referenced file are prefixes with the first four characters of the Join name.


--------------------------------------------------------------------------------
Top of page
--------------------------------------------------------------------------------


xx
Procedure: How to Add a Tag Name
To add a tag name to a file in the Join:

Double-click the link between the tables. The Join Properties dialog box appears. The Join Properties dialog box also appears if you right-click a selected link or select Properties from the View menu. A thick line appears when a join is selected.
Enter names in the Host Tag and Cross Tag name fields and click OK.
Note:

The following words cannot be used as a tag name: ALL, AND, AS, IN, JOIN, TAG, TO, WITH.
Tag names can be up to eight characters in length.


--------------------------------------------------------------------------------
Top of page
--------------------------------------------------------------------------------


Example: Impact of Tag Names on Join Syntax
The following example illustrates the effect of tag names on the Join syntax:

JOIN
JOBFILE.JOBSEG.JOBCODE IN jobfile TAG tag name Job TO ALL
JOBFILE.JOBSEG.JOBCODE
IN jobfile TAG tag name Jobc AS J4
END


If you add the tag name FILE1 to the host file, and the tag name FILE2 to the cross-referenced file, the following Join is created:

Join

A report can refer to the field names in the host file with the qualifier FILE1 and in the cross-referenced file with the qualifier FILE2, for example, FILE1.JOBSTART and FILE2.JOBSTART. For additional information, see How to View Join Syntax.

Tag names are not supported in Report Painter. You can use qualified field names in Report Painter to differentiate fields and identify the table from which you want to retrieve data.

JOIN COUNTRY IN HOLD_NAMES
  TO COUNTRY IN HOLD_COUNTRIES AS J1 TAG 'J1'