O'Reilly logo

SQL for eServer i5 and iSeries by Kevin Forsythe

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 8. Creating Stored Procedures

In Chapter 7, we reviewed the process of creating user-defined functions (UDF). As discussed, these functions extend SQL’s ability to extract and format data from within tables. As useful as they are, there are times where something more is required. Most applications are comprised of a series of programs that perform various complex tasks. As shown in earlier examples, SQL may be used from within these application programs, but SQL may also be used to create programs. In SQL syntax, these programs are referred to as stored procedures. If the term “stored procedure” has always been a little intimidating to you, relax: they are nothing more than programs, just like those that you may have already written in ...

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