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.
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
To set the options at the instance level, use the DB2 registry variable ...