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

Read syntax diagramSkip visual syntax diagramSET CURRENT GET_ACCEL_ARCHIVE=NOYEShost-variable

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;