Hi, Group ...
I'm a new user to DB2. I tried to create a stored procedure using Stored
Procedure Builder and faces some problems below :-

I tried to create a simple procedure but a face the message like this :-

CREATE PROCEDURE EQUITY.ProcTest ( )
LANGUAGE SQL
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
declare a integer;
declare b integer;
set a = 2;
set b = 5;
END P1

And the following messages :-


EQUITY.PROCTEST - Create stored procedure returns -7032.

EQUITY.PROCTEST:

*** PREPCOMPILE F:\MAYBANK2U\SQLLIB\function\routine\sqlproc\DB2\EQUITY\tmp\P5548890.sqc
***



LINE MESSAGES FOR P5548890.sqc

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

SQL0060W The "C" precompiler is in progress.

SQL0091W Precompilation or binding was ended with "0"

errors and "0" warnings.



*** COMPILE F:\MAYBANK2U\SQLLIB\function\routine\sqlproc\DB2\EQUITY\tmp\P5548890.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%\C ommon\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=P5548890

set db2path=F:\MAYBANK2U\SQLLIB



nmake /f F:\MAYBANK2U\SQLLIB\function\routine\sqlproc.mak



*** F:\MAYBANK2U\SQLLIB\function\routine\sqlproc\DB2\EQUITY\tmp\P5548890.def
***

LIBRARY P5548890

EXPORTS _pgsjmp@4

pgsjmp=_pgsjmp@4





F:\MAYBANK2U\SQLLIB\function\routine\sqlproc\DB2\EQUITY\tmp>set SQLROUTINE_FILENAME=P5548890




F:\MAYBANK2U\SQLLIB\function\routine\sqlproc\DB2\EQUITY\tmp>set db2path=F:\MAYBANK2U\SQLLIB




F:\MAYBANK2U\SQLLIB\function\routine\sqlproc\DB2\EQUITY\tmp>nmake /f F:\MAYBANK2U\SQLLIB\function\routine\sqlproc.mak




The name specified is not recognized as an

internal or external command, operable program or batch file.



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



SQL7032N SQL procedure "PROCTEST" not created. Diagnostic file is

"P5548890.log". SQLSTATE=42904


EQUITY.PROCTEST - Build failed.

EQUITY.PROCTEST - Changes rolled back.


Someone pls help...
Thank You Very Much..
Best Regrads..YC Choo