SQL Terminator Character
database preference
Description
Specifies the SQL statement terminator character used by the
Database painter’s Interactive SQL (ISQL) view.
The default terminator character for the ISQL view is a semicolon
(;). If a semicolon conflicts with the terminator character used by your
DBMS syntax, you can change the painter’s terminator character by
specifying a different character in the SQL Terminator Character box in
the Database Preferences dialog box. A good choice for a terminator
character is the backquote () character.
Changing the terminator character is recommended when you are
using the ISQL view to create or execute stored procedures, triggers,
and SQL scripts.
Applies to
All database interfaces
In an application
You cannot set the SQL Terminator Character database preference in
code.
In the development
environment
In the Database Preferences dialog box in the Database painter,
type the terminator character you want to use in the SQL Terminator
Character box. For instructions, see the section called “Setting Additional Connection Parameters” in Connecting to Your Database.
Default value
The default SQL Terminator Character value in the Database
Preferences dialog box is a semicolon (;).
Usage
The following are typical situations that might require you to
change the default SQL Terminator Character value:
-
Creating stored procedures and triggers
If you are creating stored procedures and triggers in the ISQL
view, change the painter's terminator character to one that you do
not expect to use in the stored procedure or trigger syntax for your
DBMS, such as the backquote () character.After you finish using the stored procedure, you can change
the terminator character back to a semicolon (;). If you prefer, you
can continue to use the new terminator character as long as it does
not conflict with any stored procedure or trigger syntax you plan to
use. -
Executing SQL scripts
If you plan to execute any SQL scripts in the ISQL view, make
sure the terminator character used in the script agrees with the
terminator character currently set in the view.
Examples
To change the SQL statement terminator character in the ISQL view
to a backquote (`), type a backquote in the SQL Terminator Character box
in the Database Preferences dialog box.