Function

The SET statement is used to set the following client-specific parameters.

• Switch AUTOCOMMIT on/off

• Set a default catalog for an Adabas SQL Gateway Embedded SQL session

• Set a default schema for an Adabas SQL Gateway 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 to be set is provided as identifer and the value as constant.

The parameters which may be set are described in the table below.

 

Parameter	Usage	Further Information
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.