Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SET Transaction Mode statementUse the SET Transaction Mode statement to specify whether constraints are checked at the statement level or at the transaction level during the current transaction.

SET Transaction Mode statement

Use the SET Transaction Mode statement to specify whether constraints are checked at the statement level or at the transaction level during the current transaction.

Syntax


Element	Description	Restrictions	Syntax
`constraint`	Constraint whose transaction mode is to be changed	All constraints must exist in the same database, which must support logging	Identifier

Usage

To enable or disable constraints, or to change their filtering mode, see SET Database Object Mode statement.

This statement is valid only in a database with transaction logging, and its effect is limited to the transaction in which it is executed.

Use the IMMEDIATE keyword to set the transaction mode of constraints to statement-level checking. IMMEDIATE is the default transaction mode of constraints when they are created.

Use the DEFERRED keyword to set the transaction mode to transaction-level checking. You cannot change the transaction mode of a constraint to DEFERRED unless the constraint is currently enabled.