0 - 21 of 21 tags for xml

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

The XML Data type, introduced in Teradata 14.10, provides the following new capabilities:

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.

Teradata XML Services provide assistance in database transformation of XML structures to and from relational structures. This is primarily an enterprise fit feature. XML in this context is regarded as a data format that is used to describe incoming or outgoing warehouse data. A key concept for this feature is that we are not transforming to store XML but rather to maintain a relational data model or to integrate relational data into an enterprise XML message structure! The relational data model is bested suited for enterprise analytics. XML structures are best suited for enterprise integration.

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.

Does XML open up the implementation of a truly ad hoc EDW? I’m not talking about an EDW that supports ad hoc queries. I’m suggesting a fully ad hoc EDW: data model, data structures, ETL/ELT and BI tool access to end-users with no design or predefinition.

Teradata XML Services (TXS) extends the database’s XML capabilities focusing on transforming data between its XML and relational representations. Two key components of XML Services are:

Teradata XML Services provide assistance in database transformation of XML structures to and from relational structures. This is primarily an enterprise fit feature. XML in this context is regarded as a data format that is used to describe incoming or outgoing warehouse data. A key concept for this feature is that we are not transforming to store XML but rather to maintain a relational data model or to integrate relational data into an enterprise XML message structure! The relational data model is bested suited for enterprise analytics. XML structures are best suited for enterprise integration.