Release Notes (FixPak 3)

Configuring the C environment for SQL stored procedures in the Development Center

If you are working with DB2^(R) for Windows^(R) on the server and you are using the Visual C++ compiler, you must configure your SQL build settings. You will be not be able to build SQL stored procedures until you configure your SQL Build options.

Use the Database Connection Properties notebook in the Development Center to configure your SQL build settings.

To configure the C compiler environment for SQL stored procedures:

1. On the SQL Build Settings page of the notebook, specify a compiler environment that you want to use for building SQL objects.
   • Click Refresh.
   • In the Compiler environment field, type the location of the VC98\BIN\VCVARS32.BAT file on your Windows server.
2. Click OK to close the notebook and save your changes. If you click Apply, the changes are saved and you can continue changing the properties.