create stored procedure failed UDB 7.2 : URGENT HELP needed !!!!!!

[mmisra]

Create Procedure failed--- URGENT ASAP
hi guys .. this is IMP and ASAP ...
i have :
1. Visual Studio .NET and UDB 7.2 enterprise edition server on my machine.
2. added db2admin in adminstrators group + updated the rights rtc
3. have modified the var for point to correct C complier file (viz DB2_SQLROUTINE_COMPILER_PATH & DB2_SQLROUTINE_COMPILE_COMMAND )
4. have made changes in the sqlproc.mak file setting DEBUG=YES

but still im not able to create & compile procedure.
here is the output i get

can anyone help me out ... urget help needed ..

*************************************
DB2ADMIN.SUM - Create stored procedure returns -7032.

DB2ADMIN.SUM:

*** BIND D:\PROGRA~1\SQLLIB\function\routine\sqlproc\TESTDB
\DB2ADMIN\tmp\P1439170.sqc ***



LINE MESSAGES FOR P1439170.sqc

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

SQL0060W The "C" precompiler is in progress.

SQL0091W Precompilation or binding was ended with "0"

errors and "0" warnings.



*** COMPILE D:\PROGRA~1\SQLLIB\function\routine\sqlproc\TESTDB
\DB2ADMIN\tmp\P1439170.c ***



DB2_SQLROUTINE_COMPILER_PATH=D:\PROGRA~1\Microsoft
Visual Studio .NET\Common7\Tools\vsvars32.bat



DB2_SQLROUTINE_COMPILE_COMMAND=cl -Od -W2 /TC -D_X86_=1 -I D:\PROGRA~1\SQLLIB\include SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def/out:SQLROUTINE_FILENAME.dll D:\PROGRA~1\SQLLIB\lib\db2api.lib



@SET VSINSTALLDIR=D:\Program Files\Microsoft Visual Studio .NET\Common7\IDE

@SET VCINSTALLDIR=D:\Program Files\Microsoft Visual Studio .NET

@SET FrameworkDir=C:\WINNT\Microsoft.NET\Framework

@SET FrameworkVersion=v1.0.3705

@SET FrameworkSDKDir=D:\Program Files\Microsoft Visual Studio .NET\FrameworkSDK

@rem Root of Visual Studio common files.



@if "%VSINSTALLDIR%"=="" goto Usage

@if "%VCINSTALLDIR%"=="" set VCINSTALLDIR=%VSINSTALLDIR%



@rem

@rem Root of Visual Studio ide installed files.

@rem

@set DevEnvDir=%VSINSTALLDIR%



@rem

@rem Root of Visual C++ installed files.

@rem

@set MSVCDir=%VCINSTALLDIR%\VC7



@rem

@echo Setting environment for using Microsoft Visual Studio .NET tools.

@echo (If you also have Visual C++ 6.0 installed and wish to use its tools

@echo from the command line, run vcvars32.bat for Visual C++ 6.0.)

@rem



@REM %VCINSTALLDIR%\Common7\Tools dir is added only for real setup.



@set PATH=%DevEnvDir%;%MSVCDir%\BIN;%VCINSTALLDIR%\Comm
on7\Tools;%VCINSTALLDIR%\Common7\Tools\bin\prerele
ase;%VCINSTALLDIR%\Common7\Tools\bin;%FrameworkSDK
Dir%\bin;%FrameworkDir%\%FrameworkVersion%;%PATH%;


@set INCLUDE=%MSVCDir%\ATLMFC\INCLUDE;%MSVCDir%\INCLUDE
;%MSVCDir%\PlatformSDK\include\prerelease;%MSVCDir
%\PlatformSDK\include;%FrameworkSDKDir%\include;%I
NCLUDE%

@set LIB=%MSVCDir%\ATLMFC\LIB;%MSVCDir%\LIB;%MSVCDir%\P
latformSDK\lib\prerelease;%MSVCDir%\PlatformSDK\li
b;%FrameworkSDKDir%\lib;%LIB%



@goto end



:Usage



@echo. VSINSTALLDIR variable is not set.

@echo.

@echo SYNTAX: %0



@goto end



:end



@echo on

set SQLROUTINE_FILENAME=P1439170

set db2path=D:\PROGRA~1\SQLLIB



cl -Od -W2 /TC -D_X86_=1 -I D:\PROGRA~1\SQLLIB\include P1439170.c /link -dll -def1439170.def/out1439170.dll D:\PROGRA~1\SQLLIB\lib\db2api.lib



*** D:\PROGRA~1\SQLLIB\function\routine\sqlproc\TESTDB
\DB2ADMIN\tmp\P1439170.def ***

LIBRARY P1439170

EXPORTS _pgsjmp@24

pgsjmp=_pgsjmp@24



Setting environment for using Microsoft Visual Studio .NET tools.

(If you also have Visual C++ 6.0 installed and wish to use its tools

from the command line, run vcvars32.bat for Visual C++ 6.0.)



D:\PROGRA~1\SQLLIB\function\routine\sqlproc\TESTDB
\DB2ADMIN\tmp>set SQLROUTINE_FILENAME=P1439170



D:\PROGRA~1\SQLLIB\function\routine\sqlproc\TESTDB
\DB2ADMIN\tmp>set db2path=D:\PROGRA~1\SQLLIB



D:\PROGRA~1\SQLLIB\function\routine\sqlproc\TESTDB
\DB2ADMIN\tmp>cl -Od -W2 /TC -D_X86_=1 -I D:\PROGRA~1\SQLLIB\include P1439170.c /link -dll -def1439170.def/out1439170.dll D:\PROGRA~1\SQLLIB\lib\db2api.lib

P1439170.c

Microsoft (R) Incremental Linker Version 7.00.9466

Copyright (C) Microsoft Corporation. All rights reserved.



/out1439170.exe

-dll

-def1439170.def/out1439170.dll

D:\PROGRA~1\SQLLIB\lib\db2api.lib

P1439170.obj

LINK : fatal error LNK1104: cannot open file 'P1439170.def/out1439170.dll'

LINK : fatal error LNK1141: failure during build of exports file



Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 13.00.9466 for 80x86

Copyright (C) Microsoft Corporation 1984-2001. All rights reserved.





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



SQL7032N SQL procedure "SUM" not created. Diagnostic file is "P1439170.log".

SQLSTATE=42904





DB2ADMIN.SUM - Build failed.

DB2ADMIN.SUM - Changes rolled back.

**************************************************
*****

thanx in ADVANCE ......

 

[cotaurus]

Have you checked your diagnostics file? Look for P1439170.log. There is probably a problem with the C compiler.