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.
Controls
-
All database interfaces
Context
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 "Setting Additional Connection Parameters" in Connecting
to Your Database.
Default
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 triggersIf 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.