Dear RMG ,
IN tera Data we have to insert abc.xml in two tables one table contains clob Data Type while other contains as XML Data Type.
For Clob Data Type Table:-
We are able to insert as xml as string not as abc.xml doc .I created one directory where we are storing abc.xml and reading as stream and passing it to Jdbc service where JDBC input type selected as string.Please help heer so that in table it will be like abc.xml|123(Id)
For XML Data Type Table:-
we want to use below query but its giving syntax error
.IMPORT vartext file =‘xml.txt’
.REPEAT *
USING (a XML AS DEFERRED BY NAME, b VARCHAR(50))
INSERT INTO GPM_XMLDOCS VALUES(:b, :a);
ERROR:-----
(42000/3706) [Teradata Database] [TeraJDBC 12.00.00.110] [Error 3706] [SQLState 42000] Syntax error: expected something between the beginning of the request and ‘.’."
[Teradata Database] [TeraJDBC 12.00.00.110] [Error 3706] [SQLState 42000] Syntax error: expected something between the beginning of the request and ‘.’.
Pleaselet me know if i miss any details to debug issue.