Hello
I am trying to create a test stored procedure. I know the syntax of the sp is correct but when I try to build I get the following log and it says that the sp build failed.
BUSDAT.ADMINISTRATOR.PROCEDURE1 - Build started.
Create stored procedure returns -7032.
-- LOG FILE P4373962.log FOR PROCEDURE ADMINISTRATOR.PROCEDURE1
-- DB2_SQLROUTINE_PREPOPTS=
-- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp\P4373962.sqc
LINE MESSAGES FOR P4373962.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.bat
-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp\P4373962.BAT
@echo on
set SQLROUTINE_FILENAME=P4373962
set db2path=C:\PROGRA~1\IBM\SQLLIB
-- COMPILATION COMMAND:
nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.mak
-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp\P4373962.def
LIBRARY P4373962
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8
-- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp\P4373962.c
-- C COMPILATION ERROR CODES: 0 0 1
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp>set SQLROUTINE_FILENAME=P4373962
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp>nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.mak
'nmake' is not recognized as an internal or external command,
operable program or batch file.
-- END OF LOG FILE (SQLCODE: -7032)
ADMINISTRATOR.PROCEDURE1 - Build failed.
ADMINISTRATOR.PROCEDURE1 - Roll back completed successfully.
Please Help
Thanks
I am trying to create a test stored procedure. I know the syntax of the sp is correct but when I try to build I get the following log and it says that the sp build failed.
BUSDAT.ADMINISTRATOR.PROCEDURE1 - Build started.
Create stored procedure returns -7032.
-- LOG FILE P4373962.log FOR PROCEDURE ADMINISTRATOR.PROCEDURE1
-- DB2_SQLROUTINE_PREPOPTS=
-- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp\P4373962.sqc
LINE MESSAGES FOR P4373962.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.bat
-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp\P4373962.BAT
@echo on
set SQLROUTINE_FILENAME=P4373962
set db2path=C:\PROGRA~1\IBM\SQLLIB
-- COMPILATION COMMAND:
nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.mak
-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp\P4373962.def
LIBRARY P4373962
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8
-- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp\P4373962.c
-- C COMPILATION ERROR CODES: 0 0 1
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp>set SQLROUTINE_FILENAME=P4373962
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\BUSDAT\ADMINISTRATOR\tmp>nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.mak
'nmake' is not recognized as an internal or external command,
operable program or batch file.
-- END OF LOG FILE (SQLCODE: -7032)
ADMINISTRATOR.PROCEDURE1 - Build failed.
ADMINISTRATOR.PROCEDURE1 - Roll back completed successfully.
Please Help
Thanks