Hi,
I am using DB2 8.1 workgroup server edition. While building any stored procedure, I am getting the following message :
IRNT.P_CR_C_OB_VARIABLE - Build started.
Create stored procedure returns -7032.

-- LOG FILE P0410302.log FOR PROCEDURE IRNT .P_CR_C_OB_VARIABLE

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp\P0410302.sqc


LINE MESSAGES FOR P0410302.sqc

------ --------------------------------------------------------------------

SQL0060W The "C" precompiler is in progress.

SQL0091W Precompilation or binding was ended with "0"

errors and "0" warnings.


-- DB2_SQLROUTINE_COMPILER_PATH=E:\DB2SPs

-- FAILED TO OPEN E:\DB2SPs


-- CONTENTS OF C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp\P0410302.BAT

@echo on
set SQLROUTINE_FILENAME=P0410302
set db2path=C:\IBM\SQLLIB

-- COMPILATION COMMAND:

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


-- CONTENTS OF C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp\P0410302.def

LIBRARY P0410302
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8


-- COMPILATION MESSAGES FOR C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp\P0410302.c
-- C COMPILATION ERROR CODES: 0 0 2


C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp>set SQLROUTINE_FILENAME=P0410302



C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp>set db2path=C:\IBM\SQLLIB



C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp>nmake /f C:\IBM\SQLLIB\function\routine\sqlproc.mak

cl -Ox -W2 -TC -D_X86_=1 -MD -I"C:\IBM\SQLLIB\include" P0410302.c /link -dll /out:P0410302.dll -def:P0410302.def "C:\IBM\SQLLIB\lib\db2api.lib"



Microsoft (R) Program Maintenance Utility Version 6.00.8168.0

Copyright (C) Microsoft Corp 1988-1998. All rights reserved.



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

operable program or batch file.

NMAKE : fatal error U1077: 'cl' : return code '0x1'

Stop.


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

IRNT.P_CR_C_OB_VARIABLE - Build failed.
IRNT.P_CR_C_OB_VARIABLE - Roll back completed successfully.


Can anyone help me ?
Thanks in advance.

I think you need to download C compiler and follow the steps as in

http://www7b.software.ibm.com/dmdd/l...306haungs.html

Hope this helps.

I am getting the following error while trying to build Stored procedure

-- LOG FILE P7085890.log FOR PROCEDURE IRNT .P_CR_C_OUTBOUND_CORRES

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp\P7085890.sqc

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

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

-- CONTENTS OF C:\Program Files\Microsoft Visual Studio\VC98\Bin\VCVARS32.BAT

@echo off
rem
rem Root of Visual Developer Studio Common files.
set VSCommonDir=C:\PROGRA~1\Microsoft Visual Studio\Common

rem
rem Root of Visual Developer Studio installed files.
rem
set MSDevDir=C:\PROGRA~1\Microsoft Visual Studio\Common\msdev98

rem
rem Root of Visual C++ installed files.
rem
set MSVCDir=C:\PROGRA~1\Microsoft Visual Studio\VC98

rem
rem VcOsDir is used to help create either a Windows 95 or Windows NT specific path.
rem
set VcOsDir=WIN95
if "%OS%" == "Windows_NT" set VcOsDir=WINNT

rem
echo Setting environment for using Microsoft Visual C++ tools.
rem

if "%OS%" == "Windows_NT" set PATH=%MSDevDir%\BIN;%MSVCDir%\BIN;%VSCommonDir%\TO OLS\%VcOsDir%;%VSCommonDir%\TOOLS;%PATH%
if "%OS%" == "" set PATH="%MSDevDir%\BIN";"%MSVCDir%\BIN";"%VSCommonDi r%\TOOLS\%VcOsDir%";"%VSCommonDir%\TOOLS";"%windir %\SYSTEM";"%PATH%"
set INCLUDE=%MSVCDir%\ATL\INCLUDE;%MSVCDir%\INCLUDE;%M SVCDir%\MFC\INCLUDE;%INCLUDE%
set LIB=%MSVCDir%\LIB;%MSVCDir%\MFC\LIB;%LIB%

set VcOsDir=
set VSCommonDir=


-- CONTENTS OF C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp\P7085890.BAT

@echo on
set SQLROUTINE_FILENAME=P7085890
set db2path=C:\IBM\SQLLIB

-- COMPILATION COMMAND:

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


-- CONTENTS OF C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp\P7085890.def

LIBRARY P7085890
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8


-- COMPILATION MESSAGES FOR C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp\P7085890.c
-- C COMPILATION ERROR CODES: 0 0 2
Setting environment for using Microsoft Visual C++ tools.

C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp>set SQLROUTINE_FILENAME=P7085890

C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp>set db2path=C:\IBM\SQLLIB

C:\IBM\SQLLIB\function\routine\sqlproc\IRIN\IRNT\t mp>nmake /f C:\IBM\SQLLIB\function\routine\sqlproc.mak
cl -Ox -W2 -TC -D_X86_=1 -MD -I"C:\IBM\SQLLIB\include" P7085890.c /link -dll /out:P7085890.dll -def:P7085890.def "C:\IBM\SQLLIB\lib\db2api.lib"
P7085890.c
Microsoft (R) Incremental Linker Version 6.00.8168
Copyright (C) Microsoft Corp 1992-1998. All rights reserved.

LINK : fatal error LNK1104: cannot open file "C:\DOCUME~1\db2admin.ISCNSAPP2W\Local"

Microsoft (R) Program Maintenance Utility Version 6.00.8168.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.

Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 12.00.8168 for 80x86
Copyright (C) Microsoft Corp 1984-1998. All rights reserved.

NMAKE : fatal error U1077: 'cl' : return code '0x2'
Stop.

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