#DateForumTypeThreadPost
3927 Aug 2014 @ 04:56 PDTDatabaseReplyCursor in Dynamic SQLHi..have solved it. It workes when you give double quotes. '' cursor ''  :) 
3811 Aug 2014 @ 04:51 PDTDatabaseReplyGetting AMP step failure erroris it an express edition of TD ? (1 AMP)
3711 Aug 2014 @ 03:11 PDTDatabaseTopicCursor in Dynamic SQLHi i have a cursor which returns me the date. Belwo is the sample FOR Cur_Dt AS Cur CURSOR FOR SELECT STRT_DT FROM table WHERE STRT_DT BETWEEN 1900 -01  01 AND 9999 01...
3608 Jul 2014 @ 07:34 PDTGeneralTopicCase statement in JoinHi    i have multiple instances of the same table used. For eg: A left join b on a.id1 = b.id left join B on a.id2=b.id left join B on a.id3 = b.id -- and then selecting records...
3501 Jul 2014 @ 03:49 PDTGeneralReplyIn BTEQ if we want to go forward we use condititional logic (if ..then GO TO .Label name).By using BTEQ can we go backward?Hello Nope , we cannot go backward   
3424 Jun 2014 @ 03:12 PDTGeneralReplyI have defined PPI on a table.But i am not using PPI in a Where clause,how would be the performanceHi.if you have where clause on the PI then its better not to have a PPI on the table, it will degrade th eperformance.Why.? because for getting the PI value it has to  go through wach and ever...
3324 Jun 2014 @ 03:05 PDTGeneralReplyTeradata SQL query runYou can check that only through viewpoint or from PMON (depending on your TD version).It tells which step it is running.But cannot estimate how long that particular step will take again.   T...
3213 Dec 2013 @ 12:23 PSTDatabaseReplyCollect stats doubt:)
3112 Dec 2013 @ 11:14 PSTDatabaseReplyCollect stats doubtthanks both for your replies.. @saeed --> i understood your second point. But i differ in the 1st , i , i have seen even if the join conditions are together, collecting single column stats u...
3012 Dec 2013 @ 10:50 PSTDatabaseReplySkewed Queryuse the below query and identify the PI has skew or now. Or when u join whe column which is getting redistributed or duplicated has skew or not.   sel hashamp(hashbucket(hashrow(<PI colum...
2912 Dec 2013 @ 09:36 PSTDatabaseTopicCollect stats doubtHello all,   In which case we go for multi column stats . when we have a clause where table1.id=table2.id1 and table1.flag=table2.flag1 -- here we can seperately collect stats on flag and ...
2823 Oct 2013 @ 04:12 PDTGeneralReplyCollecting StatsI would say, better have a practice of collecting stats after the table load has done. Count shd be validated by b4 and after.But if the change is by updating the key columns this wont be suitable...
2723 Oct 2013 @ 02:39 PDTGeneralTopicTDLOAD(TPT easy load) Hello ,   I need to load a table from a different table which is in the same DB by using TDLOAD i have a statement tdload -h 192.168.64.128  -u st...
2623 Oct 2013 @ 02:19 PDTDatabaseTopicLoad with TDload (TPT)Hello ,   I need to load a table from a different table which is in the same DB by using TDLOAD i have a statement tdload -h 192.168.64.128  -u students -p learning13 -t emp2 ...
2521 Oct 2013 @ 02:23 PDTDatabaseReplySystem utilization/ System health queriesYou can get all these info from dbc.dbqlogtbl . do a sel * on this. Can check for amp usage. Cpu usage columns. can see the dates and time of the query from starttime column and username column g...
2421 Oct 2013 @ 02:16 PDTDatabaseReplyFASTLOAD LOCK - Table being loaded - Data inaccessibleHelo Chanukya,   A dummy fload script on the table willl help here. Else i hope if you have a PMON installed(or any DBA monitoring tool) you can try to abort the fload session "(it mig...
2316 Oct 2013 @ 11:36 PDTDatabaseReplyprimary index in IN clause or exists clause >?Yes,thanks for the help:)
2216 Oct 2013 @ 01:42 PDTDatabaseReplyprimary index in IN clause or exists clause >?Thanks guys. So Ulrich, You mean if its data type matches it will be helpful and will giv good performance.   Thanks  
2115 Oct 2013 @ 11:32 PDTDatabaseTopicprimary index in IN clause or exists clause >?Hello,   If i have column emp_id as an index. and if u use it in 'in' clause or exists clause will i get the beiifit of PI as in = clause foe eg: sel *  from table where emp_i...
2015 Oct 2013 @ 02:20 PDTGeneralReplyCollecting Statsin fact YEs.. collect stats shd be taken when a certain % of data changes. if you know its very few you donot have to take it. But make it a best practice to take stats in a specific interval for ...
1915 Oct 2013 @ 02:09 PDTGeneralReplyCollecting StatsThe best practice is to collect the stats once your data load is done.You do not have to calculate the % of data changed. _aravind
1813 Oct 2013 @ 10:42 PDTDatabaseTopicSELECT Failed. [3540] Number of tables in join exceeds Parser limit.Hello,   The query has 394 instances of the same table.   Structure is  :   Select a,b from XYZ where j in (sel from t1 where --) and h in sel from t1 where --) Or ( G...
1708 Oct 2013 @ 03:35 PDTConnectivityReplyDoubt in connectivity with Java and TDits not too often, but this is to prevent in case when it goes down(down means lose connection in between)
1607 Oct 2013 @ 03:42 PDTConnectivityTopicDoubt in connectivity with Java and TDThe project I am working has a java front end and it connects to TD. Now they claims that when they were using mysql or oracle and if the connection with DB goes down , Java automatically connects...
1507 Oct 2013 @ 03:41 PDTDatabaseTopicJava App to restart with TDThe project I am working has a java front end and it connects to TeraData. Now they claims that when they were using mysql or oracle and if the connection with DB goes down , Java automatically co...

Pages