Creating remote tables and transparent DDL

When a remote table is created through the federated database using transparent DDL, several other actions occur.

When you create the remote table:
  • A nickname is automatically created for the remote table. The nickname has the same name as the table name specified in the CREATE TABLE statement. The remote table has the same name as the table name unless you specify another name using the REMOTE_TABNAME option.
  • The schema of the remote table is the nickname schema unless you specify another schema using the REMOTE_SCHEMA option.
  • The nickname created using transparent DDL can be used like any other nickname. In addition, you can ALTER and DROP the remote table (something you cannot do with a nickname created using CREATE NICKNAME).
  • A row is added in the SYSCAT.TABOPTIONS catalog view with an option name of TRANSPARENT and a value of Y.