|
List Home > Databases > IBM DB2 > [ Post New Problem ]
Welcome back !
| TrackingID : | 17 |
| Posted : | Friday, March 01st, 2002 12:14:20 AM |
| By : | tridibsardar |
| Problem in building Stored Proc (DB2 on win2000 ) | Configuration: |
i'm trying to build the following stored proc in DB2 v7.1 on win2000 advanced server..
CREATE PROCEDURE Administrator.Test ( )
LANGUAGE SQL
-- SQL Stored Procedure
P1: BEGIN
Update Administrator.Acet_Dkt set Docket_idn=33
where Docket_idn = 30;
END P1
and getting the following error message-
"ERROR MESSAGE"
*** C:PROGRA~1SQLLIBfunctionroutinesqlprocACESDBADMINISTRATORtmpP3716930.def ***
LIBRARY P3716930
EXPORTS _pgsjmp@4
pgsjmp=_pgsjmp@4
C:PROGRA~1SQLLIBfunctionroutinesqlprocACESDBADMINISTRATORtmp>set SQLROUTINE_FILENAME=P3716930
C:PROGRA~1SQLLIBfunctionroutinesqlprocACESDBADMINISTRATORtmp>set db2path=C:PROGRA~1SQLLIB
C:PROGRA~1SQLLIBfunctionroutinesqlprocACESDBADMINISTRATORtmp>nmake /f C:PROGRA~1SQLLIBfunctionroutinesqlproc.mak
'nmake' is not recognized as an internal or external command,
operable program or batch file.
-------------------------
SQL7032N SQL procedure "TEST" not created. Diagnostic file is "P3716930.log". SQLSTATE=42904
ADMINISTRATOR.TEST - Build failed.
ADMINISTRATOR.TEST - Changes rolled back.
help me out if u can..
thanx in advance..
tridib
| Operating System : Microsoft Windows 2000 Advanced Server
|
Related Problems :
Comments :
Try this by Anonymous Ghost on March 01st, 2002 09:10:20 AM
.
Try this Link |
re by Anonymous Ghost on June 11th, 2002 06:16:45 AM
u need to install vc+= compiler on ur server |
Related Problems :
List Home > Databases > IBM DB2 > [ Post New Problem ] |
|
