If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Problem while trying to build SQL Stored Procedure

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-14-03, 00:22
ytamhane ytamhane is offline
Registered User
 
Join Date: Nov 2003
Posts: 3
Problem while trying to build SQL Stored Procedure

Hi,
I have VC++ 6.0 compiler on the DB2 Server. I am using DB2 UDB v8.1. While trying to build SQL Stored procedure, I get the following message. Can anyone help ?


-- 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)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On