![]() |
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):
07 Sep 2016
| 1 comment
,
|
![]() |
Hi,
14 Jun 2016
| 2 comments
,
|
![]() |
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.
16 May 2016
| 3 comments
,
|
![]() |
Hi,
16 Nov 2015
| 1 comment
,
|
![]() |
- version Teradata 14.10
02 Nov 2015
| 1 comment
,
|
![]() |
The XML Data type, introduced in Teradata 14.10, provides the following new capabilities:
15 Jul 2015
,
|
![]() |
Hello Folks
14 Jul 2015
,
|
![]() |
Questions about teradata XML. (Teradata 14.10)
13 Apr 2015
,
|
![]() |
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.
15 Oct 2014
| 5 comments
,
|
![]() |
Hi Experts,
07 Jan 2014
| 3 comments
,
|
![]() |
Does anyone know if there is a way of calling a web service from teradata?
17 Oct 2013
| 7 comments
,
|
![]() |
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:
08 Jul 2013
| 1 comment
,
|
![]() |
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>
11 Jul 2012
,
|
![]() |
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.
01 Sep 2011
,
|
![]() |
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.
29 Sep 2010
| 1 comment
,
|
![]() |
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.
17 Sep 2010
| 3 comments
,
|
![]() |
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
30 Jul 2010
| 1 comment
,
|
![]() |
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.
10 Dec 2009
| 7 comments
,
|
![]() |
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.
03 Aug 2009
| 2 comments
,
|
![]() |
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:
14 Apr 2009
,
|
![]() |
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.
26 Feb 2009
,
|