Archives of the TeradataForum

Message Posted: Tue, 23 Jun 2015 @ 14:11:55 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

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;