Teradata Macros

Teradata macros are reusable blocks of SQL code that can be stored in the Teradata database management system and executed ...

Read More
Teradata Macros

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