#DateForumTypeThreadPost
1218 Nov 2015 @ 07:43 PSTDatabaseTopicStored 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. ...
1122 Apr 2015 @ 05:43 PDTDatabaseReplyPermanent JournalsJournals 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...
1022 Apr 2015 @ 05:18 PDTDatabaseReplydeadlock issue in simultaneous DML statements.Use locking modifiers before DML statements to avoid deadlock issue. 
928 Mar 2015 @ 02:09 PDTDatabaseReplyLocking Table for ShareThanks Fred :)
827 Mar 2015 @ 04:08 PDTDatabaseTopicLocking Table for ShareCan 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 ...
727 Mar 2015 @ 03:54 PDTDatabaseReplyTeradata 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...
625 Mar 2015 @ 05:18 PDTDatabaseTopicHow to identify the AMPs belong to the same cluster in TeradataHello, 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...
511 Sep 2013 @ 11:13 PDTDatabaseReplyHow to find table size and index size using Ferret utilityThanks 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...
406 Sep 2013 @ 07:41 PDTDatabaseTopicHow to find table size and index size using Ferret utilityHi 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...
306 Sep 2013 @ 07:30 PDTDatabaseReplyLeading Spaces in answer set in SQLAHi 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 ...
206 Sep 2013 @ 03:33 PDTDatabaseReplyLeading Spaces in answer set in SQLAHi 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...
105 Sep 2013 @ 12:33 PDTDatabaseTopicLeading Spaces in answer set in SQLAHello 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 (...