12 | 18 Nov 2015 @ 07:43 PST | Database | Topic | Stored Procedure conditional handler for spool out error 2646 |
I want to implement a continue handler in the stored procedure for query that can spool out.
I check in pdcrinfo. SqlState_Codes there is no sqlstate associated to spool out error 2646. ... |
11 | 22 Apr 2015 @ 05:43 PDT | Database | Reply | Permanent Journals | Journals can be deleted after submiting the "checkpoint with save" command which moves the rows from active journal to saved journal. Once the rows are moved to saved part then you can de... |
10 | 22 Apr 2015 @ 05:18 PDT | Database | Reply | deadlock issue in simultaneous DML statements. | Use locking modifiers before DML statements to avoid deadlock issue.
|
9 | 28 Mar 2015 @ 02:09 PDT | Database | Reply | Locking Table for Share | Thanks Fred :)
|
8 | 27 Mar 2015 @ 04:08 PDT | Database | Topic | Locking Table for Share | Can anyone tell me something about locking modifier "LOCKING ROW/TABLE/DATABASE FOR SHARE". Is it same as READ lock??
locking table student.employee for share
select * from ... |
7 | 27 Mar 2015 @ 03:54 PDT | Database | Reply | Teradata database restart? | TRATRACE command can be used to see information about restarts.
If you want to see last 5 restart information, then login to any node and enter tpatrace 5.
You can also use DBC.SW_Event_Log table... |
6 | 25 Mar 2015 @ 05:18 PDT | Database | Topic | How to identify the AMPs belong to the same cluster in Teradata | Hello,
Tables with fallback protection ensures that copy of each row is available on fallback AMPs in the same CLUSTER. I have few questions on this.
1) How do i identify that what all AMPs are t... |
5 | 11 Sep 2013 @ 11:13 PDT | Database | Reply | How to find table size and index size using Ferret utility | Thanks Dieter...
I am new to teradata and never used the ferret to find tha datablock size. Can you please tell me little bit in detail of the maths which i can use to find out the index siz... |
4 | 06 Sep 2013 @ 07:41 PDT | Database | Topic | How to find table size and index size using Ferret utility | Hi All,
Can anyone tell me how to find the index size and table size using Ferret Utility..
Also what are the other methods to find out index size apart of creating the table with and without ind... |
3 | 06 Sep 2013 @ 07:30 PDT | Database | Reply | Leading Spaces in answer set in SQLA | Hi All,
Thanks for your valuable suggestion.. i got the reason ... the machine which was showing result with leading spaces in answer set when using
to_char is because of one UDF with ... |
2 | 06 Sep 2013 @ 03:33 PDT | Database | Reply | Leading Spaces in answer set in SQLA | Hi All,
Thanks for the informations. I don't think that it is some casting issue as when i connect to my PROD server and query the same , i dont get any leading space and if i disconnect... |
1 | 05 Sep 2013 @ 12:33 PDT | Database | Topic | Leading Spaces in answer set in SQLA | Hello All,
I have created a dummy table and inserted one record in that table. When i simply select that record it gives me unwanted leading space in the answer set.
CREATE TABLE dummy (... |