Steps for setting up the storage process building environment in DB2 V7

This article mainly describes the correct settings of the building environment of the DB2 V7 stored procedure. We all know that in the stored procedure of DB2 V7, it can be written in C, JAVA, or SQL, however, you need to install the C compiler. The following is a detailed description of the article.

1. V7 SQL Stored procedures are built using the built-in DB2 SPB development tool (Stored Procedure Builder), provided that it supports third-party C compilers. Such as VC5/VC6 or C compiler released by IBM.

2. The following describes how to use VC6. The directory location must be modified based on the Installation conditions.

A. Run DB2 SPB, create A project, select the target database, and enter the logon ID and password;

B. "selected" menu, SQL SP build option,

Compiler environment: c: \ Program Files \ Microsoft Visual Studio \ VC98 \ Bin \ vcvars32.bat

Compiler Options: cl-Ox-W2/TC-D_X86 _ = 1-IC: \ Progra ~ 1 \ SQLLIB \ include SQLROUTINE_FILENAME.c/link-dll-def: SQLROUTINE_FILENAME.def/out: SQLROUTINE_FILENAME.dll C: \ Progra ~ 1 \ SQLLIB \ lib \ db2api. lib

The compiler environment is actually a batch processing of some environment variable settings. The option is actually to compile the command line. Note that the path in the command does not support long file names, and the DOS file name format of 8.3 must be used. The above content is an introduction to the Environment setting for building the DB2 V7 stored procedure. I hope you will get some benefits.

The above content describes the setup of the building environment for the DB2 V7 stored procedure, hoping to help you in this regard.