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.
All database interfaces
You cannot set the SQL Terminator Character database preference in code.
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.
The default SQL Terminator Character value in the Database Preferences dialog box is a semicolon (;).
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.
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.