Home Page for the TeradataForum
 

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;

Thanks

Roopalini



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016