IMSTAT Procedure (Data and Server Management)

SET Statement

The SET statement is used to append in-memory tables to each other. The result of the operation is not a temporary table, but the appending of rows from the secondary tables to the active table.

Appending Tables

Appending a Non-Partitioned Table to a Partitioned Table

Syntax

SET set-specification1 <set-specification2 ...> </ options>;

Required Argument

set-specification

specifies the table to append to the active table and options. You can list multiple set-specifications. A table can be used in more than one set-specification, and you can specify the active table in a set-specification.

table-name <(TAG='server-tag')>)

table-name

specifies the table to append to the active table.

TAG='server-tag'

specifies the server tag to use for identifying the table to append.

SET Statement Options

DROP

specifies that the secondary tables (the tables specified in the set-specifications) are dropped from the server after the statement executes successfully. If the active table is listed in a set-specification, it is not dropped.

NOPARTITION

specifies to append the secondary tables and undo the partitioning of the active table. If the active table is partitioned, and you append partitioned tables to it, then the server rejects the request unless all the tables have the same partitioning variables, in the same order, and have the same key length. When this option is specified, the active table is no longer partitioned if the SET statement succeeds.

Alias NOPART

WHEREWITHALL

specifies to apply the WHERE clause to the active table, in addition to the secondary tables to append. By default, the rows of the secondary tables that are appended to the active table are filtered according to the WHERE clause. Rows marked for deletion or purging are not appended to the main table. By default, the WHERE clause does not filter rows of the active table. If you want the WHERE clause to apply to the active table, specify this option.

Alias ALLWHERE