0 - 19 of 19 tags for stored procedures

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

Unity Director currently has a number of limitations regarding the use of stored procedures. These limitations are often misunderstood, and mistakenly lead to the assumption that stored procedures are not currently supported by Unity Director.

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 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.
 
 
 

The iBatis (MyBatis) Stored Procedure Wizard allows you to right click on a Stored Procedure in the Teradata plug-in for Eclipse and quickly create a Web service.

The iBatis Stored Procedure Wizard wraps a Stored Procedure into an iBatis or MyBatis SQL Map. The generated SQL map can then be used to create a Web service or it can be used to create a Java application that uses the iBatis or MyBatis frame works.

 

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.

 

Last time we did a full on What, Why and How description of some pretty Teradata specific information around Query Banding and showed how we could weave this into the Web Application and Data Access Layers so as to minimize the impact of this on the Business Service layer and it’s developers.

This week we are going to keep on the core Teradata trail by looking into Macros and Stored Procedures as means to provide for Isolation and Embedded Processing.