Pathmaker Reference Manual

TABLE Statement
Pathmaker Application Definition Language (PMADL)
067869 Tandem Computers Incorporated 2–63
TABLE Statement The TABLE statement defines an SQL Table registration in the current Pathmaker
catalog.
TABLE name ( { DEFINE-NAME filename }
{ , TABLE-NAME filename }
[ , ACCESS-PATH name ( [ COMMENT text ]
[ , UNIQUE { YES } ]
{ NO }
[ , COLUMN name [ , ... ] ])
) ;
name
Specifies the name of a table to identify the SQL table, and the attributes associated
with it, within the catalog.
DEFINE-NAME filename
Specifies the name of a file to specify a logical DEFINE file name of the registered
table. The file name is a logical DEFINE name, unique among the logical DEFINE
names of all SQL tables registered in the current Pathmaker catalog.
TABLE-NAME filename
Specifies the name of a file to specify the physical SQL table name of the registered
table. The file name must be an existing SQL base table or view.
ACCESS-PATH name
Specifies the name of an access path to be associated with the SQL table in the
current Pathmaker catalog. A SQL table can define multiple access paths.
The name identifies the access path within the catalog. It must be unique among
the names of all access paths associated with the table.
An access path consists of a sequence of columns in the table. You can order the
rows in the table according to the values in the first column, and within groups of
equal values according to the values in the second column, and so on. The
Pathmaker product can generate service source code for standard operations that
retrieve rows from the table in the order implied by the columns.
COMMENT text
Specifies up to 40 characters of internal documentation text to be associated
with the access path.
If you do not supply a COMMENT clause, the access path will not have any
internal documentation associated with it.