O'Reilly logo

Netezza SQL by Mike Larkins, Tom 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 18 – Stored Procedure Functions

"Be not afraid of going slowly, Be afraid of standing still.“Chinese Proverb

Netezza Stored Procedures

"Life is a succession of lessons, which must be lived to be understood."

-Ralph Waldo Emerson

The NZPLSQL language provides for the following types of procedural logic:

•    Conditionals (if/else)

•    Looping (while, for)

•    Execution of SQL (including dynamic SQL)

•    Variables

•    Returning a scalar result or a result set

•    Input arguments

•    Execution in the calling context (session and transaction)

•    Extending functionality (adding NZPLSQL library routines)

A stored procedure is created (it is then automatically compiled), and then you run the stored procedure by either CALL or EXECUTE ...

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