SET CURRENT GET_ACCEL_ARCHIVE statement
The SET CURRENT GET_ACCEL_ARCHIVE statement changes the value of the CURRENT GET_ACCEL_ARCHIVE special register.
Invocation for SET CURRENT GET_ACCEL_ARCHIVE
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
Authorization for SET CURRENT GET_ACCEL_ARCHIVE
None required.
Syntax for SET CURRENT GET_ACCEL_ARCHIVE
Description for SET CURRENT GET_ACCEL_ARCHIVE
- 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 for SET CURRENT GET_ACCEL_ARCHIVE
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;