Wrong syntax for partitioned tables after extended alter (4309984)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Wrong syntax for partitioned tables after extended alter
Description

When changing a column of a Table, which needs drop Recreate, the wrong DDL is generated and the Rows of the Second Partition can not be reloaded. The error received when reloading is
Cause

Maxvalue of the Partition is a Keyword and may not be in Quotes in the script generated by Toad for DB2
Resolution

WORKAROUND
None
SOLUTION

Issue fixed in version 6.3. The latest version of Toad for DB2 can be downloaded here
Defect ID

TDB-3132

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title