Error altering table structure via Alter Table screen: "The extended alter feature requires a Toa (4305307)

Using the Alter Table option of Object Explorer for a DB2 table, user changes a column name. The following error is displayed when selecting the Show Script button:

"The extended alter feature requires a Toad DB2/DBA License.
Please contact your Quest sales representative for details. "

Any DB2 object that requires an advanced table alter (usually requiring a drop and recreate such as modifying table columns) requires using Toad for DB2 product with a DBA license key. Toad for Data Analysts only allows what can be done by the default DB2 Alter statement which is limited to changes such as editing the comment field.

Perform complex table alterations such as column name changes by running DB2 commands in the Editor window of Toad.