#DateForumTypeThreadPost
317803 Oct 2014 @ 11:46 PDTTeradata StudioReplyTools > Create > Database, User etc. dialogs missing in Teradata Studio Express 15TD Studio Express doesn't have the admin part, you need TD Studio .-)
317703 Oct 2014 @ 11:45 PDTDatabaseReply sql server . How they can be conveted to valid TeraData typesMost datatypes are exactly the same in Teradata, please check the manuals: http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1143_112A/title.040.2.html   ...
317603 Oct 2014 @ 06:41 PDTToolsReplyGet a Thousand Separators Using BTEQ Export ScriptHi Sri, you need to implicitly place the thousand seperators, some countries use hundred seperators :) Do you need leading zeroes? format '-999,999,999,999.99' Otherwise: format '-...
317503 Oct 2014 @ 06:33 PDTDatabaseReplyHow to concatenate a date in three different columns?That's simple, there's an invalid date. This function will return a NULL for invalid dates: REPLACE FUNCTION fnc_try_ymd_to_date(y INTEGER, m INTEGER, d INTEGER) RETURNS DATE SPECIFIC...
317402 Oct 2014 @ 08:38 PDTDatabaseReplyPartitioning by a character columnHi Sandesh, you will get partition elimination only for equality when using HASHBUCKET. So CHAR-PPI is the preferred sollution in 13.10.
317302 Oct 2014 @ 08:30 PDTDatabaseReplyHow to concatenate a date in three different columns?Instead of casting to strings and back to date you might use a numeric calculation: SELECT 1987 AS y, 2 AS m, 14 AS d, (y-1900)*10000 + m * 100 + d (DATE)  
317228 Sep 2014 @ 01:39 PDTTrainingReplyAny best Training Centres you guys know in Hyderabad??Logins are only revoked when a user spams. Nobody prevents him from using a different email to register again and then aswering questions instead of simply promoting himself.
317128 Sep 2014 @ 03:10 PDTTrainingReplyAny best Training Centres you guys know in Hyderabad??What I consider strange about Manohar (and some other similar guys): - Most of the "Manohar's the best" post are from members with didn't post anything else. They register, submi...
317027 Sep 2014 @ 10:10 PDTGeneralReplyStored ProcedureOf course can DDL and DML be mixed in the same SP, you just have to follow the rule that a DDL must be commited.
316927 Sep 2014 @ 10:08 PDTDatabaseReplyoutput of Stored ProcedureOf course can you use select in a macro, but no dynamic SQL.
316827 Sep 2014 @ 07:10 PDTDatabaseReplyMerge with error tableHi Moutusi, dbc.ErrorTblsV tracks existing error tables. And when you read the manuals you'll find all details: The SQL DML manual for MERGE and the SQL DDL manuals for CREATE ERROR TABLE. ...
316727 Sep 2014 @ 05:05 PDTDatabaseReplyoutput of Stored ProcedureNo, this is how returning answer sets from a SP is implemented (based on Standard SQL)
316627 Sep 2014 @ 03:21 PDTPrivate Forum
316527 Sep 2014 @ 03:15 PDTDatabaseReplyself join of table based on PI is spooling outHi Srilakshmi, can you show DDL plus query (join conditions) and explain? To get a direct join on the PI you must also add the partitioning columns to the join, too.
316427 Sep 2014 @ 03:06 PDTDatabaseReplyTuning LIKE OperatorWhat's the selectivity of your LIKE-condition? I just tried it on a TD15 VM and it's using a NUSI (or JI) if the number of distinct values is high (in my case 150,000 within 9,000,000 rows...
316327 Sep 2014 @ 02:36 PDTDatabaseReplyRemove characters after '-' in a stringTeradata Timestamps only support 6 digits, so you must strip of the last digit. Do you really have data with that accuracy? In your case there's a fixed format, so simply extracting the ...
316227 Sep 2014 @ 02:32 PDTDatabaseReplyoutput of Stored ProcedureProviding an error message instead of "unable to get an output" would be helpful. SysExecSQL/EXECUTE don't support SELECTs. You shoud read the Stored procedures manual, there's ...
316126 Sep 2014 @ 06:26 PDTDatabaseReplyTeradata Error: [3704] '' ('0A'X) is not a valid Teradata SQL token.Hi Amadu, '60'x should be a backtick "`", this is not valid in Teradata (or Standard SQL). You don't need to quote a name unless there are invalid characters in it or it'...
316026 Sep 2014 @ 06:22 PDTDatabaseReplyTuning LIKE OperatorDid you check if the optimizer misses a statistic? You can try a join index with the same PI as the base table and the column searched by LIKE: create join index ... as select id,end_dt, col1 ...
315926 Sep 2014 @ 06:15 PDTDatabaseReplyQualify in select statementI don't fuly understand what you want, but it seems like you need the row where the cumulative sum of the transaction amount reaches 300? Then you need to two nested QUALIFY: SELECT ... FR...
315825 Sep 2014 @ 10:05 PDTDatabaseReplyjob sequence numberDo you mean a column defined with GENERATED ALWAYS AS IDENTITY? This is the the way it is implemented in TD, it's not one sequence, it's a parallel sequence. Each AMP/PE reserverves a batc...
315725 Sep 2014 @ 09:25 PDTDatabaseReplySelect Statement inside a case statementHi Raghav, do you try to run this as a standalone query? select Case when (select count(*)from ABC) >'0' then 'Data is available' else 'No data' end or better s...
315625 Sep 2014 @ 08:51 PDTDatabaseReplyHow to group these records?The common technique to get this kind of result is using a cummulative sum on the 1/0 flag Raja mentioned: SELECT ... SUM(CASE WHEN GapDays >= 8 THEN 1 ELSE 0 end) OVER (PARTITION BY ...
315524 Sep 2014 @ 08:12 PDTDatabaseReplyDifference between TO and AS keywords in RENAME syntaxHi Balaji, there's no difference, it's just a syntax variation.
315424 Sep 2014 @ 08:10 PDTDatabaseReplyTemporary Disable\enable Constraints (Foreign Key, Check Constriant, Unique Key)Hi Parth, why do you want to disable/enable FKs? Due to bad performance? In a DWH you hardly find FKs and if they're usually implemented using REFRENCE WITH (NO) CHECK OPTION.

Pages