Access Definition Functions

ALL

Removes all selection criteria, SQL WHERE clause specifications, archive criteria, and archive actions for a table in the Access Definition. Equivalent primary command: ALL.

COL

Identifies the table for which the Describe Columns for AD panel is to be displayed. Equivalent primary command: COLUMNS.

DC[n]

Identifies the table for which child tables from DB2^® relationships are to be included in the Access Definition, where n is an optional value from 1 through 9 indicating the level of child tables. If n is not specified, only directly related child tables from DB2 relationships are included in the Access Definition. Equivalent primary command: GET TABLES RELATED CHILD [n] DB2.

DCA

Identifies the table for which all directly and indirectly related child tables from DB2 relationships are to be included. Children, grandchildren, great grandchildren and so forth from DB2 relationships are included in a continuing chain. Equivalent primary command: GET TABLES RELATED CHILD ALL DB2.

DP[n]

Identifies the table for which parent tables from DB2 relationships are to be included in the Access Definition, where n is an optional value from 1 through 9 indicating the level of parent tables. If n is not specified, only directly related parent tables from DB2 relationships are included in the Access Definition. Equivalent primary command: GET TABLES RELATED PARENT [n] DB2.

DPA

Identifies the table for which all directly and indirectly related parent tables from DB2 relationships are to be included. Parents, grandparents, great grandparents and so forth from DB2 relationships are included in a continuing chain. Equivalent primary command: GET TABLES RELATED PARENT ALL DB2.

DR[n]

Identifies the table for which the parents and children from DB2 relationships are to be included in the Access Definition, where n is an optional value from 1 through 9, indicating the number of levels of related tables from DB2 relationships to retrieve. Equivalent primary command: GET TABLES RELATED [n] DB2.

DRA

Identifies the table for which related tables from DB2 relationships are to be included in the Access Definition. Parents, children, grandparents, and grandchildren are included in a continuing chain so that the entire set of related tables from DB2 relationships is included. Equivalent primary command: GET TABLES RELATED ALL DB2.

EXP

Identifies the table for which an expanded area is displayed to define, display or modify the table name. Equivalent primary command: EXPAND

GC[n]

Identifies the table for which child tables are to be included in the Access Definition, where n is an optional value from 1 through 9 indicating the level of child tables. If n is not specified, only directly related child tables are included in the Access Definition. Equivalent primary command: GET TABLES RELATED CHILD [n].

GCA

Identifies the table for which all directly and indirectly related child tables are to be included. Children, grandchildren, great grandchildren and so forth are included in a continuing chain. Equivalent primary command: GET TABLES RELATED CHILD ALL.

GP[n]

Identifies the table for which parent tables are to be included in the Access Definition, where n is an optional value from 1 through 9 indicating the level of parent tables. If n is not specified, only directly related parent tables are included in the Access Definition. Equivalent primary command: GET TABLES RELATED PARENT [n].

GPA

Identifies the table for which all directly and indirectly related parent tables are to be included. Parents, grandparents, great grandparents and so forth are included in a continuing chain. Equivalent primary command: GET TABLES RELATED PARENT ALL.

GR[n]

Identifies the table for which the parents and children are to be included in the Access Definition, where n is an optional value from 1 through 9, indicating the number of levels of related tables to retrieve. Equivalent primary command: GET TABLES RELATED [n].

GRA

Identifies the table for which related tables are to be included in the Access Definition. Parents, children, grandparents, and grandchildren are included in a continuing chain so that the entire set of related tables is included. Equivalent primary command: GET TABLES RELATED ALL.

LR

Identifies the table for which related tables are to be provided in a selection list. Equivalent primary command: LIST RELATED.

PC[n]

Identifies the table for which child tables from Optim™ relationships are to be included in the Access Definition, where n is an optional value from 1 through 9 indicating the level of child tables. If n is not specified, only directly related child tables from Optim relationships are included in the Access Definition. Equivalent primary command: GET TABLES RELATED CHILD [n] OPT

