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.