Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2008
    Posts
    3

    Unanswered: SQL7032N error while building stored procedure

    Hi All,

    Am getting a SQL7032N error after installing the C compiler(Visual C++ 9.0 edition). The error as seen in the diagnostic file points to nmake as the snapshot below

    C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\DB2ADMIN\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.


    In response to this, have set registry variable DB2_SQLROUTINE_COMPILER_PATH to point to the batch file that sets up the C compiler environment as below

    db2set DB2_SQLROUTINE_COMPILER_PATH="C:\Program Files\Microsoft Visual Studio 9.0\VC\bin\vcvars32.bat"

    Inspite of this am hitting the same SQL7032N error. Iam using DB2 UDB version 8.1 personal edition on Windows XP environment. Please help me.

    Thanks
    Nds

  2. #2
    Join Date
    Jul 2008
    Posts
    3
    Hi,

    After rebooting my system on setting the path to point to nmake, am hitting upon the below error

    Error: SQL7032N SQL procedure "SP_PRO_LOGGING" not created. Diagnostic file is "P6362787.log". SQLSTATE=42904

    (State: 42904, Native Code: FFFFE488)

    The diagnostic file reads

    NMAKE: fatal error U1077: '"C:\Program Files\Microsoft Visual Studio 9.0\VC\bin\cl.EXE"' : return code '0xc0000135'

    Stop.

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

    Thanks
    Nds

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Different solution: move to DB2 V9 or DB2 v8.2. The requirement to have a C/C++ compiler was removed for those releases and those issues just vanish.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jul 2008
    Posts
    3

    SQL7032N error while building stored procedure

    Well..wouldn't be able to move to DB2 v8.2 or v9 at this point of time since the work is half the way..

    Would you be able to shed some light on the fatal error on NMAKE that am getting.


    Thanks

Posting Permissions

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