Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stored procedure build error

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
hello friends ,

While trying to build a stored procedure the following error message is being displayed

DB2ADMIN.SQLSAMP - Create stored procedure returns -7032.

DB2ADMIN.SQLSAMP: *** PREPCOMPILE C:\PROGRA~1\SQLLIB\function\routine\sqlproc\ACESDB\DB2ADMIN\tmp\SQLSAMP.sqc
***LINE MESSAGES FOR SQLSAMP.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\ACESDB\DB2ADMIN\tmp\SQLSAMP.c ***@echo offREM set VCV6_DRIVE=c:\Microsoft Visual StudioREM set include=%include%;%VCV6_DRIVE%\VC98\atl\include;%VCV6_DRIVE%\VC98\mfc\include;%VCV6_DRIVE%\VC98\includeREM set lib=%lib%;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\libREM set path=%path%;%VCV6_DRIVE%\Common\Tools\WinNT;%VCV6_DRIVE%\Common\MSDev98\Bin;%VCV6_DRIVE%\Common\Tools;%VCV6_DRIVE%\VC98\bin;%VCV6_DRIVE%\VC98\mfc\lib;%VCV6_DRIVE%\VC98\lib@echo offREM set VCV5_DRIVE=c:\Program Files\devstudioREM set include=%include%;%VCV5_DRIVE%\vc\include;%VCV5_DRIVE%\vc\atl\include;%VCV5_DRIVE%\vc\mfc\includeREM set lib=%lib%;%VCV5_DRIVE%\vc\lib;%VCV5_DRIVE%\vc\mfc\libREM set path=%path%;%VCV5_DRIVE%\sharedide\bin\ide;%VCV5_DRIVE%\sharedide\bin;%VCV5_DRIVE%\vc\bin@echo onset SQLROUTINE_FILENAME=SQLSAMPset db2path=C:\PROGRA~1\SQLLIBnmake /f C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak***
C:\PROGRA~1\SQLLIB\function\routine\sqlproc\ACESDB\DB2ADMIN\tmp\SQLSAMP.def ***
LIBRARY SQLSAMPEXPORTS _pgsjmp@12pgsjmp=_pgsjmp@12C:\PROGRA~1\SQLLIB\function\routine\sqlproc\ACESDB\DB2ADMIN\tmp>
set SQLROUTINE_FILENAME=SQLSAMP C:\PROGRA~1\SQLLIB\function\routine\sqlproc\ACESDB\DB2ADMIN\tmp>
set db2path=C:\PROGRA~1\SQLLIB C:\PROGRA~1\SQLLIB\function\routine\sqlproc\ACESDB\DB2ADMIN\tmp>nmake /f
C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak 'nmake' is not recognized as an internal or external command,
operable program or batch file.----------------------------------------------------------------------------SQL7032N
SQL procedure "SQLSAMP" not created. Diagnostic file is "SQLSAMP.log". SQLSTATE=42904

DB2ADMIN.SQLSAMP - Build failed.

DB2ADMIN.SQLSAMP - Changes rolled back.

can anybody help me with this problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top