November 2004
Intermediate to advanced
576 pages
11h 49m
English
book
DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition
by Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul Chong, Michael Gao, Fraser McArthur, Paul Yip
Content preview from DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...