第四部分 DB2 V7.X 版本SQL存储过程编译配置说明

lx86

第四部分 DB2 V7.X 版本SQL存储过程编译配置说明

　　DB2 开发系列
　　DB2在V7.X环境下编译存储过程需要在数据库服务器上安装C编译器，且要设置DB2 SQL存储过程C编译器的路径。
　　当没有为服务器设置编译器时在开发中心编译存储过程时，服务器都会返回错误信息：[IBM][CLI Driver][DB2/NT] SQL7032N  SQL procedure "PROC1" not created.  Diagnostic file is "P3413010.log".  SQLSTATE=42904
　　在存储过程编编译临时目录下：..\SQLLIB\function\routine 有存储过程的编译输出说明，在对应的log文件中，一般可以看到如下内容：
　　*** PREPCOMPILE C:\PROGRA~1\SQLLIB\function\routine\sqlproc\DEVELOP\DB2ADMIN\tmp\P3413010.sqc ***
　　LINE    MESSAGES FOR P3413010.sqc
------  --------------------------------------------------------------------
       SQL0060W  The "C" precompiler is in progress.
148   SQL0204N  "DB2ADMIN.ZHOUHAIMING" is an undefined name.
       SQL0091W  Precompilation or binding was ended with "0"
                 errors and "1" warnings.
　　*** COMPILE C:\PROGRA~1\SQLLIB\function\routine\sqlproc\DEVELOP\DB2ADMIN\tmp\P3413010.c ***
　　
@echo off
REM set VCV6_DRIVE=c:\Microsoft Visual Studio
REM set include=%include%;%VCV6_DRIVE%\VC98\atl\include;%VCV6_DRIVE%\VC98\mfc\include;%VCV6_DRIVE%\VC98\include
REM set lib=%lib%;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib
REM set path=%path%;%VCV6_DRIVE%\Common\Tools\WinNT;%VCV6_DRIVE%\Common\MSDev98\Bin;%VCV6_DRIVE%\Common\Tools;%VCV6_DRIVE%\VC98\bin;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib
　　@echo off
REM set VCV5_DRIVE=c:\Program Files\devstudio
REM set include=%include%;%VCV5_DRIVE%\vc\include;%VCV5_DRIVE%\vc\atl\include;%VCV5_DRIVE%\vc\mfc\include
REM set lib=%lib%;%VCV5_DRIVE%\vc\lib;%VCV5_DRIVE%\vc\mfc\lib
REM set path=%path%;%VCV5_DRIVE%\sharedide\bin\ide;%VCV5_DRIVE%\sharedide\bin;%VCV5_DRIVE%\vc\bin
　　
@echo on
set SQLROUTINE_FILENAME=P3413010
set db2path=C:\PROGRA~1\SQLLIB
　　nmake /f C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak
　　*** C:\PROGRA~1\SQLLIB\function\routine\sqlproc\DEVELOP\DB2ADMIN\tmp\P3413010.def ***
LIBRARY P3413010
EXPORTS _pgsjmp@4
pgsjmp=_pgsjmp@4
　　
C:\PROGRA~1\SQLLIB\function\routine\sqlproc\DEVELOP\DB2ADMIN\tmp>set SQLROUTINE_FILENAME=P3413010
　　C:\PROGRA~1\SQLLIB\function\routine\sqlproc\DEVELOP\DB2ADMIN\tmp>set db2path=C:\PROGRA~1\SQLLIB
　　C:\PROGRA~1\SQLLIB\function\routine\sqlproc\DEVELOP\DB2ADMIN\tmp>nmake /f C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak
　　'nmake' 不是内部或外部命令，也不是可运行的程序
或批处理文件。
　　----------------------------------------------------------------------------
　　SQL7032N  SQL procedure "PROC1" not created.  Diagnostic file is
"P3413010.log".  SQLSTATE=42904
　　如果初一看此文件，根本不知道原因在什么地方，主要原因就是没有设置C编译器引起的，因为在DB2 V7.X版本中，DB2 编译 SQL 存储过程时会将SQL存储过程首先生成C代码，然后使用C编译器编译成DLL文件之后在执行注册程序将存储过程以程序包的方式编译到数据库中。因此要编译SQL存储过程，首先就要解决编译器设置的问题。
　　执行一次编译以后在安装目录下 ： ..\SQLLIB\function\routine 会产生出一个sr_cpath.bat 的文件，如果没有执行过编译，该文件是不会产生的，用记事本打开该文件可以看到如下内容：

@echo off
set VCV6_DRIVE=C:\Program Files\Microsoft Visual Studio
set include=%include%;%VCV6_DRIVE%\VC98\atl\include;%VCV6_DRIVE%\VC98\mfc\include;%VCV6_DRIVE%\VC98\include
set lib=%lib%;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib
set path=%path%;%VCV6_DRIVE%\Common\Tools\WinNT;%VCV6_DRIVE%\Common\MSDev98\Bin;%VCV6_DRIVE%\Common\Tools;%VCV6_DRIVE%\VC98\bin;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib

