SQL Operation

RdbmsAction32x32

Description

This action has several functions:

Execute Standalone DDL or DML SQL statements. The SQL code is provided in the action’s code.
Execute SELECT or INSERT/UPDATE/DELETE statements linked through a bind link. The SQL code is provided in the action’s code.
Wait for a query to return a number of records.

Parameters

Name Mandatory Default Description

Name	Mandatory	Default	Description
SQL Action Type	Yes	DDL_DML	Type of SQL Command. This command may be a standalone SQL command (DDL_DML), a SELECT command used as the source of a bind link, or an INSERT, UPDATE, DELETE command used as the target of a bind link.
SQL Connection	No		SQL connection used for the command. This connection is automatically set on the action if a metadata link is added on this action.
SQL Transaction Type	No	AUTOCOMMIT	Type of transaction. AUTOCOMMIT: an autocommit connection is picked up from the connection pool, COMMIT: a commit is issued after the SQL command, NOCOMMIT: no commit is issued after the SQL command, AUTONOMOUS: a separate autocommit connection is created for this command.
SQL Transaction Name	No	T1	SQL transaction name used for the command. Several actions can participate in the same transaction if the SQL transaction name is the same
SQL Transaction Commit Nb	No	–1	Number of lines after which a commit must be issued. This number if valid only for INSERT, UPDATE and DELETE commands. –1 stands for no commit.
SQL Transaction Isolation	No	default database value	Transaction isolation: TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE.
SQL Action Type Stat	No		Type of statistic. This field allows creation of a named statistic with the number of lines managed by the command. The Stat type name is prefixed with `SQL_STAT`. For example, if INSERT' is written in this parameter, a `SQL_STAT_INSERT variable will be created
SQL Fetch Size	No	1000	Fetch size (number of lines) for SELECT commands. By default, the Runtime engine configuration value is used.
SQL Batch Size	No	1000	Batch size (number of lines) for INSERT, UPDATE and DELETE commands. By default, the Runtime engine configuration value is used.
SQL Wait Data	No	false	Moves the command into data wait mode. The action waits until the query specified either in the action code or in SQL Wait Count Select returns at least SQL Wait Nb Rows or until the SQL Wait Timeout is reached.
SQL Wait Poll interval	No	1000	Polling interval when SQL Wait Data is set to true.
SQL Wait Timeout	No		Waiting timeout when SQL Wait Data is set to true.
SQL Wait Nb Rows	No		Number of rows to wait for when SQL Wait Data is set to true.
SQL Wait Count Select	No		Query returning a number of rows to wait for, when SQL Wait Data is set to true.
SQL Multi Queries	No	false	Activates the Multi-Query mode. In this mode, several statements can be set in the code, separated by the SQL Multi Queries Separator.
SQL Multi Queries Separator	No	;	Character separating the queries in the code when Multi-Query mode is activated.
SQL Multi Queries Exclusion Patterns	No		Regular expression defining the lines to exclude from the list of statements. These lines are typically SQL comments.
SQL Disable Nb Rows Statistic	No	false	Disables the computation of statistics when in multi-query mode: either for all queries (true), for none (false), or a specific query list (list with the query numbers separated by commas or semi-colons)

SQL Action Type

Yes

DDL_DML

Type of SQL Command. This command may be a standalone SQL command (DDL_DML), a SELECT command used as the source of a bind link, or an INSERT, UPDATE, DELETE command used as the target of a bind link.

SQL Connection

SQL connection used for the command. This connection is automatically set on the action if a metadata link is added on this action.

SQL Transaction Type

AUTOCOMMIT

Type of transaction. AUTOCOMMIT: an autocommit connection is picked up from the connection pool, COMMIT: a commit is issued after the SQL command, NOCOMMIT: no commit is issued after the SQL command, AUTONOMOUS: a separate autocommit connection is created for this command.

SQL Transaction Name

SQL transaction name used for the command. Several actions can participate in the same transaction if the SQL transaction name is the same

SQL Transaction Commit Nb

–1

Number of lines after which a commit must be issued. This number if valid only for INSERT, UPDATE and DELETE commands. –1 stands for no commit.

SQL Transaction Isolation

default database value

Transaction isolation: TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE.

SQL Action Type Stat

Type of statistic. This field allows creation of a named statistic with the number of lines managed by the command. The Stat type name is prefixed with SQL_STAT. For example, if INSERT' is written in this parameter, a `SQL_STAT_INSERT variable will be created

SQL Fetch Size

1000

Fetch size (number of lines) for SELECT commands. By default, the Runtime engine configuration value is used.

SQL Batch Size

1000

Batch size (number of lines) for INSERT, UPDATE and DELETE commands. By default, the Runtime engine configuration value is used.

SQL Wait Data

false

Moves the command into data wait mode. The action waits until the query specified either in the action code or in SQL Wait Count Select returns at least SQL Wait Nb Rows or until the SQL Wait Timeout is reached.

SQL Wait Poll interval

1000

Polling interval when SQL Wait Data is set to true.

SQL Wait Timeout

Waiting timeout when SQL Wait Data is set to true.

SQL Wait Nb Rows

Number of rows to wait for when SQL Wait Data is set to true.

SQL Wait Count Select

Query returning a number of rows to wait for, when SQL Wait Data is set to true.

SQL Multi Queries

false

Activates the Multi-Query mode. In this mode, several statements can be set in the code, separated by the SQL Multi Queries Separator.

SQL Multi Queries Separator

;

Character separating the queries in the code when Multi-Query mode is activated.

SQL Multi Queries Exclusion Patterns

Regular expression defining the lines to exclude from the list of statements. These lines are typically SQL comments.

SQL Disable Nb Rows Statistic

false

Disables the computation of statistics when in multi-query mode: either for all queries (true), for none (false), or a specific query list (list with the query numbers separated by commas or semi-colons)