996 | 25 Sep 2014 @ 09:19 PDT | Database | Reply | Qualify in select statement | You can do something like this, see I change only for the trn_post_dt, you can change for the trns_dte .
select acct_id,sor_id,trans_dt, case when max(trn_amt) over(partition by trn_amt order by t... |
995 | 25 Sep 2014 @ 08:33 PDT | Database | Reply | Syntax error in an UPDATE statement | Spool space issue can be because of reasons like spool for a user is low, skewed data distribution .....
Did you test your explain? Are your stats fine....Which user your are using? Anything runn... |
994 | 25 Sep 2014 @ 09:45 PDT | Database | Reply | job sequence number | My suggestion.For which tool/technology or hadoop or ..... Maybe you can put under the right forum, someone who knows better about it can answer.
|
993 | 25 Sep 2014 @ 01:23 PDT | Third Party Software | Reply | MultiStream Netvault Backup Job | It is all about reading them :)
http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=BAR%20Solutions&txtrelno=&txtpid=&srtord=Asc&txtttlkywrd=&rdSort=Title
Dont as... |
992 | 24 Sep 2014 @ 11:57 PDT | Database | Reply | How to group these records? | From the explanation , it seems, that once you get difference of days, it looks ok, if you just put something like this
case when gp_days < 8 then 1 else 0 end
Am I missing something?
|
991 | 24 Sep 2014 @ 10:25 PDT | Database | Reply | Error: Syntax error: expected something between the word 'a' and '.' | You do not have a.col5.
Give an alias to all columns. It is a good way to identify.
Try this, putting a.col1 as PI. You can change later.
create table c as
( select a.col_1 as jj, a.col_2 as k... |
990 | 24 Sep 2014 @ 03:30 PDT | Database | Reply | Temporary Disable\enable Constraints (Foreign Key, Check Constriant, Unique Key) | Hope you verified each and every step you peform. You can use show table command to verify. Are you shure your penultimate alter works fine?
You can drop and resubmit your create request from comp... |
989 | 24 Sep 2014 @ 03:06 PDT | Database | Reply | Timestamp format | How about the first one?
One way I can see is concatenate date and extract hour and concatenate with ||':00:00.000000') ?
You don't like it? It is a bit dirty :)
|
988 | 24 Sep 2014 @ 01:33 PDT | Database | Reply | Timestamp format | One way I can see is concatenate date and extract hour and concatenate with ||':00:00.000000')
Another way is
SELECT CAST(current_date AS TIMESTAMP(0)) + CAST(EXTRACT(HOUR FROMcurren... |
987 | 24 Sep 2014 @ 12:09 PDT | Training | Reply | Teradata 14 certification basics | You can see this link and it has most of the details:
http://in.teradata.com/tcpprightnav.aspx?id=10471&LangType=16393&LangSelect=true
You can see the objectives of exam too. It can help ... |
986 | 23 Sep 2014 @ 11:37 PDT | Database | Reply | Temporary Disable\enable Constraints (Foreign Key, Check Constriant, Unique Key) | You mean to say the DDL remains the same before alter and after alter, when you do : show table testdb.tab ?
Do you need commit work for a ddl?
can you test it independently?
|
985 | 23 Sep 2014 @ 08:12 PDT | Database | Reply | Triggers on Views | You can see from the materials of 14& 15:
from 14 I see this:
The object referenced by table_name cannot be any of the following:
• global temporary table
• hash index
... |
984 | 23 Sep 2014 @ 07:53 PDT | Database | Reply | Temporary Disable\enable Constraints (Foreign Key, Check Constriant, Unique Key) | You can use alter statement with drop and alter.Make a backup of scripts. Hope you have a name for fk,check and unique key constraints. It is better to have names:
http://www.info.teradata.com/HTM... |
983 | 23 Sep 2014 @ 01:28 PDT | General | Reply | INSERT works but inside a PROCEDURE doesn't Any Idea? | My initial thought:
If ANSI mode, can it be because of no commit?
Can it be that you are running at the same time when you run the insert independently ?
|
982 | 22 Sep 2014 @ 11:58 PDT | Database | Reply | Access Right 'G' abbreviation | Hi Nick,
Which version of TD ? Sometime back someone asked the same question too. If they are not GC,GD,GM then we need to know that G.
|
981 | 22 Sep 2014 @ 08:30 PDT | Database | Reply | Teradata as object database | Very much!!!example: TPT is an object-oriented client application, many UDFs are written in C++, Java,Aster's SNAP framework is object-oriented ......and many more.....
|
980 | 22 Sep 2014 @ 08:03 PDT | Database | Reply | Selecting all rows that have a unique column | Can you show sample records, what you have and what you want? That will be easier. From my standpoint, it looks like group by is what you resort to using it, since you need all records. Why VT does... |
979 | 22 Sep 2014 @ 07:50 PDT | Database | Reply | Access Right 'G' abbreviation | I am not sure, it can be for Global and Persistent data(GLOP).
|
978 | 22 Sep 2014 @ 10:36 PDT | Database | Reply | Rows should be appended to a column in teradata | With recursive may take a lot of spool. You can think of udf for concatenation, or you can extend your list above :).
you have not told me the version , you are using.
|
977 | 22 Sep 2014 @ 09:00 PDT | Database | Reply | Rows should be appended to a column in teradata |
Which version of TD you are in? Can you try something like this?
select name1,max(case when rn=1 then desc1 else '' end)
||max(case when rn=2 then desc1 else '' end) from... |
976 | 22 Sep 2014 @ 07:30 PDT | Database | Reply | Rows should be appended to a column in teradata | select name1,regexp_replace(tdstats.udfconcat(trim(desc1)),'"','',1,0,'i') from your_table group by 1;
|
975 | 22 Sep 2014 @ 05:18 PDT | Database | Reply | Global temporary Table | Eve using the keyword ALL at the end?
use ON COMMIT PRESERVE ROWS at the end .
|
974 | 22 Sep 2014 @ 04:50 PDT | General | Reply | QUERY INVALID ERROR | Multi line comments ?
Conventionally comments are placed -- for single line
For multiple-line comments, precede the comment with a forward slash and asterisk (/*), and follow the comment wi... |
973 | 22 Sep 2014 @ 04:39 PDT | Database | Reply | Conditional Statements in Teradata | You can think of calling a stored proc from another one. In the called one you can put your if else condition. example
CREATE PROCEDURE Sp2(INOUT p1 INTEGER)
BEGIN
IF (.....) THEN
CALL Sp1(p... |
972 | 22 Sep 2014 @ 12:44 PDT | Database | Reply | UTF -8 or UTF-16? | http://forums.teradata.com/forum/tools/charn-char-set-unicodelatin-define-schema-in-14-xx-multiply-by-2-or-3
I follow Steve's suggestions always. I do less work in tpt. Previously I used wizar... |