IMSTAT Procedure (Data and Server Management)

PROMOTE Statement

The PROMOTE statement is used to change a temporary table to a regular in-memory table. The currently active table must be a temporary table and the table identified with the member-name parameter must not already exist in the server. Promoting a temporary table requires authorization to add a table to the server. You can also specify a tag for the in-memory table with the TAG= option.

Creating a Star Schema

Syntax

PROMOTE member-name </ options>;

Required Argument

member-name

specifies the name to use for the table that is promoted.

PROMOTE Statement Options

PERM=mode

specifies the access permission for the newly created table as an integer. The mode value is specified as an integer value such as 755. The mode corresponds to the mode values that are used for UNIX file access permissions. You must specify a value that preserves Read and Write permission for your user ID.

For Windows servers, the UNIX mode setting is not applicable. Access is controlled according to permissions that you set manually on the signature files directory.
Alias PERMISSION=
Range 600 to 777

TAG='server-tag'

specifies the tag to use for naming the table. If no TAG= option is specified, then the TAG= option from the LIBNAME statement is used. If the LIBNAME statement does not specify the TAG= option, then the name of the libref is used as the server tag.