XML IMPORT IN CLOB COLUMN USING sql assistant

Tools & Utilities

XML IMPORT IN CLOB COLUMN USING sql assistant

Hi ,

Sorry if I am posting over wrong thread. 

I am  new to teradata. I am trying to Import XML file in volatile table using SQL ASSISTANT IMPORT UTILITY .

The error I am getting is 'Large Objects and Binary and data values are not allowed in Direct Substitution'

replace procedure  XMLDATA()

BEGIN

 call DBC.SysExecSQL('CREATE MULTISET VOLATILE TABLE TBL_XML( custid integer,dummyxml CLOB); ');

END;

insert into TBL_XML values (?,?C) 

In my control file data is 

1,1,Test.xml

Please let me understand what am I doing incorrect .

Thanks,

Tags (1)