Register Table

Valid in: SQL, ESQL

The Register Table statement maps the structure of a file to the structure of a table.

Syntax

The Register Table statement has the following format:

[EXEC SQL] REGISTER TABLE [schema.]table_name
              (column_name  col_type  [IS 'external_name']

              {, column_name  col_type  [IS 'external_name']})

              AS IMPORT FROM 'security_log_file_name'

              WITH   DBMX=SXA

                            [, ROWS = integer_value];

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 updateable 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