SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—640322-001
4-36
GET NAMES OF RELATED CATALOGS
GET NAMES OF RELATED CATALOGS
The GET NAMES OF RELATED CATALOGS command displays the names of the
transitive closure of catalogs related to the specified catalog. Catalogs are related if a
view, a trigger, or a constraint in one catalog references an object in the other catalog.
The specified catalog is included in the output.
catalog-name
is the ANSI name of the catalog for which the list of related catalogs is desired.
There is no default for the catalog-name.
Error Conditions for GET NAMES OF RELATED CATALOGS
An error for the GET NAMES OF RELATED CATALOGS command occurs when:
•
The specified catalog is not visible on the local node.
•
The specified catalog has a manual reference on the local node, and the remote
node(s), where an automatic reference for the catalog exists, cannot be accessed.
•
A related catalog has a manual reference on the local node, and the remote
node(s), where an automatic reference for the catalog exists, cannot be accessed.
•
An invalid catalog name is specified.
Example of GET NAMES OF RELATED CATALOGS
In this example, view CAT1.SCH.V1 references tables CAT2.SCH.T2 and
CAT3.SCHA.T3. A referential integrity constraint exists between tables
CAT3.SCHB.TX and CAT4.SCH.TY.
>> GET NAMES OF RELATED CATALOGS FOR CAT1;
CATALOGS:CAT1
CAT2
CAT3
CAT4
GET NAMES OF RELATED CATALOGS FOR catalog-name;