SET CURRENT ACCELERATOR statement

The SET CURRENT ACCELERATOR statement changes the value of the CURRENT ACCELERATOR special register.

Invocation for SET CURRENT ACCELERATOR

This statement can be embedded in an application program, or it can be issued interactively. SET CURRENT ACCELERATOR is an executable statement that can be dynamically prepared.

Authorization for SET CURRENT ACCELERATOR

None required.

Syntax for SET CURRENT ACCELERATOR

Description for SET CURRENT ACCELERATOR

accelerator-name: A character string constant that represents an accelerator name or an accelerator logical name that is recorded in SYSIBM.LOCATIONS.
host variable: A variable that represents an accelerator name or an accelerator logical name that is recorded in SYSIBM.LOCATIONS.

The accelerator name or host variable that you specify must meet these criteria:

It must be unique within the Db2 subsystem or data sharing group.
It must be 8 characters or fewer.
It must consist of the characters A-Z and 0-9.

Examples for SET CURRENT ACCELERATOR

The following statement sets the CURRENT ACCELERATOR special register so that ACCEL1 is the preferred accelerator.

SET CURRENT ACCELERATOR = ACCEL1;

The following statement sets the CURRENT ACCELERATOR special register to an alias that includes two accelerators, ACCLPRO1 and ACCLPRO2.

INSERT INTO SYSIBM.LOCATIONS (LOCATION, LINKNAME, DBALIAS)
VALUES ('IDAATEST', 'DSNACCELERATORALIAS', 'ACCLPRO1 ACCLPRO2');

SET CURRENT ACCELERATOR = IDAATEST;