Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    6

    Unanswered: DB2 stored procedure compile error

    Hi ,

    When i am trying to build a stored procedure .I am getting the following errors :

    CAPIREADMIN.PROC_DELETE_VARIABLE - Build started.
    Create stored procedure returns -7032.

    -- LOG FILE P2181525.log FOR PROCEDURE CAPIREADMIN.PROC_DELETE_VARIABLE

    -- DB2_SQLROUTINE_PREPOPTS=

    -- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp\P2181525.sqc


    LINE MESSAGES FOR P2181525.sqc

    ------ --------------------------------------------------------------------

    SQL0060W The "C" precompiler is in progress.

    SQL0091W Precompilation or binding was ended with "0"

    errors and "0" warnings.


    -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sr_cpath.b at




    -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp\P2181525.BAT

    @echo on
    set SQLROUTINE_FILENAME=P2181525
    set db2path=C:\PROGRA~1\IBM\SQLLIB

    -- COMPILATION COMMAND:

    nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.ma k


    -- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp\P2181525.def

    LIBRARY P2181525
    EXPORTS _pgsjmp@8
    pgsjmp=_pgsjmp@8


    -- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp\P2181525.c
    -- C COMPILATION ERROR CODES: 0 0 1


    C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp>set SQLROUTINE_FILENAME=P2181525



    C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB



    C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CA PIRE\CAPIREADMIN\tmp>nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.ma k

    'nmake' is not recognized as an internal or external command,

    operable program or batch file.


    -- END OF LOG FILE (SQLCODE: -7032)

    CAPIREADMIN.PROC_DELETE_VARIABLE - Build failed.
    CAPIREADMIN.PROC_DELETE_VARIABLE - Roll back completed successfully.


    Please help me as it is urgent.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Do you have a C compiler on the DB2 server?
    Andy

Posting Permissions

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