SET
Function
The SET statement is used to set the following client-specific parameters:
Switch AUTOCOMMIT on/off
Set a default catalog for a CONNX Embedded SQL session
Set a default schema for a CONNX Embedded SQL session
Invocation
Embedded Mode P Dynamic Mode P Interactive Mode P
Syntax
Description
The SET statement can be used to set a client-specific parameter. The parameter is provided as an identifer and the value as a constant.
The available parameters are described in the table below.

Autocommit | Set AUTOCOMMIT on/off. | See SET AUTOCOMMIT.
Catalog | Set a default catalog. | See SET CATALOG in the SQL Gateway User Guide.
Schema | Set a default schema. | See SET SCHEMA in the SQL Gateway User Guide.