Return
-
Title
Get a message saying Toad DB2/DBA license is needed when altering a table -
Description
The following message is returned when trying to alter a table.
-- The extended alter feature requires a Toad DB2/DBA License.-- Please contact your Quest sales representative for details -
Cause
A DB Admin module needs to be included on your license in order to do extended (aka advanced) alters. -
Resolution
An extended alter is one that cannot be accomplished via a native ALTER statement.
Users can view the native alter statement syntax on the IBM DB2 web pages.
For extended alters, Toad will generate the necessary DROP and CREATE statements for all necessary objects, retaining object relationships and data.
If you would like to look into obtaining the DB Admin module, contact your sales representative. -
Additional Information
Information on what features are available with a DB Admin Module license key is available in the Toad DB2 functional matrix at: http://software.quest.com/documents/toad-for-ibm-db2-functional-matrix-datasheet-68552.pdf