|
компилирование процедуры в DB2 7.1/7.2
|
|||
---|---|---|---|
#18+
Привет, кто может подсказать новичку? Пытаюсь откомпилировать процедуру из Stored Procedure Builder, но безуспешно. Повидимому проблема в настройках. log file ------------------------------------------------------------------- *** BIND C:\PROGRA~1\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp\P3411310.sqc *** LINE MESSAGES FOR P3411310.sqc ------ -------------------------------------------------------------------- SQL0060W The "C" precompiler is in progress. SQL0091W Precompilation or binding was ended with "0" errors and "0" warnings. *** COMPILE C:\PROGRA~1\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp\P3411310.c *** DB2_SQLROUTINE_COMPILER_PATH=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\MIAF9D~1\Common rem rem Root of Visual Developer Studio installed files. rem set MSDevDir=C:\PROGRA~1\MIAF9D~1\Common\msdev98 rem rem Root of Visual C++ installed files. rem set MSVCDir=C:\PROGRA~1\MIAF9D~1\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%\TOOLS\%VcOsDir%;%VSCommonDir%\TOOLS;%PATH% if "%OS%" == "" set PATH="%MSDevDir%\BIN";"%MSVCDir%\BIN";"%VSCommonDir%\TOOLS\%VcOsDir%";"%VSCommonDir%\TOOLS";"%windir%\SYSTEM";"%PATH%" set INCLUDE=%MSVCDir%\ATL\INCLUDE;%MSVCDir%\INCLUDE;%MSVCDir%\MFC\INCLUDE;%INCLUDE% set LIB=%MSVCDir%\LIB;%MSVCDir%\MFC\LIB;%LIB% set VcOsDir= set VSCommonDir= @echo on set SQLROUTINE_FILENAME=P3411310 set db2path=C:\PROGRA~1\SQLLIB nmake /f C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak *** C:\PROGRA~1\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp\P3411310.def *** LIBRARY P3411310 EXPORTS _pgsjmp@12 pgsjmp=_pgsjmp@12 Setting environment for using Microsoft Visual C++ tools. C:\PROGRA~1\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp>set SQLROUTINE_FILENAME=P3411310 C:\PROGRA~1\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp>set db2path=C:\PROGRA~1\SQLLIB C:\PROGRA~1\SQLLIB\function\routine\sqlproc\SAMPLE\DB2ADMIN\tmp>nmake /f C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak cl -Ox -W2 -TC -D_X86_=1 -I"C:\PROGRA~1\SQLLIB\include" P3411310.c /link -dll /out:P3411310.dll -def:P3411310.def "C:\PROGRA~1\SQLLIB\lib\db2api.lib" Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. NMAKE : fatal error U1077: 'cl' : return code '0xc0000139' Stop. ---------------------------------------------------------------------------- SQL7032N SQL procedure "" not created. Diagnostic file is "". ---------------------- Настройки DB2 db2set -all [e] DB2PATH=C:\Program Files\SQLLIB [e] DB2_SQLROUTINE_COMPILER_PATH=C:\Program Files\Microsoft Visual Studio\VC98\Bin\VCVARS32.BAT DB2INSTRPROF=C:\PROGRAM FILES\SQLLIB DB2COMM=TCPIP,NPIPE [g] DB2SYSTEM=RLLXP [g] DB2PATH=C:\Program Files\SQLLIB [g] DB2INSTDEF=DB2 [g] DB2COMM=TCPIP,NPIPE [g] DB2ADMINSERVER=DB2DAS00 Спасибо всем DB2 Guru :) ... |
|||
:
Нравится:
Не нравится:
|
|||
29.03.2005, 04:26 |
|
компилирование процедуры в DB2 7.1/7.2
|
|||
---|---|---|---|
#18+
Здравствуйте, в каталоге С:\Program Files\SQLLIB\function\routine\ создайте батник sr_cpath.bat с таким содержимым: @echo off set VCV6_DRIVE=c:\Program Files\Microsoft Visual Studio set include=%include%;%VCV6_DRIVE%\VC98\atl\include;%VCV6_DRIVE%\VC98\mfc\include;%VCV6_DRIVE%\VC98\include set lib=%lib%;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib set path=%path%;%VCV6_DRIVE%\Common\Tools\WinNT;%VCV6_DRIVE%\Common\MSDev98\Bin;%VCV6_DRIVE%\Common\Tools;%VCV6_DRIVE%\VC98\bin;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib потом сделайте db2set DB2_SQLROUTINE_COMPILER_PATH=С:\ProgramFiles\SQLLIB\function\routine\sr_cpath.bat ... |
|||
:
Нравится:
Не нравится:
|
|||
29.03.2005, 07:44 |
|
компилирование процедуры в DB2 7.1/7.2
|
|||
---|---|---|---|
#18+
Да, забыл. Потом инстанс надо перестартить. ... |
|||
:
Нравится:
Не нравится:
|
|||
29.03.2005, 08:01 |
|
компилирование процедуры в DB2 7.1/7.2
|
|||
---|---|---|---|
#18+
Thank you. It doesn't help. :( Looks like there is a problem with compiler. ... |
|||
:
Нравится:
Не нравится:
|
|||
29.03.2005, 19:28 |
|
компилирование процедуры в DB2 7.1/7.2
|
|||
---|---|---|---|
#18+
Проще скачать FP8 для 8-ки и не парится с компилятором. FP самоинсталируемый в 90 дневную триальную версию ... |
|||
:
Нравится:
Не нравится:
|
|||
31.03.2005, 11:30 |
|
компилирование процедуры в DB2 7.1/7.2
|
|||
---|---|---|---|
#18+
Your are rigth. Is it possible to upgrade version 7.2 to 8 to avoid a trial hassle? I saw fixes for versions 7.1 and 8, but I didn't see upgrade. Thanks ... |
|||
:
Нравится:
Не нравится:
|
|||
31.03.2005, 18:12 |
|
|
start [/forum/topic.php?fid=43&msg=32987228&tid=1605955]: |
0ms |
get settings: |
10ms |
get forum list: |
14ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
40ms |
get topic data: |
11ms |
get forum data: |
3ms |
get page messages: |
48ms |
get tp. blocked users: |
1ms |
others: | 265ms |
total: | 400ms |
0 / 0 |