Preparing to develop routines

Before you develop routines with the workbench, there are some setup steps that you should complete. Also, read information about which types of routines are supported for development and what authorities and privileges are required.

To build SQL stored procedures that target DB2® for Linux®, UNIX®, and Windows® prior to Version 8.2, or for external SQL stored procedures that target DB2 for z/OS®, you must install and configure a C compiler on the server. For more information, see the IBM® DB2 Application Development Guide.

Related concepts
Working with stored procedures
Working with user-defined functions (UDFs)
Related tasks
Prerequisites for developing Java stored procedures
Prerequisites for developing routines on Linux
Prerequisites for developing routines that target DB2 for z/OS

Feedback