|
|
Archives of the TeradataForum
Message Posted: Tue, 23 Jun 2015 @ 14:11:55 GMT
Subj: | | XPATH_SHREDV XML Function |
|
From: | | Bakthavachalam, Roopalini |
Hello Forum
I have installed XML services for Teradata 14.00, however I am getting a function does not exists error for SYSXML.XPATH_SHREDV function. Has
anyone used this function? If yes, could you share the right way to use this function? May be this is an overloaded function and that?s why the
error.
Below SQL gives me error 5589 function does not exist.
SELECT * FROM TABLE (SYSXML.XPATH_SHREDV ( '1', '
John Doe
101 Maple Street
San Diego
CA
11111
Jane Doe
101 Maple Street
San Diego
CA
11111
'
,''
,'/CustomerList/Customer'
,'./@id {1}, ./CustomerName/text() {2}, ./Address1/text() {3}, ./City/text() {4}'
)) TMP;
Thanks
Roopalini
| |