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 ...
Get DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.