Correct setup of the DB2 V7 storage process Build Environment

This article mainly describes the setup of the DB2 V7 storage process build environment. If you encounter similar situations in actual operations, however, if you do not know how to set up the DB2 V7 storage process build environment, the following articles must be a mentor to you.

The stored procedure of DB2 version 7 can be written in C, JAVA, or SQL, but the C compiler needs to be installed.

The stored procedure of DB2 version 7 can be written in C, JAVA, or SQL, but the C compiler needs to be installed.

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 is an introduction to the Environment setting for building the DB2 V7 stored procedure. I hope you will get some benefits.