O'Reilly logo

Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition by Tom Coffing, William 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 36 - 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

Macros Stored Procedures

• 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

• Contains SQL

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

 

 

 

 

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

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