#DateForumTypeThreadPost
1012 Dec 2014 @ 12:53 PSTDatabaseTopicMigration of Oracle UDF to TeradataHi, I am trying to migrate an Oracle view to Teradata which uses oracle user defined function in select clause and function contains the logic which cannot be migrated to TD SQL UDF. Has an...
916 Sep 2014 @ 11:50 PDTDatabaseReplyUse While loop in Stored Procedure in TeradataUse ACTIVITY_COUNT variable. set v_RowsAffected=ACTIVITY_COUNT; Vinay
816 Sep 2014 @ 10:57 PDTDatabaseReplyend of month datesselect t1.col1 as effective_dt,last_day(t2.col1) as information_dt from test t1,test t2 where t2.col1>=t1.col1 order by t2.col1,t1.col1 Table test contains following data 26-01-2014 26-02-2...
712 Feb 2014 @ 02:57 PSTDatabaseReplyTeradata Spool issue in Recursive issue--This query would work for maximum 3 values present in Resiliation e.g. 1,2,3 --if it contains more than that then we need to modify the query to accomodate it --I have seperated column values...
612 Nov 2013 @ 01:30 PSTGeneralReplyHow to write FIRST_VALUE() and LAST_VALUE() window function in Teradata? Hi, I have a query as follows, SELECT DISTINCT CD_MES, CD_CONTRATO,                      ...
503 Oct 2012 @ 05:00 PDTToolsReplyTPT : tlogview Parameters and optionsI am trying load table with TPT 14( 14.00.00.04). I am encountering following error, W_0_op_loadPREM_DIM: TPT19417 pmRead failed. Buffer overflow (17) W_0_op_loadPREM_DIM: TPT19305 Fatal error ...
429 Jul 2012 @ 09:16 PDTToolsReplyTPT : tlogview Parameters and options Sorry for the mistake, I meant exactly what you said:) Thanks.
327 Jul 2012 @ 03:26 PDTToolsReplyTPT : tlogview Parameters and options Hi, I have a doubt using tbuild -j jobid -w option, My logfile is something like W_1_op_loadjap_test: entering Application Phase W_1_op_loadjap_test: Statistics for Target Table:&n...
223 Apr 2012 @ 04:21 PDTTrainingReplyhow to delete duplicate records How to delete duplicate Records from TD table, here is multistep approach(more of a workaround)   create multiset table delete_duplicates( col1 integer, col2 integer, ) ...
114 Dec 2011 @ 12:04 PSTDatabaseTopicQuery Regarding XMLAGG Hi, I am having difficulty in using XMLAGG function from xmlservices, I am writing query as below, SELECT SYSXML.XMLAGG(COL1) FROM ( SELECT        &...