#DateForumTypeThreadPost
831 May 2011 @ 01:07 PDTDatabaseReplyCONTINUE HANDLER in Stored ProcedureI think I found the answer to my own question: This is what I did and it appears to be working DDLERROR: BEGIN DECLARE CONTINUE HANDLER FOR SQLSTATE VALUE '52004' BEGIN...
731 May 2011 @ 11:53 PDTDatabaseTopicCONTINUE HANDLER in Stored ProcedureI am using a CONTINUE HANDLER as part of my stored procedure to manage Dropping of Indexes. I do not want the SP to error out becuase an Index doesn't exist as I am just wanting to drop it any w...
629 Apr 2011 @ 06:28 PDTDatabaseTopicStored Procedure support in Teradata 14I am at a client site where we are designing a system utilizing Stored Procedures. However, we have a dba here that has said that when Teradata 14 comes out they will no longer support Store Proce...
520 Apr 2011 @ 10:15 PDTDatabaseTopicExecuting DDL in a Store ProcedureI am using Data Stage to execute stored procedures. My stored procedures have DROP/CREATE Indexes and COLLECT STATISTICS statements in them. I can execute these with no issues from SQL Assistant....
413 Apr 2011 @ 06:09 PDTDatabaseReplyvolatile table as select..with data - not loading dataThat worked perfectly.. Thanks..
313 Apr 2011 @ 05:32 PDTDatabaseTopicvolatile table as select..with data - not loading dataI am creating a multiset volatile table from a select statement that has a table join. Is this not allowed for the creation of the volatile table? When I execute the statement it creates the t...
208 Mar 2011 @ 07:03 PSTExtensibilityReplyCreating SQL UDF issuesThanks.. We are on 13.0 here. I was afraid about not being able to use the declare, and repeat clauses. I have made a request to our DBA group to install the Oracle functions, so hopefull...
107 Mar 2011 @ 11:40 PSTExtensibilityTopicCreating SQL UDF issuesI am trying to create a UDF SQL function in Teradata 13, but keeping getting errors when I try to compile it. So I have tried creating one from the Teradata documentation just to see if I could ge...