Hi ,

When i am trying to build a stored procedure .I am getting the following errors :

CAPIREADMIN.PROC_DELETE_VARIABLE - Build started.
Create stored procedure returns -7032.

-- LOG FILE P2181525.log FOR PROCEDURE CAPIREADMIN.PROC_DELETE_VARIABLE

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp\P2181525.sqc


LINE MESSAGES FOR P2181525.sqc

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

SQL0060W The "C" precompiler is in progress.

SQL0091W Precompilation or binding was ended with "0"

errors and "0" warnings.


-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sr_cpath.b at




-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp\P2181525.BAT

@echo on
set SQLROUTINE_FILENAME=P2181525
set db2path=C:\PROGRA~1\IBM\SQLLIB

-- COMPILATION COMMAND:

nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.ma k


-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp\P2181525.def

LIBRARY P2181525
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8


-- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp\P2181525.c
-- C COMPILATION ERROR CODES: 0 0 1


C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp>set SQLROUTINE_FILENAME=P2181525



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp>nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.ma k

'nmake' is not recognized as an internal or external command,

operable program or batch file.


-- END OF LOG FILE (SQLCODE: -7032)

CAPIREADMIN.PROC_DELETE_VARIABLE - Build failed.
CAPIREADMIN.PROC_DELETE_VARIABLE - Roll back completed successfully.


Please help me as it is urgent.

Do you have a C compiler on the DB2 server?
Andy