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