Pathmaker Reference Manual

TABLE Statement
Pathmaker Application Definition Language (PMADL)
2–64 067869 Tandem Computers Incorporated
UNIQUE
Specifies how the Pathmaker product identifies rows.
If you do not specify a UNIQUE clause, the system determines its value from
the columns in the table.
YES Specifies that the Pathmaker product is to consider each row in the
table to be uniquely identified by its values in the columns of the
access path.
NO Specifies that the Pathmaker product is not to consider each row to
be uniquely identified by the columns.
COLUMN name
Specifies a column to be included in the access path. The name is a legal SQL
column name and designates an existing column in the table. An access path
includes at least one column, and can include multiple columns.
Example The following example defines an SQL table to the current project catalog.
TABLE files-table ( DEFINE-NAMR =FILES-TAB
, TABLE-NAME \MYSYS.$AVOL.ASUBVOL.FILES
) ;