#DateForumTypeThreadPost
99625 Sep 2014 @ 09:19 PDTDatabaseReplyQualify in select statementYou 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...
99525 Sep 2014 @ 08:33 PDTDatabaseReplySyntax error in an UPDATE statementSpool 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...
99425 Sep 2014 @ 09:45 PDTDatabaseReplyjob sequence numberMy suggestion.For which tool/technology or hadoop or ..... Maybe you can put under the right forum, someone who knows better about it can answer. 
99325 Sep 2014 @ 01:23 PDTThird Party SoftwareReplyMultiStream Netvault Backup JobIt 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...
99224 Sep 2014 @ 11:57 PDTDatabaseReplyHow 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?
99124 Sep 2014 @ 10:25 PDTDatabaseReplyError: 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...
99024 Sep 2014 @ 03:30 PDTDatabaseReplyTemporary 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...
98924 Sep 2014 @ 03:06 PDTDatabaseReplyTimestamp formatHow 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 :)
98824 Sep 2014 @ 01:33 PDTDatabaseReplyTimestamp formatOne 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...
98724 Sep 2014 @ 12:09 PDTTrainingReplyTeradata 14 certification basicsYou 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 ...
98623 Sep 2014 @ 11:37 PDTDatabaseReplyTemporary 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?
98523 Sep 2014 @ 08:12 PDTDatabaseReplyTriggers on ViewsYou 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 ...
98423 Sep 2014 @ 07:53 PDTDatabaseReplyTemporary 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...
98323 Sep 2014 @ 01:28 PDTGeneralReplyINSERT 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 ?  
98222 Sep 2014 @ 11:58 PDTDatabaseReplyAccess Right 'G' abbreviationHi 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.  
98122 Sep 2014 @ 08:30 PDTDatabaseReplyTeradata as object databaseVery 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.....
98022 Sep 2014 @ 08:03 PDTDatabaseReplySelecting all rows that have a unique columnCan 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...
97922 Sep 2014 @ 07:50 PDTDatabaseReplyAccess Right 'G' abbreviationI am not sure, it can be for Global and Persistent data(GLOP). 
97822 Sep 2014 @ 10:36 PDTDatabaseReplyRows should be appended to a column in teradataWith 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.
97722 Sep 2014 @ 09:00 PDTDatabaseReplyRows 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...
97622 Sep 2014 @ 07:30 PDTDatabaseReplyRows should be appended to a column in teradataselect name1,regexp_replace(tdstats.udfconcat(trim(desc1)),'"','',1,0,'i') from your_table group by 1;
97522 Sep 2014 @ 05:18 PDTDatabaseReplyGlobal temporary TableEve using the keyword  ALL at the end? use ON COMMIT PRESERVE ROWS at the end .    
97422 Sep 2014 @ 04:50 PDTGeneralReplyQUERY INVALID ERRORMulti 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...
97322 Sep 2014 @ 04:39 PDTDatabaseReplyConditional Statements in TeradataYou 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...
97222 Sep 2014 @ 12:44 PDTDatabaseReplyUTF -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...

Pages