When trying tochange a table column from type XML to VARCHAR(20000), Toadgenerates the insert below:
Insert (into temptable) with CAST(RESULT AS VARCHAR(20000).
However DB2 cannot cast XML into VARCHAR, so the following errorappears:
SQL0461N A value with data type SYSIBM.XML cannot be CAST to type SYSIBM.VARCHAR. SQLSTATE=42846.
Why does Toad generate the insert instead of displaying a message saying that this is not possible?
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad For DB2
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy