#DateForumTypeThreadPost
357809 Mar 2015 @ 04:21 PDTGeneralReplyIs Null conditions in ON (Join) Vs. Is Null in WhereThis is not specific for IS NULL, whenever you add a condition to the ON it's evaluated during the join, while a condition on WHERE is evaluated after the join.   See: http://www.in...
357709 Mar 2015 @ 04:14 PDTGeneralReplyDate format DD-MON-YYYY to YYYY-MM-DD What's the actual data & datatype of col?
357609 Mar 2015 @ 04:13 PDTDatabaseReplyGenerating sequence numbers for given range valuesHi Prado, you might create a table UDF returning a sequence of numbers.
357509 Mar 2015 @ 04:10 PDTDatabaseReplyDefining two derived tables using WITH clause ??Hi Ashish, afaik you can't use WITH in an Update.
357407 Mar 2015 @ 08:15 PSTDatabaseReplyHigh CPU utilization query : While doing all-AMPS mergeOf course you don't need any statistics for a simple INSERT/SELECT, but if you want more accurate estimates you must change the WHERE-condition, e.g. WHERE PERD_ID between 201300 and 201499...
357307 Mar 2015 @ 08:09 PSTDatabaseReplyDefining two derived tables using WITH clause ??Hi Ashish, your syntax is wrong, it's INSERT INTO ... WITH SELECT ... instead of WITH SELECT ... INSERT INTO ...
357207 Mar 2015 @ 08:04 PSTDatabaseReplyGenerating sequence numbers for given range valuesHi Prado, seems like you want to expand blocks of ip-addresses. If your query runs out of spool it's probably not because of the recursion but due to the number of rows returned. Also recurs...
357105 Mar 2015 @ 12:54 PSTGeneralReplyDate format DD-MON-YYYY to YYYY-MM-DD Of course VarChar is the wrong datatype for storing a date, better cast it once during load and store it as a date.   You could cast the varchar to a date and then back to a varchar: TO_C...
357005 Mar 2015 @ 12:40 PSTDatabaseReplyHow to get a substring until the nth occurance of a characterRegular expressions are supported since TD14: REGEXP_SUBSTR(col, '(.*?\^){2}(.*?)(?=\^)')  
356904 Mar 2015 @ 10:43 PSTDatabaseReplyBITAND Function not workingIt's the BITAND in SYSLIB (previously installed as user UDFs at your site), which comes before TD_SYSFNLIB in the search path.  
356804 Mar 2015 @ 01:50 PSTDatabaseReplyBITAND Function not workingWorks for me, what's your TD release? Which overloaded functions exist on your system? SELECT DatabaseName, FunctionName, ParameterDataTypes FROM dbc.FunctionsV WHERE FunctionName = '...
356704 Mar 2015 @ 09:58 PSTToolsReplyTPT LoadingWhat's your TPT release?  14.10 supports formatted dates using VARDATE, e.g. DEFINE SCHEMA ...( col VARDATE(10) FORMATIN('DDMMMYYYY') FORMATOUT('YYYY-MM-DD')  
356604 Mar 2015 @ 09:40 PSTGeneralReplyStored Proc In Teradata For Calculated FieldHow do you currently implement the calendar for different countries/regions? The sequential number of business days can be easily calculated multiple times, one per country.
356504 Mar 2015 @ 02:18 PSTGeneralReplyStored Proc In Teradata For Calculated FieldThere was a similar question on StackOverflow: How to add column A (date column) to Column B ( number of business days) in teradata to get the new date?   The easiest way to do this is calc...
356404 Mar 2015 @ 01:06 PSTDatabaseReplyTeradata String Manipulation, Extract String from a text field.If you're on TD14 the easiest way will be STRTOK: strtok(P_ID,'~',3)  
356303 Mar 2015 @ 10:09 PSTExtensibilityReplyHide the source code of a SQL UDF from usersHi Rolf, afaik there's no way to hide the source of a SQL UDF (only SPs supports the NO SPL option). And if it was possible, one could simply use it in a WHERE-condition and then Explain reve...
356202 Mar 2015 @ 01:48 PSTCloud ComputingReplyVM Express GDO file isf.gdo is corrupted(?)You shouldn't have to send beer to Munich :-)
356102 Mar 2015 @ 01:21 PSTDatabaseReplyFailure 9128 The transaction exceeded the maximum number of rowhash locks allowedEvery single row Insert needs a RowHash-lock. If there's one million rows inserted within a single transaction this will result in one million RowHash-locks. So either don't do it within ...
356001 Mar 2015 @ 11:37 PSTCloud ComputingReplyError while opening downloaded TD14 expressHi Samir, did you unzip using the 7zip utility or Windows built-in? Windows unzip chokes on large files... This is from http://developer.teradata.com/database/articles/introduction-to-terada...
355901 Mar 2015 @ 11:11 PSTCloud ComputingReplyVM Express GDO file isf.gdo is corrupted(?)Check /etc/opt/teradata/tdconfig/Backup for a copy of the gdo. Otherwise you might simply delete the gdo, it will be automatically recreated with default values when the PDE starts. Of course...
355827 Feb 2015 @ 04:15 PSTDatabaseReplyQuerying data for time periodYou want the device with the latest activation date for the specified bill period? select * FROM VT_TEST_DATA_1 A INNER JOIN VT_TEST_DATA_2 B ON A.USER_ID = B.USER_ID an...
355727 Feb 2015 @ 04:04 PSTDatabaseReplyupdate syntaxHi Kevin, you might have been exposed to MySQL :) MySQL does it the way you described, but every other DBMS does it like Teradata, the order within the SET is irrelevant.   Instead of two ...
355626 Feb 2015 @ 11:28 PSTDatabaseReplyQUERY IS RUNNING LONG TIME(40 MINS) TO EXTRACT 1 LACK RECORDSThis problem is usually caused by duplicate row checks due to a bad Primary Index on a SET table. What's the actual data in CDD.DT_ID?
355525 Feb 2015 @ 11:37 PSTDatabaseReplyMultiple values in where clauseThis seems to be the same requirement as this question: Need help to create SQL query   SELECT A.PRODUCT_NM , A.PRODUCT_ID , CASE WHEN COUNT(*) = COUNT(B.PRODUCT_...
355425 Feb 2015 @ 11:05 PSTDatabaseReplySQL that shows current queriesThe query I posted is pure SQL, you can submit it from any client.  

Pages