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?
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center