IMSTAT Procedure (Data and Server Management)
- Syntax
Procedure SyntaxPROC IMSTAT (Data and Server Management) StatementBALANCE StatementCOLUMNINFO StatementCOMPRESS StatementCOMPUTE StatementCREATETABLE StatementDELETEROWS StatementDISTRIBUTIONINFO StatementDROPCOLUMN StatementDROPTABLE StatementFETCH StatementFREE StatementLIFETIME StatementNUMROWS StatementPARTITION StatementPARTITIONINFO StatementPROMOTE StatementPURGETEMPTABLES StatementREPLAY StatementSAVE StatementSCHEMA StatementSCORE StatementSERVERINFO StatementSERVERPARM StatementSERVERTERM StatementSERVERWAIT StatementSET StatementSTORE StatementTABLE StatementTABLEINFO StatementUNCOMPRESS StatementUPDATE StatementQUIT Statement - Overview
- Concepts
- Examples
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.
| Examples: | Appending Tables |
Syntax
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
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 |