SET TRANSACTION PASSTHROUGH

SQL Guide : solidDB® SQL statements : SET TRANSACTION : SET TRANSACTION PASSTHROUGH

SET TRANSACTION PASSTHROUGH {READ <passthrough level> [WRITE <passthrough level>]} | {WRITE <passthrough level> | [READ <passthrough level>]} | <passthrough level>

where

passthrough level ::= NONE | CONDITIONAL | FORCE | DEFAULT

Usage

The SET TRANSACTION PASSTHROUGH statement sets the SQL passthrough mode for the next transaction in solidDB^® Universal Cache.

NONE: SQL passthrough is not used; no commands are passed from the front-end to the back-end

CONDITIONAL: SQL passthrough is activated by a missing table or a syntax error.

FORCE: SQL passthrough is used to pass all statements from the front-end to the back-end

DEFAULT: causes the current session default for SQL passthrough is used

The SET TRANSACTION PASSTHROUGH statement has effect in the beginning of a transaction, and it affects the transaction until commit or abort. If the statement is issued in the middle of a transaction, an error is returned.