O'Reilly logo

DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition by Paul Yip, Fraser McArthur, Michael Gao, Raul Chong, Drew Bradstock, Clara Liu, Zamil Janmohamed

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

Appendix H. Sample Application Code

This appendix provides supplementary examples of application code that is not SQL. In Chapter 5, “Understanding and Using Cursors and Result Sets,” the notion of returning result sets to an application program from an SQL procedure was introduced. In Chapter 8, “Nested SQL Procedures,” the notion of SQL stored procedures processing result sets was introduced.

This appendix discusses how an application program, written in C or Java, can process results sets that would be returned by a stored procedure. Additionally, examples of how Java stored procedures can process result sets are also provided. This information is particularly useful for the iSeries platform, where SQL stored procedures cannot process result ...

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