39 | 27 Aug 2014 @ 04:56 PDT | Database | Reply | Cursor in Dynamic SQL | Hi..have solved it.
It workes when you give double quotes. '' cursor '' :)
|
38 | 11 Aug 2014 @ 04:51 PDT | Database | Reply | Getting AMP step failure error | is it an express edition of TD ? (1 AMP)
|
37 | 11 Aug 2014 @ 03:11 PDT | Database | Topic | Cursor in Dynamic SQL | Hi 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... |
36 | 08 Jul 2014 @ 07:34 PDT | General | Topic | Case statement in Join | Hi
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... |
35 | 01 Jul 2014 @ 03:49 PDT | General | Reply | In 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
|
34 | 24 Jun 2014 @ 03:12 PDT | General | Reply | I have defined PPI on a table.But i am not using PPI in a Where clause,how would be the performance | Hi.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... |
33 | 24 Jun 2014 @ 03:05 PDT | General | Reply | Teradata SQL query run | You 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... |
32 | 13 Dec 2013 @ 12:23 PST | Database | Reply | Collect stats doubt | :)
|
31 | 12 Dec 2013 @ 11:14 PST | Database | Reply | Collect stats doubt | thanks 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... |
30 | 12 Dec 2013 @ 10:50 PST | Database | Reply | Skewed Query | use 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... |
29 | 12 Dec 2013 @ 09:36 PST | Database | Topic | Collect stats doubt | Hello 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 ... |
28 | 23 Oct 2013 @ 04:12 PDT | General | Reply | Collecting Stats | I 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... |
27 | 23 Oct 2013 @ 02:39 PDT | General | Topic | TDLOAD(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... |
26 | 23 Oct 2013 @ 02:19 PDT | Database | Topic | Load 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 ... |
25 | 21 Oct 2013 @ 02:23 PDT | Database | Reply | System utilization/ System health queries | You 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... |
24 | 21 Oct 2013 @ 02:16 PDT | Database | Reply | FASTLOAD LOCK - Table being loaded - Data inaccessible | Helo 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... |
23 | 16 Oct 2013 @ 11:36 PDT | Database | Reply | primary index in IN clause or exists clause >? | Yes,thanks for the help:)
|
22 | 16 Oct 2013 @ 01:42 PDT | Database | Reply | primary 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
|
21 | 15 Oct 2013 @ 11:32 PDT | Database | Topic | primary 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... |
20 | 15 Oct 2013 @ 02:20 PDT | General | Reply | Collecting Stats | in 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 ... |
19 | 15 Oct 2013 @ 02:09 PDT | General | Reply | Collecting Stats | The best practice is to collect the stats once your data load is done.You do not have to calculate the % of data changed.
_aravind
|
18 | 13 Oct 2013 @ 10:42 PDT | Database | Topic | SELECT 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... |
17 | 08 Oct 2013 @ 03:35 PDT | Connectivity | Reply | Doubt in connectivity with Java and TD | its not too often, but this is to prevent in case when it goes down(down means lose connection in between)
|
16 | 07 Oct 2013 @ 03:42 PDT | Connectivity | Topic | Doubt in connectivity with Java and TD | The 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... |
15 | 07 Oct 2013 @ 03:41 PDT | Database | Topic | Java App to restart with TD | The 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... |