CONNX Data Integration Suite 14.8.0 | CONNX Embedded SQL for Adabas | Standard SQL Statements | SET
 
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
The syntax is SET identifier constant.
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.
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.