By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,991 Members | 1,737 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,991 IT Pros & Developers. It's quick & easy.

Getting errors when trying to build a stored procedure

P: 1
Hi,
New to Stored procedure. Basically just installed DB2 v8.1.0.36
Was trying to build a stored procedure.. It is giving following error..
Looks like some error related to configuration files... Can you help


I tried to have a look at all the files .. however unable to solve it .. can anyone let me know what i'm missing..
This is what i'm getting
db2admin.PROCEDURE1 - Build started.

Create stored procedure returns -7032.

-- LOG FILE P3122302.log FOR PROCEDURE DB2ADMIN.PROCEDURE1

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P3122302.sqc


LINE MESSAGES FOR P3122302.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

DB2PATH=C:\PROGRA~1\IBM\SQLLIB


-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P3122302.BAT

@echo on
set SQLROUTINE_FILENAME=P3122302
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\DB2ADMIN\tmp\P3122302.def

LIBRARY P3122302
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8


-- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P3122302.c
-- C COMPILATION ERROR CODES: 0 0 1


C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>DB2PATH=C:\PROGRA~1\IBM\SQLLIB



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set SQLROUTINE_FILENAME=P3122302



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.ma k

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

operable program or batch file.

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

operable program or batch file.


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

db2admin.PROCEDURE1 - Build failed.
db2admin.PROCEDURE1 - Roll back completed successfully.
Feb 17 '07 #1
Share this Question
Share on Google+
1 Reply


10K+
P: 13,264
Hi,
New to Stored procedure. Basically just installed DB2 v8.1.0.36
Was trying to build a stored procedure.. It is giving following error..
Looks like some error related to configuration files... Can you help


I tried to have a look at all the files .. however unable to solve it .. can anyone let me know what i'm missing..
This is what i'm getting
db2admin.PROCEDURE1 - Build started.

Create stored procedure returns -7032.

-- LOG FILE P3122302.log FOR PROCEDURE DB2ADMIN.PROCEDURE1

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P3122302.sqc


LINE MESSAGES FOR P3122302.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

DB2PATH=C:\PROGRA~1\IBM\SQLLIB


-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P3122302.BAT

@echo on
set SQLROUTINE_FILENAME=P3122302
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\DB2ADMIN\tmp\P3122302.def

LIBRARY P3122302
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8


-- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp\P3122302.c
-- C COMPILATION ERROR CODES: 0 0 1


C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>DB2PATH=C:\PROGRA~1\IBM\SQLLIB



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set SQLROUTINE_FILENAME=P3122302



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.ma k

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

operable program or batch file.

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

operable program or batch file.


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

db2admin.PROCEDURE1 - Build failed.
db2admin.PROCEDURE1 - Roll back completed successfully.
Did you try C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set PATH=C:\PROGRA~1\IBM\SQLLIB
instead of
C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB
Feb 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.