Can I covert XML data type to varchar
Posted on 2011-09-05
Can I convert XML data type from table to varchar, by recreating table.
I tried with following commands,
EXPORT TO ABC.ixf' OF ixf select * from ABC
drop table ABC;
Create table ABC with Varchar column.
LOAD CLIENT FROM ABC.ixf' of ixf insert into ABC;
But While loading I m getting error as
SQL3088N The source column specified to be loaded into database column "1" is not compatible with the database column, but the database column is not nullable.
Please advise me about Is it possible to convert XML to varchar.