SET CURRENT GET_ACCEL_ARCHIVE
The SET CURRENT GET_ACCEL_ARCHIVE statement changes the value of the CURRENT GET_ACCEL_ARCHIVE special register.
Invocation
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
Authorization
None required.
Syntax
.-=-. >>-SET CURRENT GET_ACCEL_ARCHIVE--+---+--+-NO------------+----->< +-YES-----------+ '-host-variable-'
Description
- NO
- Specifies that if a table is archived in an accelerator server, and a query references that table, the query does not use the data that is archived.
- YES
- Specifies that if a table is archived in an accelerator server, and a query references that table, the query uses the data that is archived.
- host-variable
- A variable with a data type of CHAR or VARCHAR. The length must not exceed 255 bytes. Valid values are YES or NO. If host-variable has an associated indicator variable, the value of that indicator variable must not indicate a null value. The value of host-variable must be left justified and must be padded on the right with blanks.
Examples
The following statement sets the
CURRENT GET_ACCEL_ARCHIVE special register to NO to indicate that
when a table is archived in an accelerator server, the table reference
does not include the archived data.
SET CURRENT GET_ACCEL_ARCHIVE=NO;