Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    12

    Unanswered: DB2 Stored procedure

    Hi get this error when creating the stored procedure .


    [IBM][CLI Driver][DB2/NT] SQL7032N SQL procedure "proc_name" not created. Diagnostic file is "P1326180.log". SQLSTATE=42904


    Now people says you need to have MS C compiler installed on your machine.


    Now from where do i get exact compatible c compiler.
    Is n't it part of DB2 people to keep it for download on thier website or
    send c compiler along with their distribution....


    Atleast if any one have any idea please guide me as how to get this creating stored procedure running.....

    The procedure is created fine one by one using the DB2 Stored procedure builder but when i try to create the sp using my execuesql program it gives me above errorr...


    Regards
    Mahesh

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 Stored procedure

    For Windows, I'm sure IBM supports Visual C++ ... For other compilers IBM supports, check application building guide/appl. development guide ...

    DB2 is not shipped with any compiler ... neither do IBM feel it their responsibility to ship a compiler with DB2 ...

    Have you checked P1326180.log ... What does this say ?

    The most likely cause of the error is that your compiler path has not been set proerly ...

    HTH

    Cheers

    Sathyaram



    Originally posted by palanmahesh
    Hi get this error when creating the stored procedure .


    [IBM][CLI Driver][DB2/NT] SQL7032N SQL procedure "proc_name" not created. Diagnostic file is "P1326180.log". SQLSTATE=42904


    Now people says you need to have MS C compiler installed on your machine.


    Now from where do i get exact compatible c compiler.
    Is n't it part of DB2 people to keep it for download on thier website or
    send c compiler along with their distribution....


    Atleast if any one have any idea please guide me as how to get this creating stored procedure running.....

    The procedure is created fine one by one using the DB2 Stored procedure builder but when i try to create the sp using my execuesql program it gives me above errorr...


    Regards
    Mahesh

  3. #3
    Join Date
    May 2002
    Posts
    12

    Libc.lib error+stored procedure+db2+help need+urgent

    ok i got Visual 6++ install and running and now my problem is

    ####################
    ** PREPCOMPILE C:\PROGRA~1\SQLLIB\function\routine\sqlproc\UPGCAL YP\MAHESH\tmp\P4421790.sqc ***



    LINE MESSAGES FOR P4421790.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\UPGCAL YP\MAHESH\tmp\P4421790.c ***



    DB2_SQLROUTINE_COMPILER_PATH=C:\Program Files\Microsoft Visual Studio\VC98\Bin;





    @echo on

    set SQLROUTINE_FILENAME=P4421790

    set db2path=C:\PROGRA~1\SQLLIB



    nmake /f C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak



    *** C:\PROGRA~1\SQLLIB\function\routine\sqlproc\UPGCAL YP\MAHESH\tmp\P4421790.def ***

    LIBRARY P4421790

    EXPORTS _pgsjmp@24

    pgsjmp=_pgsjmp@24





    C:\PROGRA~1\SQLLIB\function\routine\sqlproc\UPGCAL YP\MAHESH\tmp>set SQLROUTINE_FILENAME=P4421790



    C:\PROGRA~1\SQLLIB\function\routine\sqlproc\UPGCAL YP\MAHESH\tmp>set db2path=C:\PROGRA~1\SQLLIB



    C:\PROGRA~1\SQLLIB\function\routine\sqlproc\UPGCAL YP\MAHESH\tmp>nmake /f C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak

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

    P4421790.c

    Microsoft (R) Incremental Linker Version 6.00.8168

    Copyright (C) Microsoft Corp 1992-1998. All rights reserved.



    /out:P4421790.exe

    -dll

    /out:P4421790.dll

    -def:P4421790.def

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

    P4421790.obj

    LINK : fatal error LNK1104: cannot open file "LIBC.lib"
    ###################
    I have libc.lib installled and proper library lib variable set..
    Regards
    Mahesh
    Senior DBA
    Calypso Technology

  4. #4
    Join Date
    Apr 2003
    Posts
    2

    Red face Same -- LINK ERROR Not Resolved YET!!!!!! HELP

    Hi Mahesh

    Did ur prob 'bout Link Error got resolved ?
    Im getting the same error.
    1st i was getting -7032, then i did the changes in the compiler path.
    Now im getting same error as u :

    LINK : fatal error LNK1104: cannot open file 'P1805410.def/out:P1805410.dll'
    LINK : fatal error LNK1141: failure during build of exports file

    I have Visual Studio .NET and UDB7.2 Enterprice Edition

    Can u pls help me out.

    Thanx in Advance
    Maneesh

Posting Permissions

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