#SET TERMINATOR Command Not Supported in Toad for Db2 (4332808)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

#SET TERMINATOR Command Not Supported in Toad for Db2
Description

When executing scripts in Toad for Db2 that include the following command:

#SET TERMINATOR

Toad does not recognize the command and may return an error or fail to execute the script as expected. This commonly affects scripts used to create DB2 functions, stored procedures, or triggers.
Cause

The #SET TERMINATOR command is a SPUFI-specific command used to override the SQL statement terminator defined in SPUFI settings. Toad for Db2 does not support SPUFI commands, and therefore this syntax is not recognized by the Toad execution engine.
Resolution

There is currently no workaround available to enable support for the #SET TERMINATOR command in Toad for Db2.

Users should modify scripts to remove or replace SPUFI-specific commands when executing them in Toad.
Defect ID

TDB-4034
Additional Information

The default SQL terminator in DB2 is the semicolon (;), and SPUFI allows overriding this behavior using the #SET TERMINATOR directive. However, Toad for Db2 relies on its own parsing and execution logic and does not interpret SPUFI directives, meaning scripts written for SPUFI may require adjustment before being executed in Toad.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title