PCA

Identifies the table for which all directly and indirectly related child tables from Optim relationships are to be included. Children, grandchildren, great grandchildren and so forth from Optim relationships are included in a continuing chain. Equivalent primary command: GET TABLES RELATED CHILD ALL OPT.

PP[n]

Identifies the table for which parent tables from Optim relationships are to be included in the Access Definition, where n is an optional value from 1 through 9 indicating the level of parent tables. If n is not specified, only directly related parent tables from Optim relationships are included in the Access Definition. Equivalent primary command: GET TABLES RELATED PARENT [n] OPT.

PPA

Identifies the table for which all directly and indirectly related parent tables from Optim relationships are to be included. Parents, grandparents, great grandparents and so forth from Optim relationships are included in a continuing chain. Equivalent primary command: GET TABLES RELATED PARENT ALL OPT.

PR[n]

Identifies the table for which the parents and children from Optim relationships are to be included in the Access Definition, where n is an optional value from 1 through 9, indicating the number of levels of related tables from Optim relationships to retrieve. Equivalent primary command: GET TABLES RELATED [n] OPT.

PRA

Identifies the table for which related tables from Optim relationships are to be included in the Access Definition. Parents, children, grandparents, and grandchildren from Optim relationships are included in a continuing chain so that the entire set of related tables is included. Equivalent primary command: GET TABLES RELATED ALL OPT.

SEL

Identifies the table for which the Specify Selection Criteria for AD panel is to be displayed. Equivalent primary command: SELECTION CRITERIA.

SQL

Identifies the table for which the SQL WHERE Clause panel is to be displayed. Equivalent primary command: SQL.

STA

Displays the criteria specified for a given table in the Criteria in Effect pop-up.

Notes^®

• The GR and LR line commands obtain the same list of tables. The GR line command automatically adds the related table names to the Access Definition. The LR line command displays a selection list from which you select the tables to be included in the Access Definition.
• Use the Select line command to select a table from the list provided by the LR line command. Use END to terminate list processing.
• Use the Move line command to rearrange the order of the columns on these panels. This order determines the display order when viewing the data either during an edit/browse session or a Point-and-Shoot session.
• The Relationship Processing User Option determines the type of relationship (Optim OPT, DB2, or both) used to populate the Table List. The OPT and DB2 keywords override this option.

The following line commands are available on the Select Tables/Views for AD panel for Archive only:

ACT

Identifies the table for which the Select an Action To Be Defined panel is to be displayed. Equivalent primary command: ACTIONS.

ARC

Identifies the table for which the Specify Archive Criteria for AD is to be displayed. Equivalent primary command: ARCHIVE.

Specify Criteria

The following line command is available on the Describe Columns for AD, Specify Selection Criteria for AD and Specify Archive Criteria for AD panels.

Z

Identifies the column to be zoomed. On the Describe Columns for AD and Specify Selection Criteria for AD panels, zooms the multi-column display to a single column format and displays all the information for that one column on a single screen. Equivalent primary command: ZOOM.

Specify Relationship Usage

The following line commands are available on the Specify Relationship Usage panel for Archive, Move, or Compare.

D

Deletes an unknown relationship.

I

Displays information about a relationship.

S

Selects an unselected or new relationship.

U

Unselects a selected or new relationship.

• The option Use NEW Relationship on the Access Definition Parameters panel determines whether new relationships are to be automatically selected or unselected.
• A relationship is assigned UNKNWN status when, for example, the default Creator ID is changed such that a different pair of tables is referenced and a same-name relationship is not defined for these tables. You are not required to delete these relationships and, in fact, if you use this same Access Definition and only change the Creator ID to extract from different source tables it may be desirable to retain these relationships and their SELECT/UNSEL status.

Substitution Variable Display

The following line command is available on the Substitution Variable Display panel.

EXP

Displays a pop-up window for the default value of the substitution variable. This expanded display provides two 50‑character lines for the default value.