Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: Problem while trying to build the Stored procedure

    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.

  2. #2
    Join Date
    Oct 2003
    Posts
    18
    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.

  3. #3
    Join Date
    Nov 2003
    Posts
    3

    SQL Stored Procedure Problems

    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •