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;