error building stored procedures - SQLN7032N

[lsrilatha]

I have installed IBM DB2 UDB Version 7.2 with Store Procedure Builder on Windows 2000. I created the following procedure.

CREATE PROCEDURE userproc ( )
RESULT SETS 1
LANGUAGE SQL

P1: BEGIN
DECLARE cursor1 CURSOR WITH RETURN FOR
select * from users;

OPEN cursor1;
END P1

When I try to build the procedure I get the following error.

ADMINISTRATOR.USERPROC - Create stored procedure returns -7032.

ADMINISTRATOR.USERPROC:

*** BIND C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P4833340.sqc ***

LINE MESSAGES FOR P4833340.sqc

------ ----------------------------------------------------
SQL0060W The "C" precompiler is in progress.

SQL0091W Precompilation or binding was ended with "0"

errors and "0" warnings.

*** COMPILE C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P4833340.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=P4833340

set db2path=C:\SQLLIB

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


*** C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp\P4833340.def ***

LIBRARY P4833340

EXPORTS _pgsjmp@4

pgsjmp=_pgsjmp@4

C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp>set SQLROUTINE_FILENAME=P4833340

C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp>set db2path=C:\SQLLIB

C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINISTRATOR\tmp>nmake /f C:\SQLLIB\function\routine\sqlproc.mak

'nmake' is not recognized as an internal or external command, operable program or batch file.

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

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

"P4833340.log". SQLSTATE=42904


ADMINISTRATOR.USERPROC - Build failed.

ADMINISTRATOR.USERPROC - Changes rolled back.

Can someone please help me?
Thanks in advance.
Srilatha