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 C. Building from the Command Line

This appendix aims to make building SQL procedures from the command line a breeze. The first part of the chapter focuses on building using LUW. Sections for iSeries and zSeries are toward the end.

Configuring the Build Environment

Because a C/C++ compiler is no longer a requirement for DB2 LUW, no configuration is needed before being able to build SQL procedures. However, you can specify options as to how DB2 builds the SQL procedure. These options can be configured at the instance level by setting the DB2_SQLROUTINE_PREPOPTS DB2 registry variable or they can be configured at the SQL procedure level by calling the SET_ROUTINE_OPTS function.

To set the options at the instance level, use the DB2 registry variable ...

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