Newbie Question - Compiling Stored Procedures on DB2 UDB v8.1.3
This is a discussion on Newbie Question - Compiling Stored Procedures on DB2 UDB v8.1.3 within the DB2 forums, part of the Database Server Software category; --> Hi, This is my first time with DB2 UDB We have installed the DB2 UDB v8.1.3 Enterprise Edition. We ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 07:54 PM
| ||||
| ||||
 Newbie Question - Compiling Stored Procedures on DB2 UDB v8.1.3 Hi, This is my first time with DB2 UDB We have installed the DB2 UDB v8.1.3 Enterprise Edition. We need to write Stored Procedures for our Project, for that we found that we need to install the DB2 UDB Application Development Client. After installing the required software, when trying to build the Stored Procedure we get the following error - DB2ADMIN.PROCEDURE1 - Build started. Create stored procedure returns -7032. -- LOG FILE P5514620.log FOR PROCEDURE DB2ADMIN.PROCEDURE1 -- DB2_SQLROUTINE_PREPOPTS= -- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P5514620.sqc LINE MESSAGES FOR P5514620.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:\Progra~1\Micros~3\ VC98\Bin\VCVARS32.bat -- DB2_SQLROUTINE_COMPILE_COMMAND=C:\Progra~1\Micros~ 3\VC98\Bin\cl -Od -W2 /TC -D_X86_=1 -IC:\Progra~1\SQLLIB\include SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def /out:SQLROUTINE_FILENAME.dll C:\Progra~1\SQLLIB\lib\db2api.lib -- CONTENTS OF C:\Progra~1\Micros~3\VC98\Bin\VCVARS32.bat @echo offremrem Root of Visual Developer Studio Common files.set VSCommonDir=C:\PROGRA~1\MICROS~3\Commonremrem Root of Visual Developer Studio installed files.remset MSDevDir=C:\PROGRA~1\MICROS~3\Common\msdev98remrem Root of Visual C++ installed files.remset MSVCDir=C:\PROGRA~1\MICROS~3\VC98remrem VcOsDir is used to help create either a Windows 95 or Windows NT specific path.remset VcOsDir=WIN95if "%OS%" == "Windows_NT" set VcOsDir=WINNTremecho Setting environment for using Microsoft Visual C++ tools.remif "%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:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P5514620.BAT @echo on set SQLROUTINE_FILENAME=P5514620 set db2path=C:\PROGRA~1\IBM\SQLLIB -- COMPILATION COMMAND: C:\Progra~1\Micros~3\VC98\Bin\cl -Od -W2 /TC -D_X86_=1 -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P5514620.def LIBRARY P5514620 EXPORTS _pgsjmp@8 pgsjmp=_pgsjmp@8 -- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P5514620.c -- C COMPILATION ERROR CODES: 0 0 2 Setting environment for using Microsoft Visual C++ tools.C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlp roc\ADDRESS1\DB2ADMIN\tmp>set SQLROUTINE_FILENAME=P5514620 C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>C:\Progra~1\Micros~3\VC98\Bin\ cl -Od -W2 /TC -D_X86_=1 -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib P5514620.cC:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltyp es.h(252) : error C2061: syntax error : identifier 'DWORD'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error C2061: syntax error : identifier 'Data2'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error C2059: syntax error : ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 4) : error C2061: syntax error : identifier 'Data3'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(254) : error C2059: syntax error : ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2061: syntax error : identifier 'Data4'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(255) : error C2059: syntax error : ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2059: syntax error : '['C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(256) : error C2059: syntax error : '}'Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 12.00.8168 for 80x86Copyright (C) Microsoft Corp 1984-1998. All rights reserved. -- END OF LOG FILE (SQLCODE: -7032) DB2ADMIN.PROCEDURE1 - Build failed. DB2ADMIN.PROCEDURE1 - Roll back completed successfully. PLEASE HELP Thanks in Advance Manish      |