@echo off
REM set VCV5_DRIVE=c:\Program Files\devstudio
REM set include=%include%;%VCV5_DRIVE%\vc\include;%VCV5_DRIVE%\vc\atl\include;%VCV5_DRIVE%\vc\mfc\include
REM set lib=%lib%;%VCV5_DRIVE%\vc\lib;%VCV5_DRIVE%\vc\mfc\lib
REM set path=%path%;%VCV5_DRIVE%\sharedide\bin\ide;%VCV5_DRIVE%\sharedide\bin;%VCV5_DRIVE%\vc\bin

　　我们就是要将C编译器的路径指向到当前服务器上安装的路径，下面以
　　vc6.0
　　visual studio.net 2002 + .net framwork 1.1
　　visual studio.net 2003
　　三种方式说明该文件的设置。
　　1、 vc6.0
　　@echo off
　　set VCV6_DRIVE=c:\Microsoft Visual Studio(更改此路径的内容为VC 6 的安装路径即可)
　　set include=%include%;%VCV6_DRIVE%\VC98\atl\include;%VCV6_DRIVE%\VC98\mfc\include;%VCV6_DRIVE%\VC98\include
　　set lib=%lib%;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib
　　set path=%path%;%VCV6_DRIVE%\Common\Tools\WinNT;%VCV6_DRIVE%\Common\MSDev98\Bin;%VCV6_DRIVE%\Common\Tools;%VCV6_DRIVE%\VC98\bin;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib
　　@echo off
　　REM set VCV5_DRIVE=c:\Program Files\devstudio
　　REM set include=%include%;%VCV5_DRIVE%\vc\include;%VCV5_DRIVE%\vc\atl\include;%VCV5_DRIVE%\vc\mfc\include
　　REM set lib=%lib%;%VCV5_DRIVE%\vc\lib;%VCV5_DRIVE%\vc\mfc\lib
　　REM set path=%path%;%VCV5_DRIVE%\sharedide\bin\ide;%VCV5_DRIVE%\sharedide\bin;%VCV5_DRIVE%\vc\bin
　　2、 visual studio.net 2002 + .net framwork 1.1
　　@echo off
　　set VCV6_DRIVE=C:\Program Files\Microsoft Visual Studio .NET(.net安装路径)
　　set include=%include%;%VCV6_DRIVE%\Vc7\include;%VCV6_DRIVE%\Vc7\atlmfc\include
　　set lib=%lib%;%VCV6_DRIVE%\Vc7\lib;%VCV6_DRIVE%\Vc7\atlmfc\lib
　　set path=%path%;C:\WINNT\Microsoft.NET\Framework\v1.1.4322;%VCV6_DRIVE%\Common7\Tools;%VCV6_DRIVE%\Common\Tools;%VCV6_DRIVE%\Vc7\bin;%VCV6_DRIVE%\VC7\lib;%VCV6_DRIVE%\VC7\include;C:\Program Files\Microsoft Visual Studio .NET\FrameworkSDK\Bin;C:\Program Files\Microsoft Visual Studio .NET\Common7\IDE
　　@echo off
　　REM set VCV5_DRIVE=c:\Program Files\devstudio
　　REM set include=%include%;%VCV5_DRIVE%\vc\include;%VCV5_DRIVE%\vc\atl\include;%VCV5_DRIVE%\vc\mfc\include
　　REM set lib=%lib%;%VCV5_DRIVE%\vc\lib;%VCV5_DRIVE%\vc\mfc\lib
　　REM set path=%path%;%VCV5_DRIVE%\sharedide\bin\ide;%VCV5_DRIVE%\sharedide\bin;%VCV5_DRIVE%\vc\bin
　　此种环境配置时需要注意蓝色标出的部分，这部分在.NET环境和6.0环境的路径是有区别的。
　　3、 visual studio.net 2003
　　@echo off
　　set VCV6_DRIVE=C:\Program Files\Microsoft Visual Studio .NET 2003(.net安装路径)
　　set include=%include%;%VCV6_DRIVE%\Vc7\include;%VCV6_DRIVE%\Vc7\atlmfc\include
　　set lib=%lib%;%VCV6_DRIVE%\Vc7\lib;%VCV6_DRIVE%\Vc7\atlmfc\lib
　　set path=%path%;C:\WINNT\Microsoft.NET\Framework\v1.1.4322;%VCV6_DRIVE%\Common7\Tools;%VCV6_DRIVE%\Common\Tools;%VCV6_DRIVE%\Vc7\bin;%VCV6_DRIVE%\VC7\lib;%VCV6_DRIVE%\VC7\include;C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\Bin;C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE
　　@echo off
　　REM set VCV5_DRIVE=c:\Program Files\devstudio
　　REM set include=%include%;%VCV5_DRIVE%\vc\include;%VCV5_DRIVE%\vc\atl\include;%VCV5_DRIVE%\vc\mfc\include
　　REM set lib=%lib%;%VCV5_DRIVE%\vc\lib;%VCV5_DRIVE%\vc\mfc\lib
　　REM set path=%path%;%VCV5_DRIVE%\sharedide\bin\ide;%VCV5_DRIVE%\sharedide\bin;%VCV5_DRIVE%\vc\bin
　　此种环境配置时需要注意蓝色标出的部分，这部分在.NET环境和6.0环境的路径是有区别的。
　　保存文件，推出编辑，重新编译存储过程。