![]() |
Hi,
22 Mar 2015
| 2 comments
,
|
![]() |
|
![]() |
replace PROCEDURE db.sp_test (IN year_num INTEGER,IN descr varchar(250)) DYNAMIC RESULT SETS 1 BEGIN DECLARE results1 CURSOR WITH RETURN ONLY FOR select b.column, cast((a.column *100) as decimal(5,2)) as pct, a.column from db1.tab1 as a inner join db1.tab2 as b on(a.some_column=b.some_column) inner join
30 May 2014
,
|
![]() |
How to check whether the particular user has execute permission for the SP? If not how to grant?
11 Feb 2013
| 4 comments
,
|
![]() |
How to execute teradata macro and stored procedure in XML?
Please let me know if the below statement are correct in terms of macro and SP execution inside XML <Query> EXEC MACRO_NAME (Parm) </Query>
<Query> CALL PROCEDURE_NAME (parm) </query>
11 Jul 2012
,
|
![]() |
I 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 way. The CONTINUE HANDLER does just fine if there is 1 index missing if there are multiple then the handler is no longer managing the process and the SP errors out with a message of 'Index doesn't exist' DECLARE CONTINUE HANDLER FOR SQLSTATE VALUE '52004'
31 May 2011
| 1 comment
,
|
![]() |
Hi, I am using TD .NET provider 12.x and have stored procedures. All my SPs have IN & OUT parameters. In my understanding, TD has a strange way to returning the OUT params as a dataset & it works fine. When I have SP that delete records from a table, and also returns OUT params. When I execute this Sp from .NET, I get a empty dataset (tables = 0). On checking the data, it actually deletes the data correctly. But how can I know that records are deleted? I don't want to unnecessarily check the data for delete confirmation. any help is appreciated. Thanks. SP Code:
13 May 2010
| 4 comments
,
|