![]() |
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.
05 Aug 2016
,
|
![]() |
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?
22 May 2015
,
|
![]() |
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.
25 Nov 2014
| 11 comments
,
|
![]() |
Hi
30 Oct 2014
| 2 comments
,
|
![]() |
|
![]() |
Hi Techies,
30 Jul 2014
,
|
![]() |
Hello,
14 Jul 2014
| 6 comments
,
|
![]() |
Hi ..
13 Aug 2013
| 2 comments
,
|
![]() |
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.
01 Jun 2013
| 2 comments
,
|
![]() |
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).
28 May 2013
,
|
![]() |
Hi Guys 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
24 May 2013
| 3 comments
,
|
![]() |
|
![]() |
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?
18 Feb 2013
| 3 comments
,
|
![]() |
Hi all,
14 Feb 2013
| 5 comments
,
|
![]() |
Hi,
21 Nov 2012
| 1 comment
,
|
![]() |
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.
14 Dec 2011
| 1 comment
,
|
![]() |
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.
03 Nov 2011
| 1 comment
,
|
![]() |
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.
28 Oct 2011
| 3 comments
,
|
![]() |
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.
14 Jun 2009
,
|