19 | 03 Dec 2015 @ 01:36 PST | Database | Reply | Using variable in Teradata SIGNAL | Actually 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.
|
18 | 03 Dec 2015 @ 01:09 PST | Database | Reply | Using variable in Teradata SIGNAL | hey,
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... |
17 | 27 Nov 2015 @ 05:29 PST | Database | Reply | 3707 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...
... |
16 | 04 Nov 2015 @ 04:29 PST | Database | Reply | Can REGEXP_REPLACE be used to replace multiple strings with multiple replace strings | You 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... |
15 | 14 Aug 2015 @ 08:55 PDT | Tools | Reply | Merging of Bteq and shell scripts | ULICKERT : 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
|
14 | 30 Apr 2015 @ 01:57 PDT | Database | Reply | reject records needs to be collected in a table | It'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&... |
13 | 24 Mar 2015 @ 05:52 PDT | Database | Reply | AGE in MONTHS & YEARS | Hi,
search for interval date type, you can use the year(4) to month interval.
sel CURRENT_DATE - birth_date YEAR(4) TO MONTH
...
|
12 | 23 Mar 2015 @ 07:38 PDT | Database | Reply | Stored Procedure taking more time than usual | hello,
Could be lock issues. Do you query tables or views?
|
11 | 19 Mar 2015 @ 10:03 PDT | Database | Reply | How SYSDATE will work if load is going more than one day | From 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.
|
10 | 06 Mar 2015 @ 01:58 PST | Database | Reply | How to get the statement used to updated/populate a table | Check on dbc.Dbqlogtbl the queries that occured on your table. ( column querytext like '%Tablename%' )
|
9 | 04 Mar 2015 @ 01:00 PST | Database | Reply | Teradata 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.
|
8 | 26 Feb 2015 @ 08:35 PST | Database | Reply | overflow occured computing an expression involving | filter for amt_allowed <> 0 of course ;)
|
7 | 26 Feb 2015 @ 03:19 PST | Database | Reply | overflow occured computing an expression involving | hi ,
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... |
6 | 09 Feb 2015 @ 04:53 PST | Database | Reply | Long decimal Value is getting round-off | hi,
check this parameter :
http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page/Utilities/B035_1102_112A/DBScontrol.31.0939.html
|
5 | 05 Feb 2015 @ 02:22 PST | Database | Reply | 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.
|
4 | 16 Oct 2014 @ 08:32 PDT | Database | Reply | Aggregate Join Index on Complex SQL statements | no primary index?
|
3 | 16 Oct 2014 @ 07:13 PDT | Database | Reply | TD 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 ... |
2 | 16 Oct 2014 @ 02:14 PDT | Database | Topic | Table partitioned on timestamp col | Posted 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 ... |
1 | 19 Mar 2014 @ 07:11 PDT | Tools | Reply | Teradata Parallel Transporter - Session Character Set | Hi 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... |