All Forums General
cyrus 1 post Joined 03/13
14 Jul 2015
XML error

Hello Folks
I am trying to load XML data in a XML data type column .But getting error while loading data into it.
 
CREATE SET TABLE XMIL_CHECK_S ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      REC_ID VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
      XMLDOC XML,
      WAREHOUSE_TS TIMESTAMP(0))
PRIMARY INDEX ( ID );  
 
 
Error code:-Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1186] [SQLState HY000] Parameter 2 length is 280069 bytes, which is greater than the maximum 64000 bytes
Can you please help to understand this issue.

Tags:
You must sign in to leave a comment.