Hi Folks,

I am executing a stored procedure to update some data in a table. While executing it is giving the below problem.

ECSYS.UPDATE_USER - Build started.
Create stored procedure returns -7032.

-- LOG FILE P9161521.log FOR PROCEDURE ECSYS .UPDATE_USER

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR C:\ecentre\SQLLIB\function\routine\sqlproc\ECSYS\E CSYS\tmp\P9161521.sqc

LINE MESSAGES FOR P9161521.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

-- CONTENTS OF C:\ecentre\SQLLIB\function\routine\sr_cpath.bat



-- CONTENTS OF C:\ecentre\SQLLIB\function\routine\sqlproc\ECSYS\E CSYS\tmp\P9161521.BAT

@echo on
set SQLROUTINE_FILENAME=P9161521
set db2path=C:\ecentre\SQLLIB

-- COMPILATION COMMAND:

nmake /f C:\ecentre\SQLLIB\function\routine\sqlproc.mak


-- CONTENTS OF C:\ecentre\SQLLIB\function\routine\sqlproc\ECSYS\E CSYS\tmp\P9161521.def

LIBRARY P9161521
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8


-- COMPILATION MESSAGES FOR C:\ecentre\SQLLIB\function\routine\sqlproc\ECSYS\E CSYS\tmp\P9161521.c
-- C COMPILATION ERROR CODES: 0 0 1

C:\ecentre\SQLLIB\function\routine\sqlproc\ECSYS\E CSYS\tmp>set SQLROUTINE_FILENAME=P9161521

C:\ecentre\SQLLIB\function\routine\sqlproc\ECSYS\E CSYS\tmp>set db2path=C:\ecentre\SQLLIB

C:\ecentre\SQLLIB\function\routine\sqlproc\ECSYS\E CSYS\tmp>nmake /f C:\ecentre\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)

ECSYS.UPDATE_USER - Build failed.
ECSYS.UPDATE_USER - Roll back completed successfully.

The entry of Compiler in SQLLIB\FUNCTION\ROUTINE is like below
COMPILER=MS
#COMPILER=IBM

Can anybody help me in resolving this. Any assistance in this regards is highly appreciated.

Thanks and best regards,
Krishna.

Could you please proive input regarding your Operating System and Database version information?

Cheerrsss,
Jai

Hi Jai,

The OS i am using is Windows 2003 and the DB version is "IBM DB2 Universal database version 8".

Please let me know if you need any additional information.

PS: if you don't mind can I add your yahoo id (i found with your response) so that we can discuss the things.

Thanks and best regards,
Krishna Prasad.

This error is because of invalid compailer path.Please set the comiler path properly as below.

db2set DB2_SQLROUTINE_COMPILER_PATH=<.... path of C /C++ compiler...>

If Visual studio(VC++) is already installed in your machine please set the path like below....

db2set DB2_SQLROUTINE_COMPILER_PATH=C:\Program Files\Microsoft Visual Studio\VC98\Bin\VCVARS32.BAT

Thanks,
Nagaraj

Hi Nagraj,

Thanks for your reply. I am newbie to DB2. Please bear with me. What is meant by c/c++ compiler here. where can I find it.

Look forward to hearing from you.

Thanks and best regards,
Krishna.

Hi Krishna,

For compiling stored procedure on DB2 UDB V8.1 you need to have a C/C++ compiler. The DB2_SQLROUTINE_COMPILER_PATH variable points to the C/C++ compiler.

If you do not have a C/C++ compiler installed on your Windows machine you can dowload cygwin and configure it.

Check this link: http://www-128.ibm.com/developerwork...306haungs.html

HTH
ritz