#DateForumTypeThreadPost
375305 Jun 2015 @ 08:35 PDTDatabaseReplyConcatenate using || causes nullThis is Standard SQL behaviour, use COALESCE(field,'').
375205 Jun 2015 @ 08:30 PDTDatabaseReplytimestamp problemTeradata can't use single digit month/day/hour, you might try TO_TIMESTAMP instead: to_timestamp(upper(col1), 'mm/dd/yyyy hh:mi:ss am')
375105 Jun 2015 @ 07:38 PDTTeradata ApplicationsReplyWhy TPT is successful with return code 0, even when records goes to ET table?Hi Chandu, and now for something completely different :-)   0008 SET RECORD VARTEXT "»"  DISPLAY_ERRORS  NOSTOP;      Total Error Table 1  ...
375005 Jun 2015 @ 05:02 PDTDatabaseReplyReg Rules and Limitations for Dynamic Result SetsHi Lav, have a look at ALLOCATE: http://www.info.teradata.com/htmlpubs/DB_TTU_15_00/index.html#page/SQL_Reference/B035_1148_015K/ch03.139.001.html
374905 Jun 2015 @ 04:42 PDTGeneralReplyTuning queryThere're no matching PI, so the optimizer needs to do some preparation steps and the estimated time is quite close to the actual runtime, so maybe you can't speed it up...   The esti...
374805 Jun 2015 @ 04:25 PDTGeneralReplyCASE is a solution?Can you show some sample data and expected result?
374705 Jun 2015 @ 04:21 PDTDatabaseReplyNo More Spool Space IssuesWhat's the Explain and the actual resource usage from QryLogStepsV? The Tables are having millions of records. If we simply select and execute the subquery it will give some billions of rec...
374605 Jun 2015 @ 04:16 PDTDatabaseReplytimestamp problemYou need to define the input as a VarChar instead of a timestamp (and your format doesn't match the input): USING ( COL1 VARCHAR(16) ) INSERT INTO XXX.TIME_TABLE VALUES ( CAST (:COL...
374505 Jun 2015 @ 04:13 PDTDatabaseReplyCollect stats taking long timeHi Srichakra, in 14.10 it's not recommended to collect stats individually to drop and recreate stats There's an Orange Book on the new functionality in TD14.10, addit...
374405 Jun 2015 @ 04:00 PDTTeradata ApplicationsReplyWhy TPT is successful with return code 0, even when records goes to ET table?Hi Chandu, where in the FastLoad log did you find that information? Only the number of errors is returned.
374304 Jun 2015 @ 03:10 PDTDatabaseReplyImport Null Valuesinsert into mytable (column4) values (?); And don't forget to add COMPRESS to the remaining 3 columns.
374204 Jun 2015 @ 10:01 PDTGeneralReplyINMOD and UDF library listingHi Sam, what exactly are you trying to do? Maybe the FROM_BYTES function is what you need: select from_bytes('1234567890abcdef'xb, 'base16') http://www.info.teradata.com/HTMLP...
374104 Jun 2015 @ 09:39 PDTGeneralReplyTuning queryWhat's the Explain of the Insert/Select? Did you check the QueryLog which steps are slow?
374004 Jun 2015 @ 09:14 PDTTeradata ApplicationsReplyWhy TPT is successful with return code 0, even when records goes to ET table?Hi Chandu, afaik this is not possible, but this was the same for FastLoad :-)
373904 Jun 2015 @ 09:09 PDTTeradata StudioReplyLoad Limit of 50K Rows in v15.10I just tried it and it's the same bug in Studio 15.10.00.201504221135 on my Mac :-)
373804 Jun 2015 @ 08:09 PDTTeradata StudioReplyLoad Limit of 50K Rows in v15.10Is the target table a SET table and FastLoad removed duplicate rows silently?
373704 Jun 2015 @ 07:34 PDTToolsReplyWhen are secondary indexes required?Hi Mahesh, you're correct, this index is totally useless as 'c2' is already partitioned by day.
373604 Jun 2015 @ 07:33 PDTTeradata ApplicationsReplyWhy TPT is successful with return code 0, even when records goes to ET table?Hi Chandu,  FastLoad exits with "Highest return code encountered = '0'" if there are any rows in the Error Tables. Only when you specify an ErrorLimit the job will fail, th...
373504 Jun 2015 @ 07:15 PDTTeradata StudioReplyLoad Limit of 50K Rows in v15.10How did you check it, SELECT COUNT(*) FROM tab?
373403 Jun 2015 @ 03:00 PDTGeneralReplyCYlinder sizeWithout access to DBA tools, the easiest way is: CREATE VOLATILE TABLE vt, DATABLOCKSIZE = 20 KBYTES(i INT) If this returns an error message your system uses large cylinders. On those systems...
373303 Jun 2015 @ 12:42 PDTDatabaseReplySQL query to find given IDs not in tableYou need to split the list of values into rows: WITH cte AS ( SELECT CAST(token AS INT) AS id FROM TABLE (STRTOK_SPLIT_TO_TABLE(1, '1991,1992,1993', ',') RE...
373203 Jun 2015 @ 12:39 PDTDatabaseReplyHow to get sequence numbers for a particular group based on consecutive valuesHi Javed, in fact this is not a dense rank, but a similar problem: select dt.*, sum(flag) over (partition by ManagerName order by VisitDate rows unb...
373102 Jun 2015 @ 04:47 PDTGeneralReplySQL Sub QueriesHi Shoaib, this is usually done using HAVING plus CASEes: SELECT Appl_id FROM tab GROUP BY Appl_id HAVING SUM(CASE WHEN Security_Type = 'Misc' THEN 1 ELSE 0 end) > 0 AN...
373002 Jun 2015 @ 04:33 PDTDatabaseReplyTeradata Express database instance - why no Windows versionTeradata is no longer supported on Windows. Now as a Virtual Machine you can run it whereever you want, Linux/Windows/Mac. It requires you to install a VM Player, but previously you needed admin ...
372901 Jun 2015 @ 02:55 PDTDatabaseReplyHow to substract exactly one monthIf this is correct or not depends on the definition of "exactly one month" :-)   You might want Oracle's definition: oAdd_Months(2015-02-28,-1) is supported in TD14

Pages