Simple SELECT query but no results

General
Highlighted
Visitor

Simple SELECT query but no results

Hi All,

 

I am running teradata version 15, and i am trying to query a table with 3 columns, but i keep getting errors after errors.

 

SyntaxEditor Code Snippet

 SELECT a.StoreName, a.Books.xmlextract ('/note/heading[1]',NULL)  FROM    WORK_DB.SampleBooks a

I see an error

 

9881 function XMLCLIENTFMTTTXT called with invalid number of params.

 

I am really surprised, as i took this query from teradata guide, and many of the java programs i wrote also give me the same error.


Please advise experts