I am currently using Toad for DB2 LUW 4.7.0.556. I am wondering if anyone knows of a way to avoid having the application place "'s (quotes) around object names when you select the “SCRIPT” tab on an object? Further, is there a way to not have the “SET SCHEMA” clause automatically inserted? I do a lot of DDL work and Toad makes it easy but having the quotes and schema clause in there makes for extra steps. Thanks in advance.
When Toad reads data from the DB2 catlog, Toad will enclose object names\column names with quotes in order to support object names\column names with mixed case and special characters.
There is no option to suppress the quotes at this time.
Also, there is no option to suppress the SET SCHEMA clause.
Ok. Thanks for the feedback anyway.