O'Reilly logo

V14 Certification: Teradata SQL by Tom Coffing, Leona Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 19 - Stored Procedure Functions

“Freedom from effort in the present merely means that there has been effort stored up in the past.”

- Theodore Roosevelt

Stored Procedures Vs. Macros

Stored Procedures

•Contains SQL

•Contains comprehensive SPL

•Parameter values can be passed to it

•Must use a cursor to retrieve > than 1 row

•Stored in DATABASE or USER PERM

•May return 1 or more values to client as parameter

Macros

•Contains SQL

•May contain BTEQ Dot commands

•Parameter values can be passed

•May retrieve 1 or more rows

•Stored in DBC PERM Space

•Returns rows to the client

Stored Procedures are a lot like Macros. However, they manipulate data a row at a time. Stored Procedures take up PERM Space, unlike Views and Macros that do NOT. Stored ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required