Syntax:
CREATE statements for all objects of the database catalog defined by the current user that are related to the specified table are written to the file specified after OUTFILE (* as the filename is not allowed).
GRANT statements are written to the command file that define the privileges for these objects that the current user has granted to other users.
The generated command file contains the following statements:
- CREATE TABLE,
- CREATE SYNONYM for table name synonyms the user has defined,
- GRANT for the privileges granted for this table to other users,
- CREATE INDEX for the indexes the user has defined for the table,
- ALTER TABLE ... FOREIGN KEY for the definition of link associations defined between this and other tables,
- CREATE VIEW for the views the user has defined on this table,
- COMMENT ON for the comments the user has defined for the table and its columns and indexes.
Within the generated command file, the statements are stored in the order they will be executed; i.e., a view definition is placed after the CREATE statement for the base tables and any further view tables it refers to.
The generated command file contains one statement that should be handled in a special way. The command file should therefore be executed with CATALOGLOAD TABLE.