#DateForumTypeThreadPost
1903 Dec 2015 @ 01:36 PSTDatabaseReplyUsing variable in Teradata SIGNALActually i don't know (although I don't think it's possible) . I was just giving an option for generating custom and reusable error messages.
1803 Dec 2015 @ 01:09 PSTDatabaseReplyUsing variable in Teradata SIGNALhey, you should always declare something like this on a sp to handle generic sql errors and warning:   DECLARE EXIT /* OR CONTINUE?*/ HANDLER FOR SQLEXCEPTION BEGIN SET v_SQL_ERR_CD...
1727 Nov 2015 @ 05:29 PSTDatabaseReply3707 error when using recursive 'with' in stored proc in an attempt to concatenate a field.If the recursive query is the output you need, you should declare it inside the cursor like this ?   DECLARE CUR1 CURSOR WITH RETURN ONLY TO CLIENT FOR WITH RECURSIVE... ...
1604 Nov 2015 @ 04:29 PSTDatabaseReplyCan REGEXP_REPLACE be used to replace multiple strings with multiple replace stringsYou can if it always follows a "pattern". It means that with the pattern provided you can divide the the source string with multiple marked subexpression.   Then you can replace th...
1514 Aug 2015 @ 08:55 PDTToolsReplyMerging of Bteq and shell scriptsULICKERT : great help on this, was kinda blocked and didnt think of creating a variable for .logon command. (that you forgot to call under your bteq  command )   thank you
1430 Apr 2015 @ 01:57 PDTDatabaseReplyreject records needs to be collected in a tableIt's pretty hard to handle bad records caused by length of type error on a table since you hardly determine the datatype you should give to your columns on the error table.   Instead, I&...
1324 Mar 2015 @ 05:52 PDTDatabaseReplyAGE in MONTHS & YEARSHi, search for interval date type, you can use the year(4) to month interval. sel CURRENT_DATE - birth_date  YEAR(4)  TO MONTH ...  
1223 Mar 2015 @ 07:38 PDTDatabaseReplyStored Procedure taking more time than usualhello, Could be lock issues. Do you query tables or views?
1119 Mar 2015 @ 10:03 PDTDatabaseReplyHow SYSDATE will work if load is going more than one dayFrom what I experienced , if it's made by a single sql statement, you get one date at the execution of query. And on Teradata, it's current_date, not sysdate.
1006 Mar 2015 @ 01:58 PSTDatabaseReplyHow to get the statement used to updated/populate a tableCheck on dbc.Dbqlogtbl the queries that occured on your table. ( column  querytext like '%Tablename%' )
904 Mar 2015 @ 01:00 PSTDatabaseReplyTeradata String Manipulation, Extract String from a text field.SEL REGEXP_SUBSTR('NBSIC0~NVCA~K01','([A-Za-z0-9])+',1,3,'i');   if components only contain Alphanumeric characters. take the 3rd component of this kind.
826 Feb 2015 @ 08:35 PSTDatabaseReplyoverflow occured computing an expression involvingfilter for amt_allowed <> 0 of course ;)
726 Feb 2015 @ 03:19 PSTDatabaseReplyoverflow occured computing an expression involvinghi , The statement you provided should not work because it has some parenthesis issues;;but considering you get a numeric overflow error, you probably got it right.. I guess you have a percentage...
609 Feb 2015 @ 04:53 PSTDatabaseReplyLong decimal Value is getting round-offhi, check this parameter : http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page/Utilities/B035_1102_112A/DBScontrol.31.0939.html
505 Feb 2015 @ 02:22 PSTDatabaseReply expected something between the word 'xx' and ','.Unable to get..You select xx and bb from a12 but there's no column named this way on your a12 subquery.   btw your two columns are named zz on a12 subquery, shouldn't work too.
416 Oct 2014 @ 08:32 PDTDatabaseReplyAggregate Join Index on Complex SQL statementsno primary index?
316 Oct 2014 @ 07:13 PDTDatabaseReplyTD 14 UDFS/ORACLE EQIVALeNT FUNCTIONS http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=all&txtpid=1145&srtord=Asc&todt=&txtrelno=&txtttlkywrd=&frmdt=&rdsort=Title   Choose you release ...
216 Oct 2014 @ 02:14 PDTDatabaseTopicTable partitioned on timestamp colPosted this on latest Paulsinclair blog post (2012) but I guess I'll it a try here : Hi, I have a question about partition elimination in 14.00(.06.09) with a table partitioned on a timestamp ...
119 Mar 2014 @ 07:11 PDTToolsReplyTeradata Parallel Transporter - Session Character SetHi Santanu84, 2 questions: Can you provide the character set used on your oracle source which seems to both manage those extended ascii chars and chinese characters ? On the informatica side, th...