0 - 14 of 14 tags for #STOREDPROCEDURE

Hello to everybody,

I'm trying to return the result of a select query in a function. Something like:

Hello,

I'm trying to execute a procedure (F_SEPARA_LETRAS_Y_NUMEROS) with another procedure called inside (F_QUITA_REPES) but I get the following error:

Hi!
I've got issue with error handling in my procedure
Here's some of my code:

Hi I am trying to use volatile table inside of a stored procedure (for stored returned select statement and looping through it), but I am running into the issue of  Missing/Invalid SQL statement'E(3807):Object 'Temp_Table' does not exist.'.

Hi I having some trouble finding a workaround for SELECT Failed. 6916:  TOP N Syntax error: Top N option is not supported in subquery inside of a stored procedure.

The documentation for 14 and 15 says that the following should be possible but I cannot get it to work. Any suggestions team?

Hi
I am using TD 14.0 and writing a stored procedure where using GOTO I am trying to move to another Label.
But surprisingly it is showing me error as below.
 
SPL1027:E(L34), Missing/Invalid SQL statement'E(3703):'GOTO' is a Teradata SQL keyword reserved for future use.'.

I’m trying to do a test stored procedure on using volatile tables.  This is what I have:
 
CREATE PROCEDURE "DLPMC_PMCOE_DEV_LAB"."test_sp" ()
                DYNAMIC RESULT SETS 1
BEGIN
 

Hi,
Can someone pls explain what is Near Real Time stored procedure architecture framework?  How it works?  If you have implemented the stored procedure in your project, pls share how you implemented, challenges faced etc.  Can we replace it by bteq?  If yes, what are advantages and disadvanges with stored procedure and bteq approaches?

I would like to store the resutsets return from the help command such as - help column db.coumnname inside a table/SP etc

How can I translate this loop into Teradata SQL?
 

DECLARE @logdate DATETIME  

DECLARE @hrinput1 INTEGER

DECLARE @hrinput2 INTEGER

SET @logdate = '2013-03-01' 

SET @hrinput1 = '0'

SET @hrinput2 = '1'

 

while @logdate <= '2013-04-01' 

BEGIN 

How can I translate the following ms sql to Teradat Stored Procedure?
 

DECLARE @logdate DATETIME  

DECLARE @hrinput1 INTEGER

DECLARE @hrinput2 INTEGER

SET @logdate = '2013-03-01' 

SET @hrinput1 = '0'

SET @hrinput2 = '1'

 

while @logdate <= '2013-04-01' 

BEGIN 

Hi,
I am trying to compare the row count of table in two different databases but the tables are similar with same DDL. I need to call table name in cursor and database names are parameters of the procedure.  
Replace procedure testProc(a varchar(30),b varchar(30))
BEGIN
-- Cursor is having the names of table in order