5. Using a Distributed Database : help register Statement--Get Help with Objects
 
Share this page                  
help register Statement--Get Help with Objects
The help register statement gives you information about:
Registrations in the distributed database catalogs
Mapping between the registered distributed database object names and the names of the underlying linked objects
Linked underlying objects in their respective local databases
This statement is an Interactive SQL Terminal Monitor statement only.
The help register statement returns the following information about the registered object and its underlying object:
Registered name
Owner of the registered name
Type of object
Node name
Database name
Local object name
Owner of the local object
Local DBMS class
SQL text of the registration
The help register statement has the following format:
help register object_name
object_name
Is a table, view, or database procedure.
For more information on the help register statement, see the SQL Reference Guide.