I would need to pass value in the form of a Tableau Parameter to a Teradata Stored Procedure. On doing this I am getting an error "The stored procedure "[DATABASE].[PROCEDURE_NAME]" does not return a result set, or the result set columns do not have names.

I can run stored procedures from within SAS, but I cannot seem to be able to create them? Is this a limitation of the SAS Access for Teradata software?
Thanks

Hi
     When i try to execute the below statement inside a Stored Procedure as below i get an error as stated:
CALL DBC.SYSEXECSQL ('COLLECT STATISTICS ON DBNAME.Table_Name  INDEX (Column1);');  
ERROR:
The user does not have STATISTICS access to DBNAME.Table_Name.
 

Hi

Hi Techies,
 
I am working on a stored procedures which has  cursors dynamic sqls and two calls to other procedures. My procedure is working really slow. I want to know if calling procedures inside another procedure makes it slow?
Please provide your expert comments.
 
 
Thanks

Hello,
I have a stored procedure that was written for Oracle.  I am curious how to convert it to a Teradata-friendly format:
 
create procedure RegionSelect (cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE) as
  BEGIN OPEN cur_OUT FOR select * from Region Order By RegionId; END;
 
Can someone advise?

Hi ..
Can we use POSITION function in stored procedure ?
It gave error when I try to use this function , probably because Stored Procedure itself contains POSITION keyword !!
Actually I wanted to see if particular character is present in the string and need to follow few steps depending on the criteria..
 
Thanks
 

I have to analyse 250 stored procedures to identify the tables and views they are using to get data from or inserting into. Is there a view of achieving this other than manually trying to eye-ball code. Even 80% accuracy will suffice. Will be grateful for any directions. Thanks.

Does anyone know if there is a way to trap/display line numbers from stored procedures during execution errors (much in the way that a line number is displayed during a compile error)? I don’t see anything in any forum or documentation that indicates this capability exists (and for 7 years I haven’t heard of anything like this).

Hi Guys
I have created a Stored Procedure which do some string manipulation. Below is much simple version of actual string manipulation.

REPLACE PROCEDURE TST_PROC(IN VAL_TO_CHANGE VARCHAR(30), INOUT CHANGED_VAL VARCHAR(30))
BEGIN
SEL UPPER(VAL_TO_CHANGE) INTO CHANGED_VAL;
END;

And I can call the procedure

Hi All,
I have a SP like this
 

Inside a Stored Procedure i need to read the values from a flat file and load that into a table and do some operations in that. Likewise i also need to do some transformations in some tables and write the output into a flat file. How can i achieve this functionality inside a SP?
Thanks in advance :)

Hi all,
I would like to put a value from a column field int a variable and I cannot find a way how to do it in Stored procedures.
What I would need:
to count number of rows of a table and compare it with a count of a specific value from a specific column of the table.

Hi,
 
I am new to Teradata.
I want to make a procedure in Teradata wich will do the follwing job:
 
1.Read an integer from a table in Teradata.(SELECT)
2.Increment a constant value to it.
3.Append the value in the same Table.(INSERT)
4.Return that value.
 
 
 

Hi All

I would like to find out the dependency between Stored procedures and the associated tables using data dictionary tables. I have tried my best to find out but went in vain.

Please suggest me a way to find out using teradata only.

Hi All,

I recently wrote some macro's but am now considering porting to the code to stored procedure's considering macro's are a single transaction and could be very expensive in terms of rollback if yiou have lots of inserts in them.