Description
The REGISTER TABLE statement maps the fields in a file to columns in a virtual table. After registering the file as a table, use SQL to manipulate the contents of the file. The registered table can be referred to in database procedures. To delete a registration, use the REMOVE TABLE statement.
Note: For information on registering IMA tables, see the System Administrator Guide.
Note: This statement is not the same as the REGISTER...AS LINK statement, which is described in the Ingres Star User Guide.
The following statements can be performed against registered tables:
• CREATE VIEW
• CREATE SYNONYM
• CREATE RULE
• COMMENT
• SELECT
• INSERT, UPDATE, AND DELETE (if they are from an updatable Enterprise Access product)
• DROP
• SAVE
• REGISTER...AS LINK (as described in the Ingres Star User Guide)
The following statements cannot be performed against registered tables:
• MODIFY
• CREATE INDEX