USING

USING

Top  Previous  Next

 

The USING clause allows a query to be processed using the dictionary of another file.

 

 

Format

 

USING { DICT } file.name

 

where

 

DICTspecifies that the dictionary of the named file is to be used.

 

file.nameis the file to be used as the dictionary for the query.

 

 

The USING keyword allows a query to be processed with an alternative dictionary. It is of particular use where files share a dictionary.

 

The query processor uses the dictionary of the file being reported until the USING clause is encountered. All subsequent command line items are parsed using the specified dictionary. It is therefore usual to place the USING clause immediately after the query file name.

 

 

Example

 

LIST ARCHIVED.CUSTOMERS USING DICT CUSTOMERS

 

This command lists an archive file of customer data using the dictionary of the main CUSTOMERS file.