Hi guys,
i'm using the below statements in db2 8.1.6 [windows 2000]
i'm using db2 development center to create a stored procedure ... but end up with the error
_________________________________
WEBUSER.insert_event_f - Build started.
Create stored procedure returns -7032.
-- LOG FILE P6460528.log FOR PROCEDURE WEBUSER .INSERT_EVENT_F
-- DB2_SQLROUTINE_PREPOPTS=
-- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\tmp\P6460528.sqc
LINE MESSAGES FOR P6460528.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\CW REPOS\WEBUSER\tmp\P6460528.BAT
@echo on
set SQLROUTINE_FILENAME=P6460528
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\CW REPOS\WEBUSER\tmp\P6460528.def
LIBRARY P6460528
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8
-- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\tmp\P6460528.c
-- C COMPILATION ERROR CODES: 0 0 1
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\tmp>set SQLROUTINE_FILENAME=P6460528
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\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)
WEBUSER.insert_event_f - Build failed.
WEBUSER.insert_event_f - Roll back completed successfully.
___________________________________
i'm not really sure whats causing this error [as its not a systax error] - any help will be appreciated