SQL Terminator Character – PB Docs 126

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 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.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x