#DateForumTypeThreadPost
5425 May 2015 @ 06:36 PDTDatabaseReplyTeradata valid date check without udfHi Dieter, There is no fixed format. Currently that column has 0, 50, AC etc...as values. Might be in future we will get date values. I am assuming that should be in yyyy-mm-dd format.
5324 May 2015 @ 02:50 PDTDatabaseReplyTeradata valid date check without udfI don't want to join with sys_calendar. Is there any other way?
5224 May 2015 @ 06:15 PDTDatabaseTopicTeradata valid date check without udfHi All, I am having a column with data type as CHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL but there are chances the same column will hold date value as well. We need to check if t...
5124 May 2015 @ 06:08 PDTDatabaseReplyDROP COLUMNHi John, Drop column command will delete just the column and column data but not all table data.
5027 Mar 2015 @ 02:03 PDTDatabaseReplyPerformance with pertitioned tableIt won't increase the performance.
4926 Mar 2015 @ 10:35 PDTDatabaseReplyPerformance with pertitioned table Hi Moutusi,   You can try the same way as Dieter mentioned above. Try the below menthod: extract(year from T1.STRT_DT) >= CAST(T2.STRT_YR AS TIMESTAMP(0)))
4826 Mar 2015 @ 09:57 PDTDatabaseReplyOrder by Statement for Volatile Tables and Efficiency Hi Bob,   I am not clear. What's the issue in the above code and what error message you are getting while creating volatile table? Only issue i can see in the above code is ...
4725 Mar 2015 @ 02:08 PDTDatabaseReplyNeed help in generating sequence numbers in BTEQ script Hi Lalitha,   I am not clear with the requirement. If this seq id is for a table then you can try like this:         SEQ_ID_COL BIGINT NOT NULL GENERATED...
4620 Mar 2015 @ 06:45 PDTDatabaseReplyFailure 3932 Only an ET or null statement is legal after a DDL Statement. KVB, I tried the same way where i am able to run successfully. Let me know how you executed?    *** Logon successfully completed.    *** Teradata Database...
4520 Mar 2015 @ 05:40 PDTDatabaseReplyHow SYSDATE will work if load is going more than one dayYou will get different date as system date for the next day will be that day current date. You can also try with current_date or date.
4418 Mar 2015 @ 02:21 PDTDatabaseReplyNeed suggestions to optimize the complex query (below) involving several Joins and Aggregation..Hi Sumit, 1) Can you try collecting stats individually for the below columns. I mean single column stats. Multi column stats if collected already let it be. T9.MATERIAL_ID T9.PLANT_ID T9.END_DA...
4318 Mar 2015 @ 01:18 PDTDatabaseReplyNon duplicate row selection queryCan you try including DIRECT_ID column also in the Partition by and rerun and see the performance.
4217 Mar 2015 @ 11:19 PDTDatabaseReplySubstitute Values from Predecing or following columnsHi, For the same question, Dnoeth has replied in the below link. Did you tried using that?  http://forums.teradata.com/forum/database/ordered-analytical-functioniterative-loop-1
4117 Mar 2015 @ 10:32 PDTDatabaseReplyNon duplicate row selection queryHi John, Apart from DIRECT_ID is there any other columns which you can use as a differentiating column between two records. For ex: date or timestamp column etc.. When you are inserting to&n...
4024 Feb 2015 @ 02:15 PSTDatabaseReplyRemove the first 4 characters in a stringHi Dvya, I am not able to understand your question? Are you saying if there is matching offerid in table a and b, it should return only those records?
3924 Feb 2015 @ 01:31 PSTDatabaseReplyVolatile query not working or a way to select a subset of the main queryHi, This should help to get subset of the main query: sel col1, amt from ( sel col1, (col2 * col3) as amt from tbname ) aa;
3824 Feb 2015 @ 12:29 PSTDatabaseReplyOptimization of Insert....Select statementApoorv, Can you give some more details? -- What is the difference between the 2 inserts? -- 2 inserts are selecting data from different base tables? -- Usually which insert will have more volum...
3724 Feb 2015 @ 12:14 PSTDatabaseReplyMultiload Error Table InterpretationHi Abhi, Can you give the error message you are getting? Are you loading it through informatica?
3603 Feb 2015 @ 11:47 PSTDatabaseReplyPartition Row number usageSaranya, 1) I am seeing the below peice used twice. Might be you are doing double check but using in anyone place is advisable. AND a.start_date BETWEEN '2015-01-01' AND '2015-01-02&#...
3503 Feb 2015 @ 11:04 PSTDatabaseReplyPerformanceHi John, For the above query which you are facing spool space issue, i have few questions? 1. Any idea why there is no alias used in TIME_PERIOD- EXTRACT(DAY FROM TIME_PERIOD? Even for this ...
3409 Jan 2015 @ 01:18 PSTDatabaseReplyALTER TO CURRENTHi, Instead of getting the entire result set, interval is used to extract only particular 'n' days of data because of which your query plan changes. Reg' the time zones, i am not clear...
3309 Jan 2015 @ 11:58 PSTDatabaseReplyParameter Query in Excel ODBCHi Vinay, I am not understanding correctly. What you are trying to acheive by giving parameter query string? Above syntax is not working correctly for me.
3209 Jan 2015 @ 09:55 PSTDatabaseReplyrequired to get the records for last 6 monthsHi Saranya, Let me know if this works for you. sel order_date FROM Database.tablename tb1, (sel max(order_date) as mdate FROM Database.tablename) tb2 where order_date between add_month...
3109 Jan 2015 @ 09:28 PSTDatabaseReplyDifference between accessing single Partition and Multiple partitionsHi KVB, Ideally it should take less time if you query for a month. What is the data volume you have for both the months?
3006 Jan 2015 @ 12:08 PSTDatabaseReplyHow to identify the unused stats in a query.Hi Sreedhar, You can collect stats on the index columns & join columns. It's not necessary to collect stats on all the columns in a table.

Pages