SQL_SET_STATEMENT_TERMINATOR

The SQL_SET_STATEMENT_TERMINATOR script element determines the character which terminates SQL statements. Specifications made with SQL_SET_STATEMENT_TERMINATOR apply for all subsequent SQL statements until the job ends or until the SQL_SET_STATEMENT_TERMINATOR statement is used again.

Important! This script element is automatically inserted in the script when the separator is used within an SQL statement. No manual intervention is required.

Syntax

TERM=...

Parameters

SQL_SET_STATEMENT_TERMINATOR
Determines the character which terminates SQL statements
TERM=
Separator
Default value: ;
The following order is kept when a separator is selected:
;, @, $, /, ~, *, +, ?, =, ., -, §, ë

Examples

The following is an example for Oracle where SQL_SET_STATEMENT_TERMINATOR is added to the script because a semicolon (;) is used within an SQL statement.

SQL_SET_STATEMENT_TERMINATOR TERM='@';

DECLARE
v_unit_short varchar2(10);
v_description varchar2(40);
BEGIN
v_unit_short := 'kg';
v_description := 'Kilogram';
insert into unit (unit_short, description)
values (v_unit_short, v_description);
EXCEPTION when DUP_VAL_ON_INDEX then
/* Data record already exists => Reset description */
update unit set
description = v_description
where unit_short = v_unit_short;
END;