REGISTER TABLE Statement--Register IMA Table
The REGISTER TABLE...AS IMPORT statement has the following syntax:
REGISTER TABLE tablename
(col_name format [IS 'ext_format'] {, col_name format [IS 'ext_format']})
AS IMPORT FROM 'source'
WITH DBMS = IMA
[, STRUCTURE = NONE | [UNIQUE] SORTEDKEY]
[, KEY = (col_name [ASC] {, col_name})]
[, ROWS = nnnnnnnn]
[, [NO]DUPLICATES]
[, [NO]UPDATE]
[, [NO]JOURNALING]
;
where:
tablename
(Required) Is the name of the table, which must follow the standard naming convention.
col_name
(Required) Is the name of the column, which must follow the standard naming convention.
format
(Required) Is the data type of the column.
IS 'ext_format'
Specifies the management object being referenced, by extended format string name. This can be:
Classid
A reserved name identifying metadata.
VNODE
Column is vnode places only char type.
SERVER
Column is server places only char type.
CLASSID
Column is the classid name char type.
INSTANCE
Column is the instance value char type.
VALUE
Column is the char value of the {place, classid, instance} object.
PERMISSIONS
Column is the integer management object permission mask for the classid.
AS IMPORT FROM 'source'
(Required) Indicates that the table being registered is for a gateway product. The value of
source must be enclosed in single quotation marks, and is either "objects" or "tables," as described in
IMA Table Types:
IMPORT FROM 'objects'
IS 'ext_format' clause values can be any of the following:
'VNODE'
'SERVER'
'CLASSID'
'INSTANCE'
'VALUE'
'PERMISSIONS'
These values are case sensitive and must be uppercase.
IMPORT FROM ‘tables’
IS 'ext_format' clause values can be any of the following:
'VNODE' or 'SERVER'
classid
These values are case sensitive: 'VNODE' or 'SERVER' must be uppercase and the classids must be in lowercase.
WITH
(Required) Introduces additional information about the table being imported.
DBMS = IMA
(Required) Indicates that the table is registered with IMA. The only possible value is IMA.
STRUCTURE =
(Required) Specifies whether the table is keyed or not. For IMA tables, the only valid structure is either:
SORTKEYED
UNIQUE SORTKEYED
KEY =
(Required) Specifies the column name(s) to use as the key.
For tables with IMPORT FROM 'objects', the key must contain a maximum of three columns from the following: VNODE or SERVER, CLASSID, INSTANCE, and the order must follow the same sequence.
For tables with IMPORT FROM 'tables', the key must contain a maximum of two columns. If two columns are specified, the first must be either VNODE or SERVER, both VNODE and SERVER cannot be specified.
ROWS = nnnnnnnn
(Optional) Specifies the approximate number of rows in the table. If omitted, a default of 1000 is used, which is used by the query optimizer as the number of rows in the table.
[NO]DUPLICATES
(Optional) Indicates whether the table can contain duplicate rows. If this parameter is omitted, duplicates will be considered.
[NO]UPDATE
(Optional) Indicates whether the table can be updated.
For tables with IMPORT FROM 'objects' can be UPDATE or NOUPDATE.
For tables with IMPORT FROM 'tables' must be NOUPDATE.
If this parameter is omitted, the default is NOUPDATE (read-only).
[NO]JOURNALING
(Optional) Indicates whether journaling is allowed. For IMA tables, only NOJOURNALING is allowed.