SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

MXCI Commands
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
4-34
GET NAMES OF RELATED NODES Command
GET NAMES OF RELATED NODES Command
The GET NAMES OF RELATED NODES command displays the names of the
transitive closure of nodes that are related to the specified node. A node is related to
another node if they have one or more catalogs in common. The specified node is
included in the output.
node
is the node name for which the list of related nodes is requested. The default is the
local node.
Error Conditions for GET NAMES OF RELATED NODES
An error for the GET NAMES OF RELATED NODES command occurs when:
•
The specified node does not exist.
•
The specified node cannot be accessed.
•
One or more required nodes other than the specified node cannot be accessed.
•
SQL/MX is not installed on the specified node.
•
An invalid node name is specified.
Example of GET NAMES OF RELATED NODES
In this example, catalog CAT1 is visible on \LONDON and \GLASGOW, catalog CAT2 is
visible on \LONDON and \CPH, and catalog CAT3 is visible on \BERLIN and \CPH:
>> GET NAMES OF RELATED NODES FOR \LONDON;
NODES:\BERLIN
\CPH
\GLASGOW
\LONDON
GET NAMES OF RELATED NODES [FOR node];