Needed to make the following changes to a table:
* Remove 2 columns,
* Change datatype (smallint --> decimal(5.2) on 5 columns,
* Add 8 columns.
The script built to accomplish this and retain the data will not reload the existing data (using the load utility)
Many warning messages: SQL3168W The PC/IXF column specified to be loaded into database column "<name>" is not compatible with the database column. Nulls will be inserted.
STATUS
Waiting for a fix with CR 78690 on a future release of Toad for DB2.
WORKAROUND:
None
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center