Changing the Passthrough Level for a Connection or Transaction
You can override the current passthrough level using the ttIsql
utility's set passthrough
command which applies to the current
transaction.
You can also override the setting for a specific transaction by calling the
ttOptSetFlag
built-in procedure with the
PassThrough
flag. The following procedure call sets the passthrough
level to 3:
CALL ttOptSetFlag('PassThrough', 3);
The PassThrough
flag setting takes effect when a statement is prepared and it is the setting that is used when the statement is performed even if the setting has changed from the time the statement was prepared to when the statement is performed. After the transaction has been committed or rolled back, the original connection setting takes effect for all subsequently prepared statements.