DB2 - SQL Stored Procedure

[Guest_imported]

I'm having a massive problem with building SQL Stored Procedures using DB2 V7.2 FP 5 and VC++ 5.0.

My Stored Procedure Builder compiles it correclty and everything, btu when it comes to the makefile, it returns an error. For better understanding, i posted the messages returned by the builder below.

Any advice on this would be greatly appreciated.

P.S. the paths and the like aer all ok, I can call the nmake from the specified paths.

here is the message:

DBADMIN.PROC1 - Create stored procedure returns -7032

DBADMIN.PROC1:
*** BIND D:\SQLLIB\function\routine\sqlproc\SAMPLE\DBADMIN\tmp\P1550010.sqc ***

LINE MESSAGES for P1550010.sqc
------ ---------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended
with "0" errors and "0" warnings.

*** COMPILE D:\SQLLIB\function\routine\sqlproc\SAMPLE\DBADMIN\tmp\P1550010.c ***

@echo off
REM set VCV6_DRICE = 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=P1550010
set db2path=D:\SQLLIB

nmake /f D:\SQLLIB\function\routine\sqlproc.mak

*** D:\SQLLIB\function\routine\sqlproc\SAMPLE\DBADMIN\tmp\P1550010.def ***
LIBRARY P1550010
EXPORTS _pgsjmp@12
pgsjmp=_pgsjmp@12

D:\SQLLIB\function\routine\sqlproc\SAMPLE\DBADMIN\tmp>set SQLROUTINE_FILENAME=P1550010

D:\SQLLIB\function\routine\sqlproc\SAMPLE\DBADMIN\tmp>set db2path=D:\SQLLIB

D:\SQLLIB\function\routine\sqlproc\SAMPLE\DBADMIN\tmp>nmake /f D:\SQLLIB\function\routine\sqlproc.mak

The name specified is not recognized as an internal or external command, operable program or batch file.

------------------------------------------------------------

SQL0732N SQL procedure "" not created. Diagnostic file is "". SQLSTATE=00000

DBADMIN.PROC1 - Changes rolled back.

DBADMIN.PROC1 - Build failed.

 

[Guest_imported]

you must have o C++ compiler installed on your system. if you haven't already tried to install a c++ compiler and you need more suggestions, let me know.

 

[Guest_imported]

What is problem in writing here.

The person above is writing clearly he has VC++ etc...

so post here if you know what is solution

 

[nshen]

Try to use db2set on the application side to set
DB2_SQLROUTINE_COMPILER_PATH to your
msvc_install_directory\VC98\bin\vcvars32.bat.

(from DB2 Application Building Guide)
Regards, Nancy