| # | Date | Forum | Type | Thread | Post |
|---|
| 7 | 16 Sep 2014 @ 02:36 PDT | Database | Reply | process AL3 XML(insurance standard XML) directly in teradata | guys , atleast please let me know whether its possible or not .
|
| 6 | 16 Sep 2014 @ 02:35 PDT | Database | Topic | process AL3 XML(insurance standard XML) directly in teradata | Using XML service its possible to load xml file into tables and represent data in xml format. But is it possible to do the same for AL3 XML formatted data . If not possible then probable solution w... |
| 5 | 16 Sep 2014 @ 02:34 PDT | Extensibility | Topic | process AL3 XML (insurance standard xml) in td | Using XML service its possible to load xml file into tables and represent data in xml format. But is it possible to do the same for AL3 XML formatted data . If not possible then probable solution w... |
| 4 | 09 Sep 2014 @ 12:50 PDT | Extensibility | Topic | urgent : xml conversion | have create the below proc to invoke as_shred_batch ,
REPLACE PROCEDURE MY_SHREDBATCH_SP
(IN sourceDataQuery varchar(6000),IN annotatedSchemaID varchar(32),OUT resultCode varchar(128))
SPMAIN:B... |
| 3 | 08 Sep 2014 @ 11:52 PDT | Extensibility | Topic | urgent : teradata xml service installation | Hi,
I am having teradata 14 vmware express edition 4gb linux version and I am trying to install teradata xml service 14 into it . have done following till now,
home/tdatuser # mkdir xml
:/home/... |
| 2 | 17 Sep 2013 @ 04:28 PDT | Database | Reply | Need Analytical window query help | SEL ID , STATUS , DT , MAX(STATUS) OVER(PARTITION BY ID ORDER BY DT ROWS 1 PRECEDING) AS COL1 , MIN(STATUS) OVER(PARTITION BY ID ORDER BY DT ROWS 1 PRECEDING) AS COL2 , CASE WHEN COL2 <>... |
| 1 | 30 Apr 2012 @ 01:48 PDT | Database | Reply | Change all periods "." in a column to forward slash "/" |
Hi,
Can we replace the '.' with '/' by the following query,
ABC.D can be replaced by the column value,
SELECT (SELECT SUBSTR('ABC.D',1,((SELECT IND... |
|
|