NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
U-16
USAGES Table
refer to an object on which another object depends. The dependent object is called a
using object.
The USAGES table was created in version 1. The CP option was added to
USEDOBJTYPE and USINGOBJTYPE in version 300.
The relations recorded in the USAGES table are:
•
Program uses view, table, or index
•
View uses view or table
•
Index uses table
•
Table, view, index, or program uses collation
If a table or index is partitioned or a view has an underlying partitioned table, the
relations are established with the primary partition and recorded in the primary
partition's catalog.
Relations between objects that reside in separate catalogs appear in both catalogs.
Relations between partitions and relations to constraints, comments, or files are not
recorded. This information is already present in other catalogs.
Only direct relations are stored. Indirect relations can be determined by following a path
from one relation to another.
The lock length for the USAGES table is set to zero to indicate that the entire primary
key length should be used for locking.
Column Name Data Type Description
1 USEDOBJNAME *
CHAR(34) Name of initial object
2 USEDOBJTYPE * CHAR(2) CP if collation
IN if index
TA if table
VI if view
3 RELATIONSHIPTYPE *
CHAR(2) DP if using object depends on used
object
4 USINGOBJNAME * CHAR(34) Name of dependent object
5 USINGOBJTYPE * CHAR(2) IN if index
VI if view
PG if program
TA if table
6 USEDCATALOGNAME CHAR(25) Subvolume of catalog that describes
initial object
7
USINGCATALOGNAME
CHAR(25) Subvolume of catalog that describes
dependent object
* Indicates primary key