|
02-26-2008, 07:54 PM
| |||
| |||
| Re: Newbie Question - Compiling Stored Procedures on DB2 UDB v8.1.3 Hi Manish, It looks like you have specified C:\Progra~1\SQLLIB as the location of you sqllib, however, from this text: > -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 20.BAT it looks like it should be: C:\Progra~1\IBM\SQLLIB (the IBM is missing) -- Garfield A. Lewis DB2 UDB Development, IBM Canada Laboratory "Manish" <manishm@hexaware.com> wrote in message news:6784180d.0407120231.60efdc17@posting.google.c om... > Hi, > > This is my first time with DB2 UDB > > We have installed the DB2 UDB v8.1.3 Enterprise Edition. > We need to write Stored Procedures for our Project, for that we found > that we need to install the DB2 UDB Application > > Development Client. > > After installing the required software, when trying to build the > Stored Procedure we get the following error - > > > DB2ADMIN.PROCEDURE1 - Build started. > Create stored procedure returns -7032. > > -- LOG FILE P5514620.log FOR PROCEDURE DB2ADMIN.PROCEDURE1 > > -- DB2_SQLROUTINE_PREPOPTS= > > -- PREP/BIND MESSAGES FOR > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 20.sqc > LINE MESSAGES FOR P5514620.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:\Progra~1\Micros~3\ VC98\Bin\VCVARS32.bat > > -- DB2_SQLROUTINE_COMPILE_COMMAND=C:\Progra~1\Micros~ 3\VC98\Bin\cl -Od > -W2 /TC -D_X86_=1 -IC:\Progra~1\SQLLIB\include > > SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def > /out:SQLROUTINE_FILENAME.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > -- CONTENTS OF C:\Progra~1\Micros~3\VC98\Bin\VCVARS32.bat > > @echo offremrem Root of Visual Developer Studio Common files.set > VSCommonDir=C:\PROGRA~1\MICROS~3\Commonremrem Root of Visual > > Developer Studio installed files.remset > MSDevDir=C:\PROGRA~1\MICROS~3\Common\msdev98remrem Root of Visual C++ > installed > > files.remset MSVCDir=C:\PROGRA~1\MICROS~3\VC98remrem VcOsDir is used > to help create either a Windows 95 or Windows NT > > specific path.remset VcOsDir=WIN95if "%OS%" == "Windows_NT" set > VcOsDir=WINNTremecho Setting environment for using Microsoft > > Visual C++ tools.remif "%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%";"%VSCo mmonDir%\TOOLS";"%windir%\SYSTEM";"%PATH%"set > > INCLUDE=%MSVCDir%\ATL\INCLUDE;%MSVCDir%\INCLUDE;%M SVCDir%\MFC\INCLUDE;%INCLU DE%set > > LIB=%MSVCDir%\LIB;%MSVCDir%\MFC\LIB;%LIB%set VcOsDir=set VSCommonDir= > -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 20.BAT > > @echo on > set SQLROUTINE_FILENAME=P5514620 > set db2path=C:\PROGRA~1\IBM\SQLLIB > > -- COMPILATION COMMAND: > > C:\Progra~1\Micros~3\VC98\Bin\cl -Od -W2 /TC -D_X86_=1 > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > > -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 20.def > > LIBRARY P5514620 > EXPORTS _pgsjmp@8 > pgsjmp=_pgsjmp@8 > > > -- COMPILATION MESSAGES FOR > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 20.c > -- C COMPILATION ERROR CODES: 0 0 2 > Setting environment for using Microsoft Visual C++ > > tools.C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlp roc\ADDRESS1\DB2ADMIN\tmp> set > SQLROUTINE_FILENAME=P5514620 > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>set > db2path=C:\PROGRA~1\IBM\SQLLIB > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>C:\Pro gra~1\Micros~3\VC98\Bin\cl > -Od -W2 /TC -D_X86_=1 > > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > P5514620.cC:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltyp es.h(252) : error > C2061: syntax error : identifier > > 'DWORD'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > C2061: syntax error : identifier > > 'Data2'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > C2059: syntax error : > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 4) : error C2061: > syntax error : identifier > > 'Data3'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(254) : error > C2059: syntax error : > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2061: > syntax error : identifier > > 'Data4'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(255) : error > C2059: syntax error : > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2059: > syntax error : > > '['C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(256) : error C2059: > syntax error : '}'Microsoft (R) 32-bit C/C++ Optimizing > > Compiler Version 12.00.8168 for 80x86Copyright (C) Microsoft Corp > 1984-1998. All rights reserved. > -- END OF LOG FILE (SQLCODE: -7032) > DB2ADMIN.PROCEDURE1 - Build failed. > DB2ADMIN.PROCEDURE1 - Roll back completed successfully. > > > > PLEASE HELP > > Thanks in Advance > Manish |
|
02-26-2008, 07:54 PM
| |||
| |||
| Re: Newbie Question - Compiling Stored Procedures on DB2 UDB v8.1.3 You need to have one of the supported C compilers installed and configured correctly if you want to compile SQL stored procedures in DB2. I can't guide you through the details myself but I know there have been several threads on this topic within the newsgroup; a Google newsgroup search should help you find the details you need. There is also documentation about the specific compilers you need in the DB2 manuals. Another alternative is to write Java stored procedures; DB2 comes with JDBC drivers and Java compilers so that you don't need any other components. This could save you some money since the supported compilers are a few hundred dollars. Rhino "Manish" <manishm@hexaware.com> wrote in message news:6784180d.0407120231.60efdc17@posting.google.c om... > Hi, > > This is my first time with DB2 UDB > > We have installed the DB2 UDB v8.1.3 Enterprise Edition. > We need to write Stored Procedures for our Project, for that we found > that we need to install the DB2 UDB Application > > Development Client. > > After installing the required software, when trying to build the > Stored Procedure we get the following error - > > > DB2ADMIN.PROCEDURE1 - Build started. > Create stored procedure returns -7032. > > -- LOG FILE P5514620.log FOR PROCEDURE DB2ADMIN.PROCEDURE1 > > -- DB2_SQLROUTINE_PREPOPTS= > > -- PREP/BIND MESSAGES FOR > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 20.sqc > LINE MESSAGES FOR P5514620.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:\Progra~1\Micros~3\ VC98\Bin\VCVARS32.bat > > -- DB2_SQLROUTINE_COMPILE_COMMAND=C:\Progra~1\Micros~ 3\VC98\Bin\cl -Od > -W2 /TC -D_X86_=1 -IC:\Progra~1\SQLLIB\include > > SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def > /out:SQLROUTINE_FILENAME.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > -- CONTENTS OF C:\Progra~1\Micros~3\VC98\Bin\VCVARS32.bat > > @echo offremrem Root of Visual Developer Studio Common files.set > VSCommonDir=C:\PROGRA~1\MICROS~3\Commonremrem Root of Visual > > Developer Studio installed files.remset > MSDevDir=C:\PROGRA~1\MICROS~3\Common\msdev98remrem Root of Visual C++ > installed > > files.remset MSVCDir=C:\PROGRA~1\MICROS~3\VC98remrem VcOsDir is used > to help create either a Windows 95 or Windows NT > > specific path.remset VcOsDir=WIN95if "%OS%" == "Windows_NT" set > VcOsDir=WINNTremecho Setting environment for using Microsoft > > Visual C++ tools.remif "%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%";"%VSCo mmonDir%\TOOLS";"%windir%\SYSTEM";"%PATH%"set > > INCLUDE=%MSVCDir%\ATL\INCLUDE;%MSVCDir%\INCLUDE;%M SVCDir%\MFC\INCLUDE;%INCLU DE%set > > LIB=%MSVCDir%\LIB;%MSVCDir%\MFC\LIB;%LIB%set VcOsDir=set VSCommonDir= > -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 20.BAT > > @echo on > set SQLROUTINE_FILENAME=P5514620 > set db2path=C:\PROGRA~1\IBM\SQLLIB > > -- COMPILATION COMMAND: > > C:\Progra~1\Micros~3\VC98\Bin\cl -Od -W2 /TC -D_X86_=1 > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > > -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 20.def > > LIBRARY P5514620 > EXPORTS _pgsjmp@8 > pgsjmp=_pgsjmp@8 > > > -- COMPILATION MESSAGES FOR > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 20.c > -- C COMPILATION ERROR CODES: 0 0 2 > Setting environment for using Microsoft Visual C++ > > tools.C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlp roc\ADDRESS1\DB2ADMIN\tmp> set > SQLROUTINE_FILENAME=P5514620 > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>set > db2path=C:\PROGRA~1\IBM\SQLLIB > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>C:\Pro gra~1\Micros~3\VC98\Bin\cl > -Od -W2 /TC -D_X86_=1 > > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > P5514620.cC:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltyp es.h(252) : error > C2061: syntax error : identifier > > 'DWORD'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > C2061: syntax error : identifier > > 'Data2'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > C2059: syntax error : > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 4) : error C2061: > syntax error : identifier > > 'Data3'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(254) : error > C2059: syntax error : > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2061: > syntax error : identifier > > 'Data4'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(255) : error > C2059: syntax error : > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2059: > syntax error : > > '['C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(256) : error C2059: > syntax error : '}'Microsoft (R) 32-bit C/C++ Optimizing > > Compiler Version 12.00.8168 for 80x86Copyright (C) Microsoft Corp > 1984-1998. All rights reserved. > -- END OF LOG FILE (SQLCODE: -7032) > DB2ADMIN.PROCEDURE1 - Build failed. > DB2ADMIN.PROCEDURE1 - Roll back completed successfully. > > > > PLEASE HELP > > Thanks in Advance > Manish |
|
02-26-2008, 07:57 PM
| |||
| |||
| Re: Newbie Question - Compiling Stored Procedures on DB2 UDB v8.1.3 Hi Garfield, I have specified C:\Progra~1\IBM\SQLLIB as the location of SQLLIB. I also want to add, that we are using MS Visual C++ as the compiler We still have not been able to find any workaround to compiling our procs. Please suggest. Would appreciate if you guide us to any documentation that would guide step-by-step on this. THANKS! Manish "Garfield Lewis" <galewis@SPAM-NO-MOREca.ibm.com> wrote in message news:<ccu3c5$g4f$1@hanover.torolab.ibm.com>... > Hi Manish, > > It looks like you have specified C:\Progra~1\SQLLIB as the location of you > sqllib, however, from this text: > > > -- CONTENTS OF > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.BAT > > it looks like it should be: C:\Progra~1\IBM\SQLLIB (the IBM is missing) > > -- > Garfield A. Lewis > DB2 UDB Development, > IBM Canada Laboratory > > > "Manish" <manishm@hexaware.com> wrote in message > news:6784180d.0407120231.60efdc17@posting.google.c om... > > Hi, > > > > This is my first time with DB2 UDB > > > > We have installed the DB2 UDB v8.1.3 Enterprise Edition. > > We need to write Stored Procedures for our Project, for that we found > > that we need to install the DB2 UDB Application > > > > Development Client. > > > > After installing the required software, when trying to build the > > Stored Procedure we get the following error - > > > > > > DB2ADMIN.PROCEDURE1 - Build started. > > Create stored procedure returns -7032. > > > > -- LOG FILE P5514620.log FOR PROCEDURE DB2ADMIN.PROCEDURE1 > > > > -- DB2_SQLROUTINE_PREPOPTS= > > > > -- PREP/BIND MESSAGES FOR > > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.sqc > > LINE MESSAGES FOR P5514620.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:\Progra~1\Micros~3\ VC98\Bin\VCVARS32.bat > > > > -- DB2_SQLROUTINE_COMPILE_COMMAND=C:\Progra~1\Micros~ 3\VC98\Bin\cl -Od > > -W2 /TC -D_X86_=1 -IC:\Progra~1\SQLLIB\include > > > > SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def > > /out:SQLROUTINE_FILENAME.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > > > -- CONTENTS OF C:\Progra~1\Micros~3\VC98\Bin\VCVARS32.bat > > > > @echo offremrem Root of Visual Developer Studio Common files.set > > VSCommonDir=C:\PROGRA~1\MICROS~3\Commonremrem Root of Visual > > > > Developer Studio installed files.remset > > MSDevDir=C:\PROGRA~1\MICROS~3\Common\msdev98remrem Root of Visual C++ > > installed > > > > files.remset MSVCDir=C:\PROGRA~1\MICROS~3\VC98remrem VcOsDir is used > > to help create either a Windows 95 or Windows NT > > > > specific path.remset VcOsDir=WIN95if "%OS%" == "Windows_NT" set > > VcOsDir=WINNTremecho Setting environment for using Microsoft > > > > Visual C++ tools.remif "%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%";"%VSCo > mmonDir%\TOOLS";"%windir%\SYSTEM";"%PATH%"set > > > > > INCLUDE=%MSVCDir%\ATL\INCLUDE;%MSVCDir%\INCLUDE;%M SVCDir%\MFC\INCLUDE;%INCLU > DE%set > > > > LIB=%MSVCDir%\LIB;%MSVCDir%\MFC\LIB;%LIB%set VcOsDir=set VSCommonDir= > > -- CONTENTS OF > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.BAT > > > > @echo on > > set SQLROUTINE_FILENAME=P5514620 > > set db2path=C:\PROGRA~1\IBM\SQLLIB > > > > -- COMPILATION COMMAND: > > > > C:\Progra~1\Micros~3\VC98\Bin\cl -Od -W2 /TC -D_X86_=1 > > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > > > > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > > > > > -- CONTENTS OF > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.def > > > > LIBRARY P5514620 > > EXPORTS _pgsjmp@8 > > pgsjmp=_pgsjmp@8 > > > > > > -- COMPILATION MESSAGES FOR > > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.c > > -- C COMPILATION ERROR CODES: 0 0 2 > > Setting environment for using Microsoft Visual C++ > > > > > tools.C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlp roc\ADDRESS1\DB2ADMIN\tmp> > set > > SQLROUTINE_FILENAME=P5514620 > > > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>set > > db2path=C:\PROGRA~1\IBM\SQLLIB > > > > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>C:\Pro > gra~1\Micros~3\VC98\Bin\cl > > -Od -W2 /TC -D_X86_=1 > > > > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > > > P5514620.cC:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltyp es.h(252) : error > > C2061: syntax error : identifier > > > > 'DWORD'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > > C2061: syntax error : identifier > > > > 'Data2'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > > C2059: syntax error : > > > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 4) : error C2061: > > syntax error : identifier > > > > 'Data3'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(254) : error > > C2059: syntax error : > > > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2061: > > syntax error : identifier > > > > 'Data4'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(255) : error > > C2059: syntax error : > > > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2059: > > syntax error : > > > > '['C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(256) : error C2059: > > syntax error : '}'Microsoft (R) 32-bit C/C++ Optimizing > > > > Compiler Version 12.00.8168 for 80x86Copyright (C) Microsoft Corp > > 1984-1998. All rights reserved. > > -- END OF LOG FILE (SQLCODE: -7032) > > DB2ADMIN.PROCEDURE1 - Build failed. > > DB2ADMIN.PROCEDURE1 - Roll back completed successfully. > > > > > > > > PLEASE HELP > > > > Thanks in Advance > > Manish |
|
02-26-2008, 07:57 PM
| |||
| |||
| Re: Newbie Question - Compiling Stored Procedures on DB2 UDB v8.1.3 Manish wrote: > Hi, > > This is my first time with DB2 UDB > > We have installed the DB2 UDB v8.1.3 Enterprise Edition. > We need to write Stored Procedures for our Project, for that we found > that we need to install the DB2 UDB Application > > Development Client. > > After installing the required software, when trying to build the > Stored Procedure we get the following error - > > > DB2ADMIN.PROCEDURE1 - Build started. > Create stored procedure returns -7032. > > -- LOG FILE P5514620.log FOR PROCEDURE DB2ADMIN.PROCEDURE1 > > -- DB2_SQLROUTINE_PREPOPTS= > > -- PREP/BIND MESSAGES FOR > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P5514620.sqc > LINE MESSAGES FOR P5514620.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:\Progra~1\Micros~3\ VC98\Bin\VCVARS32.bat > > -- DB2_SQLROUTINE_COMPILE_COMMAND=C:\Progra~1\Micros~ 3\VC98\Bin\cl -Od > -W2 /TC -D_X86_=1 -IC:\Progra~1\SQLLIB\include > > SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def > /out:SQLROUTINE_FILENAME.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > -- CONTENTS OF C:\Progra~1\Micros~3\VC98\Bin\VCVARS32.bat > > @echo offremrem Root of Visual Developer Studio Common files.set > VSCommonDir=C:\PROGRA~1\MICROS~3\Commonremrem Root of Visual > > Developer Studio installed files.remset > MSDevDir=C:\PROGRA~1\MICROS~3\Common\msdev98remrem Root of Visual C++ > installed > > files.remset MSVCDir=C:\PROGRA~1\MICROS~3\VC98remrem VcOsDir is used > to help create either a Windows 95 or Windows NT > > specific path.remset VcOsDir=WIN95if "%OS%" == "Windows_NT" set > VcOsDir=WINNTremecho Setting environment for using Microsoft > > Visual C++ tools.remif "%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:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P5514620.BAT > > @echo on > set SQLROUTINE_FILENAME=P5514620 > set db2path=C:\PROGRA~1\IBM\SQLLIB > > -- COMPILATION COMMAND: > > C:\Progra~1\Micros~3\VC98\Bin\cl -Od -W2 /TC -D_X86_=1 > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > > -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P5514620.def > > LIBRARY P5514620 > EXPORTS _pgsjmp@8 > pgsjmp=_pgsjmp@8 > > > -- COMPILATION MESSAGES FOR > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P5514620.c > -- C COMPILATION ERROR CODES: 0 0 2 > Setting environment for using Microsoft Visual C++ > > tools.C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlp roc\ADDRESS1\DB2ADMIN\tmp>set > SQLROUTINE_FILENAME=P5514620 > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>set > db2path=C:\PROGRA~1\IBM\SQLLIB > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>C:\Progra~1\Micros~3\VC98\Bin\ cl > -Od -W2 /TC -D_X86_=1 > > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > P5514620.cC:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltyp es.h(252) : error > C2061: syntax error : identifier > > 'DWORD'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > C2061: syntax error : identifier > > 'Data2'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > C2059: syntax error : > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 4) : error C2061: > syntax error : identifier > > 'Data3'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(254) : error > C2059: syntax error : > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2061: > syntax error : identifier > > 'Data4'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(255) : error > C2059: syntax error : > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2059: > syntax error : > > '['C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(256) : error C2059: > syntax error : '}'Microsoft (R) 32-bit C/C++ Optimizing > > Compiler Version 12.00.8168 for 80x86Copyright (C) Microsoft Corp > 1984-1998. All rights reserved. > -- END OF LOG FILE (SQLCODE: -7032) > DB2ADMIN.PROCEDURE1 - Build failed. > DB2ADMIN.PROCEDURE1 - Roll back completed successfully. > > > > PLEASE HELP > > Thanks in Advance > Manish Can you post the text of stored procedure you are having problem with? (including CREATE PROCEDURE ... lines) Jan M. Nelken |
|
02-26-2008, 07:58 PM
| ||||
| ||||
| Re: Newbie Question - Compiling Stored Procedures on DB2 UDB v8.1.3 Hi Garfield, We finally got the Procedure working. It seems we had goofed up with the C compiler configuration. it seems everything is now in place. THANKS! Manish "Garfield Lewis" <galewis@SPAM-NO-MOREca.ibm.com> wrote in message news:<ccu3c5$g4f$1@hanover.torolab.ibm.com>... > Hi Manish, > > It looks like you have specified C:\Progra~1\SQLLIB as the location of you > sqllib, however, from this text: > > > -- CONTENTS OF > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.BAT > > it looks like it should be: C:\Progra~1\IBM\SQLLIB (the IBM is missing) > > -- > Garfield A. Lewis > DB2 UDB Development, > IBM Canada Laboratory > > > "Manish" <manishm@hexaware.com> wrote in message > news:6784180d.0407120231.60efdc17@posting.google.c om... > > Hi, > > > > This is my first time with DB2 UDB > > > > We have installed the DB2 UDB v8.1.3 Enterprise Edition. > > We need to write Stored Procedures for our Project, for that we found > > that we need to install the DB2 UDB Application > > > > Development Client. > > > > After installing the required software, when trying to build the > > Stored Procedure we get the following error - > > > > > > DB2ADMIN.PROCEDURE1 - Build started. > > Create stored procedure returns -7032. > > > > -- LOG FILE P5514620.log FOR PROCEDURE DB2ADMIN.PROCEDURE1 > > > > -- DB2_SQLROUTINE_PREPOPTS= > > > > -- PREP/BIND MESSAGES FOR > > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.sqc > > LINE MESSAGES FOR P5514620.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:\Progra~1\Micros~3\ VC98\Bin\VCVARS32.bat > > > > -- DB2_SQLROUTINE_COMPILE_COMMAND=C:\Progra~1\Micros~ 3\VC98\Bin\cl -Od > > -W2 /TC -D_X86_=1 -IC:\Progra~1\SQLLIB\include > > > > SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def > > /out:SQLROUTINE_FILENAME.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > > > -- CONTENTS OF C:\Progra~1\Micros~3\VC98\Bin\VCVARS32.bat > > > > @echo offremrem Root of Visual Developer Studio Common files.set > > VSCommonDir=C:\PROGRA~1\MICROS~3\Commonremrem Root of Visual > > > > Developer Studio installed files.remset > > MSDevDir=C:\PROGRA~1\MICROS~3\Common\msdev98remrem Root of Visual C++ > > installed > > > > files.remset MSVCDir=C:\PROGRA~1\MICROS~3\VC98remrem VcOsDir is used > > to help create either a Windows 95 or Windows NT > > > > specific path.remset VcOsDir=WIN95if "%OS%" == "Windows_NT" set > > VcOsDir=WINNTremecho Setting environment for using Microsoft > > > > Visual C++ tools.remif "%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%";"%VSCo > mmonDir%\TOOLS";"%windir%\SYSTEM";"%PATH%"set > > > > > INCLUDE=%MSVCDir%\ATL\INCLUDE;%MSVCDir%\INCLUDE;%M SVCDir%\MFC\INCLUDE;%INCLU > DE%set > > > > LIB=%MSVCDir%\LIB;%MSVCDir%\MFC\LIB;%LIB%set VcOsDir=set VSCommonDir= > > -- CONTENTS OF > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.BAT > > > > @echo on > > set SQLROUTINE_FILENAME=P5514620 > > set db2path=C:\PROGRA~1\IBM\SQLLIB > > > > -- COMPILATION COMMAND: > > > > C:\Progra~1\Micros~3\VC98\Bin\cl -Od -W2 /TC -D_X86_=1 > > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > > > > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > > > > > -- CONTENTS OF > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.def > > > > LIBRARY P5514620 > > EXPORTS _pgsjmp@8 > > pgsjmp=_pgsjmp@8 > > > > > > -- COMPILATION MESSAGES FOR > > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp\P55146 > 20.c > > -- C COMPILATION ERROR CODES: 0 0 2 > > Setting environment for using Microsoft Visual C++ > > > > > tools.C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlp roc\ADDRESS1\DB2ADMIN\tmp> > set > > SQLROUTINE_FILENAME=P5514620 > > > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>set > > db2path=C:\PROGRA~1\IBM\SQLLIB > > > > > C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\AD DRESS1\DB2ADMIN\tmp>C:\Pro > gra~1\Micros~3\VC98\Bin\cl > > -Od -W2 /TC -D_X86_=1 > > > > -IC:\Progra~1\SQLLIB\include P5514620.c /link -dll -def:P5514620.def > > /out:P5514620.dll C:\Progra~1\SQLLIB\lib\db2api.lib > > > > P5514620.cC:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltyp es.h(252) : error > > C2061: syntax error : identifier > > > > 'DWORD'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > > C2061: syntax error : identifier > > > > 'Data2'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(253) : error > > C2059: syntax error : > > > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 4) : error C2061: > > syntax error : identifier > > > > 'Data3'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(254) : error > > C2059: syntax error : > > > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2061: > > syntax error : identifier > > > > 'Data4'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes. h(255) : error > > C2059: syntax error : > > > > ';'C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(25 5) : error C2059: > > syntax error : > > > > '['C:\PROGRA~1\MICROS~3\VC98\INCLUDE\sqltypes.h(256) : error C2059: > > syntax error : '}'Microsoft (R) 32-bit C/C++ Optimizing > > > > Compiler Version 12.00.8168 for 80x86Copyright (C) Microsoft Corp > > 1984-1998. All rights reserved. > > -- END OF LOG FILE (SQLCODE: -7032) > > DB2ADMIN.PROCEDURE1 - Build failed. > > DB2ADMIN.PROCEDURE1 - Roll back completed successfully. > > > > > > > > PLEASE HELP > > > > Thanks in Advance > > Manish |
Linear Mode
