Return
-
Title
Toad truncates or deletes characters from the DDL create statement. -
Description
Toad chops off or removes characters from the DDL create script.
Below is an example, it truncates "SET" to "T" in the following DDL. It happens in both "Trigger" script tab and generating DDL for the table.
CREATE OR REPLACE TRIGGER DHSDB2.AUTOSEQ1_GB02ABI00NO CASCADE BEFORE INSERTON DHSDB2.TBGB02AREFERENCINGNEW AS NEWROWFOR EACH ROWWHEN ((NewRow.SQNM = 0)OR (NewRow.SQNM is null))T NewRow.SQNM = (SELECT COALESCE(MAX(SQNM),0)+1FROM DHSDB2.TBGB02AWHERE GATA_BDGT_ID=NewRow.GATA_BDGT_ID); -
Resolution
WORKAROUND:NoneSTATUS:Issue fixed in version 7.0. The latest version of Toad for DB2 can be downloaded at: https://support.quest.com/download-product-select -
Defect ID
TDB-3630