#DateForumTypeThreadPost
716 Sep 2014 @ 02:36 PDTDatabaseReplyprocess AL3 XML(insurance standard XML) directly in teradataguys , atleast please let me know whether its possible or not .
616 Sep 2014 @ 02:35 PDTDatabaseTopicprocess AL3 XML(insurance standard XML) directly in teradataUsing 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...
516 Sep 2014 @ 02:34 PDTExtensibilityTopicprocess AL3 XML (insurance standard xml) in tdUsing 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...
409 Sep 2014 @ 12:50 PDTExtensibilityTopicurgent : xml conversionhave 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...
308 Sep 2014 @ 11:52 PDTExtensibilityTopicurgent : teradata xml service installationHi, 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/...
217 Sep 2013 @ 04:28 PDTDatabaseReplyNeed Analytical window query helpSEL 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 <>...
130 Apr 2012 @ 01:48 PDTDatabaseReplyChange 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...