10 Reasons for Organizing Stored Procedure into Chapters and Steps

I made organizing Stored Procedures into Chapters and Steps a principle. These separation points are marked by comments and variables ...

Read More
10 Reasons for Organizing Stored Procedure into Chapters and Steps

Teradata Stored Procedures – Dynamic or Static SQL

  Characteristics of Static SQL The SQL statement code cannot be changed during the Stored Procedure execution.Variables and parameters can ...

Read More
Teradata Stored Procedures – Dynamic or Static SQL

Teradata Stored Procedures Error Handling

Introduction to Teradata Stored Procedures & Error Handling Error handlers in Teradata provide similar functionality to modern procedural languages (C++, ...

Read More
Teradata Stored Procedures Error Handling

Mistakes To Avoid When Using Cursors in Teradata Stored Procedures

What Is A Cursor In A Teradata SQL Stored Procedure? When we are talking about Cursors in Teradata SQL stored ...

Read More
Mistakes To Avoid When Using Cursors in Teradata Stored Procedures

Teradata Stored Procedures – Scope Of Variable Declarations

Variable declarations in a Teradata Stored Procedure are always local to the surrounding compound statement (BEGIN…END) and to all the ...

Read More
Teradata Stored Procedures – Scope Of Variable Declarations

Teradata Partition Elimination with Stored Procedures

Teradata Partition Elimination – the Stored Procedure Approach Sometimes we need to select the rows from a table’s character column starting with a ...

Read More
Teradata Partition Elimination with Stored Procedures