|
Macros dont use perm space
Stored procedure requires perm space
Why?
,
09 Mar 2010
| 2 comments
|
|
|
|
I am new to stored procedure. We might need to capture error code from store procedure in bteq to take decision based on success/failure of stored procedure.How can I return ERRORCODE from store procedure? I would like to use BTEQ syntax .IF ERRORCODE <> 0 to take decision based on stored procedure success/failure.
,
13 Feb 2010
| 1 comment
|
|
|
|
We have some code being developed, which is pretty basic.
It works fine as straight SQL but gives unexpected results when the code is put in a stored procedure.
It seems that the stored procedure do NOT work when more than one punctuation character is contained in the search string.
One character in the string works as expected. More than on character does not.
The following proc doesn’t returned the expect results.
call CM_ADW_WEB_SRVC_V_DD.Account_Prospect_By_Broker_P('T.I.S. LTD.');
,
07 Jan 2010
|
|
|
Last time we introduced the SQL Stored Procedure as a means to provide for Embedded Analytics. However, as of Teradata 12.0 it is possible to use the Java Language as the basis for External Stored Procedures (known as JXSP’s), so this week we will develop a Java based version of the ApplyRiskFactorsToQuote Stored Procedure.
,
27 Jun 2009
|
42
41
|
|
|
Last time we introduced the Macro and the Stored Procedure as a means to provide for Isolation between the SQL call and the underlying database structure. This week we are going to keep on the core Teradata trail by looking into Stored Procedures as means to provide for Embedded Processing.
,
21 Jun 2009
|
66
60
|
|
Until you have Teradata V13 Statistics Wizard Easy Feature available for your Teradata installation, here is a set of stored procedures that will generate and/or run collect statistics statements based on a set of index, column and referential integrity rules.
,
07 Apr 2009
| 1 comment
|
42
31
|
|
Tags |
|
6 tags for Stored Procedure
|
