Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2006
    Posts
    13

    Post Unanswered: sqlcode: -7032 [error when creating stored procedure]

    Hi guys,

    i'm using the below statements in db2 8.1.6 [windows 2000]

    i'm using db2 development center to create a stored procedure ... but end up with the error
    _________________________________
    WEBUSER.insert_event_f - Build started.
    Create stored procedure returns -7032.

    -- LOG FILE P6460528.log FOR PROCEDURE WEBUSER .INSERT_EVENT_F

    -- DB2_SQLROUTINE_PREPOPTS=

    -- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\tmp\P6460528.sqc


    LINE MESSAGES FOR P6460528.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\CW REPOS\WEBUSER\tmp\P6460528.BAT
    @echo on
    set SQLROUTINE_FILENAME=P6460528
    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\CW REPOS\WEBUSER\tmp\P6460528.def
    LIBRARY P6460528
    EXPORTS _pgsjmp@8
    pgsjmp=_pgsjmp@8
    -- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\tmp\P6460528.c
    -- C COMPILATION ERROR CODES: 0 0 1
    C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\tmp>set SQLROUTINE_FILENAME=P6460528
    C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB
    C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\CW REPOS\WEBUSER\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)

    WEBUSER.insert_event_f - Build failed.
    WEBUSER.insert_event_f - Roll back completed successfully.
    ___________________________________

    i'm not really sure whats causing this error [as its not a systax error] - any help will be appreciated
    Last edited by lehare; 02-22-06 at 11:13. Reason: my first question seems to let people down :(

Posting Permissions

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