Hello Friends ..
I am new to db2 .
I created the db2 sql stored procedure , and I am using db2 client to create a procudure . when i rebuild the procedure its giving the problem as below ....
============================================
ADMINISTRATOR.MyProc1 - Build started.
Create stored procedure returns -7032.
-- LOG FILE P9021654.log FOR PROCEDURE ADMINISTRATOR.MYPROC1
-- DB2_SQLROUTINE_PREPOPTS=
-- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp\P9021654.sqc
LINE MESSAGES FOR P9021654.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.
-- DB2_SQLROUTINE_COMPILER_PATH=MS
-- FAILED TO OPEN MS
-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp\P9021654.BAT
@echo on
set SQLROUTINE_FILENAME=P9021654
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\SA MPLE\ADMINISTRATOR\tmp\P9021654.def
LIBRARY P9021654
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8
-- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp\P9021654.c
-- C COMPILATION ERROR CODES: 0 0 1
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp>set SQLROUTINE_FILENAME=P9021654
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\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)
ADMINISTRATOR.MyProc1 - Build failed.
ADMINISTRATOR.MyProc1 - Roll back completed successfully.
===========================================
Pls guide me in resolving the issue ./
also guide me in steps the procedure to resolve the same.
Thanks a ton in advance ...
Thanks
MAHESH L.
==============