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
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;