prob in building SQL Stored Proc (DB2 on Win2000 Advanced Server)

[tridibsardar]

hi all!

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~1\SQLLIB\function\routine\sqlproc\ACESDB\ADMINISTRATOR\tmp\P3716930.def ***

LIBRARY P3716930
EXPORTS _pgsjmp@4
pgsjmp=_pgsjmp@4

C:\PROGRA~1\SQLLIB\function\routine\sqlproc\ACESDB\ADMINISTRATOR\tmp>set SQLROUTINE_FILENAME=P3716930
C:\PROGRA~1\SQLLIB\function\routine\sqlproc\ACESDB\ADMINISTRATOR\tmp>set db2path=C:\PROGRA~1\SQLLIB
C:\PROGRA~1\SQLLIB\function\routine\sqlproc\ACESDB\ADMINISTRATOR\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 "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

 

[111999111]

have you installed a c compiler like visual c++ or the c compiler from ibm ?
if not, you can download one of them, but only ms visual or the ibm thing ...

bernd

 

[manjunale]

hi,
have u set DB2_SQLROUTINE_COMPILER_PATH variable with proper path of VCVARS32.BAT file?

 

[Guest_imported]

Have the same problem paths are fine.. but still the same error ..

any clues please ?


any help is much appreciated

DBLOST