Return
-
Title
"SQL0461N A value with data type "SYSIBM.XML" cannot be CAST to type "SYSIBM.VARCHAR". SQLSTATE=4 -
Description
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?
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.