CREATE_TABLE

Messages with __TYPE=1 (XlaConstants.CREATE_TABLE) indicate that a table has been created.

Table 6-3 shows the name/value pairs that are in a MapMessage instance generated for a CREATE_TABLE operation.

Table 6-3 CREATE_TABLE Data Provided in Update Messages

Name	Value
OWNER	String value of the owner of the created table
NAME	String value of the name of the created table
PK_COLUMNS	String value containing the names of the columns in the primary key for this table If the table has no primary key, the PK_COLUMNS value is not specified. Format: <col1name>[;<col2name> [;<col3name>[;...]]]
COLUMNS	String value containing the names of the columns in the table Format: <col1name>[;<col2name> [;<col3name>[;...]]] Note: For each column in the table, additional name/value pairs that describe the column are in the MapMessage.
_column_name_TYPE	Integer value representing the data type of this column (from java.sql.Types)
_column_name_PRECISION	Integer value containing the precision of this column (for NUMERIC or DECIMAL)
_column_name_SCALE	Integer value containing the scale of this column (for NUMERIC or DECIMAL)
_column_name_SIZE	Integer value indicating the maximum size of this column (for CHAR, VARCHAR, BINARY, or VARBINARY)
_column_name_NULLABLE	Boolean value indicating whether this column can have a NULL value
_column_name_OUTOFLINE	Boolean value indicating whether this column is stored in the inline or out-of-line part of the tuple
_column_name_INPRIMARYKEY	Boolean value indicating whether this column is part of the primary key of the table