I am working on an XML parsing requirement using XML Table.  I am running into a problem with data from elements with no namespaces or prefixes.  Extraction using XMLTable doesn't seem to work.  Extraction from elements with prefixes seem to work normally.  Say I have an XML below (not actual as I am working with sensitive data):

Hi,
I am very new to Teradata Aster Express. I want to load XML files into Teradata database but I am unable to figure out how to install XML tools on express.
Any guidance would be appreciated. 

I am trying to use XMLAGG to transpose the row-wise data to comma separated value in Teradata 15. Its working fine with English (LATIN character set) characters. But while I am using other characters (Unicode character set) I am getting 'string contains untranslatable character' error.
Please suggest how to resolve the issue.

Hi,
I need to load an xml file in Aster Database
I need to use functions like XMLParser OR XMLRelation.
But both the above functions need a table as input. So how do I get this xml file into a table
 
Thanks,
Jeetu
 

- version Teradata 14.10
- stored a 6Mb .xml file to a XML column (XML_col) on a row
- dbc control:  284.  MaxXML_MemoryLimit = 128 MB (4 - 128, Default 32)
- SELECT XML_col.EXISTSNODE('/tag', '')  results in subject error. 
- SELECT XML_col.ISDOCUMENT() returns 1
- SELECT XML_col.ISCONTENT() returns 1

Hello Folks
I am trying to load XML data in a XML data type column .But getting error while loading data into it.
 
CREATE SET TABLE XMIL_CHECK_S ,NO FALLBACK ,
     NO BEFORE JOURNAL,

Questions about teradata XML. (Teradata 14.10)
 
Is it possible to
define namespace prefix only once - in the parent element - and then reuse it in child elements?
This is example of valid XML, that I use for illustration.

Hi Experts,
Need  ur suggestions in Updating XML string  present in table by first adding 2  column tags in it. for e.g

Does anyone know if there is a way of calling a web service from teradata?  
I'm looking at replacing a process that currently uses oracle.  We have stored procedures created which build some XML and then call a web service.  This uses the oracle package UTL_HTTP.

Finally got the install to work with help from the documents on here.  When I try to generate a canonical schema using the SYSXML.GEN_QUERY_CANONICAL_SCHEMA procedure, i get the following error:
 *** Failure 7504 in UDF/XSP/UDM SYSXML.GEN_QUERY_CANONICAL_SCHEMA: SQLSTATE
  U0027: Failed to create a CLI connector.

How to execute teradata macro and stored procedure in XML?

Please let me know if the below statement are correct in terms of macro and SP execution inside XML

<Query> EXEC MACRO_NAME (Parm) </Query>

<Query> CALL PROCEDURE_NAME (parm) </query>

I am attempting to publish an XML document and I am getting the following error:

CALL Failed. 7504: in UDF/XSP/UDM SYSXML.PUBLISH_XML_LOB: SQLSTATE U0036: Fetch result set error, cli request error!errorcode: 3706, errorstring:Syntax error: expected something between the 'SELECT' keyword and the 'ROW' keyword.

I'm searching for a tool or utility that will take views and create a tree structure. My task is develop a comprehensive mapping of my company's inbound and outbound processes. Since a majority of our outbounds are sourced from views an automatic method of generating a tree-like strucutre in text or xml would be a huge help.

I found a post (http://forums.teradata.com/forum/database/query-to- find-out-the-table-na...) that mentions Teradata Utility Pack's Meta Data Services but doesn't explain which function to use or point to any documentation.

I'm searching for a tool or utility that will take views and create a tree structure. My task is develop a comprehensive mapping of my company's inbound and outbound processes. Since a majority of our outbounds are sourced from views an automatic method of generating a tree-like strucutre in text or xml would be a huge help.

Hi All,

Is there a way I can load output from a XML process into Teradata? This is new ground for me, so I have no clue how to even start looking for a solution.

Thanks!

Paul

Hi,

We have downloaded the XML services for teradata recently and started using it. But we got stuck at the first step of the shredding process.

When we are tying to execute the following procedure from TSA we are getting an error and we are not able to proceed further.