SET

SET — change a runtime parameter

Syntax

SET SYSTEM PROPERTY name=value
SET AUTOCOMMIT { ON | OFF }
SET AUTOCOMMIT_SP_MODE { ON | OFF }
SET DELIMITER value
SET DIALECT value
SET ISOLATION LEVEL transaction_isolation_level
SET OUTPUT { VERTICAL | HORIZONTAL }
SET PAGER command
SET QUERY TIMEOUT sec
SET ROLE rolename [ ACTIVE | INACTIVE ]
SET ROLLBACK MODE { PROCEDURE | TRANSACTION | OFF }
SET SEMICOLON { ON | OFF }
SET STATEMENT ANALYZE { ON | OFF }
SET TIMING { ON | OFF | FULL }
SET [ trace_level ] TRACE { ON [ opt_trace_params ] | OFF }

Description

Invoke the SET command to change parameters that affect runtime behavior.

Parameters

A parameter that you specify with the SET statement affects the runtime behavior of a database or the current connection to a database. Some parameters apply only when you are using the nuosql command line utility.

Setting Parameters for the Database

The following parameter lets you specify system properties that apply to all connections to the database:

Setting Parameters for the Connection

The following parameters apply to the current connection to a database:

Setting Connection or Database Level Tracing

Setting Parameters when using nuosql

When you are using the nuosql command line utility then you can set the following parameters:

Examples