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

    Unanswered: Cannot create stored procedure, error SQL7032N

    I am new To UDB and when I try to build a stored procedure using stored procedure wizard, I get following error.

    Can someone please help me?

    ERROR:

    ADMINISTRATOR.USERPROC - Create stored procedure returns -7032.

    ADMINISTRATOR.USERPROC:

    *** BIND C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINIST RATOR\tmp\P4833340.sqc ***



    LINE MESSAGES FOR P4833340.sqc

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

    SQL0060W The "C" precompiler is in progress.

    SQL0091W Precompilation or binding was ended with "0"

    errors and "0" warnings.



    *** COMPILE C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINIST RATOR\tmp\P4833340.c ***


    @echo off

    REM set VCV6_DRIVE=c:\Microsoft Visual Studio

    REM set include=%include%;%VCV6_DRIVE%\VC98\atl\include;%V CV6_DRIVE%\VC98\mfc\include;%VCV6_DRIVE%\VC98\incl ude

    REM set lib=%lib%;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\V C98\lib

    REM set path=%path%;%VCV6_DRIVE%\Common\Tools\WinNT;%VCV6_ DRIVE%\Common\MSDev98\Bin;%VCV6_DRIVE%\Common\Tool s;%VCV6_DRIVE%\VC98\bin;%VCV6_DRIVE%\VC98\mfc\lib; %VCV6_DRIVE%\VC98\lib



    @echo off

    REM set VCV5_DRIVE=c:\Program Files\devstudio

    REM set include=%include%;%VCV5_DRIVE%\vc\include;%VCV5_DR IVE%\vc\atl\include;%VCV5_DRIVE%\vc\mfc\include

    REM set lib=%lib%;%VCV5_DRIVE%\vc\lib;%VCV5_DRIVE%\vc\mfc\ lib

    REM set path=%path%;%VCV5_DRIVE%\sharedide\bin\ide;%VCV5_D RIVE%\sharedide\bin;%VCV5_DRIVE%\vc\bin


    @echo on

    set SQLROUTINE_FILENAME=P4833340

    set db2path=C:\SQLLIB



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



    *** C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINIST RATOR\tmp\P4833340.def ***

    LIBRARY P4833340

    EXPORTS _pgsjmp@4

    pgsjmp=_pgsjmp@4



    C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINIST RATOR\tmp>set SQLROUTINE_FILENAME=P4833340



    C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINIST RATOR\tmp>set db2path=C:\SQLLIB



    C:\SQLLIB\function\routine\sqlproc\SAMPLE\ADMINIST RATOR\tmp>nmake /f C:\SQLLIB\function\routine\sqlproc.mak



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

    operable program or batch file.



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



    SQL7032N SQL procedure "USERPROC" not created. Diagnostic file is

    "P4833340.log". SQLSTATE=42904





    ADMINISTRATOR.USERPROC - Build failed.

    ADMINISTRATOR.USERPROC - Changes rolled back.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You need to have a C compiler loaded in order to create
    Stored procedures.

    Andy

  3. #3
    Join Date
    Oct 2002
    Location
    orlando, fl
    Posts
    3
    you need to have Visual C++ installed..
    then edit <db2home>/function/routine/sr_cpath.bat and
    remove the REM from the lines that contain the path to your VC++
    directory. make sure the paths are correct. this will fix the
    error you are getting.

    Originally posted by ARWinner
    You need to have a C compiler loaded in order to create
    Stored procedures.

    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
  •