SET PASSTHROUGH

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

SET PASSTHROUGH

SET 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 PASSTHROUGH statement sets the SQL passthrough mode in solidDB^® Universal Cache.

NONE

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

CONDITIONAL

QL 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 PASSTHROUGH statement takes effect immediately, starting from the next SQL statement, until it is reverted by a similar statement or SET TRANSACTION PASSTHROUGH.