Writing stored procedures in DB2 UDB on Windows 2000.
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Anonymous
Posted On:   Sunday, December 21, 2003 07:43 PM

1. We had wrriteen a SQL Stored Procedure in DB2 UDB ( windows platform ). When we tried to build this procedure from the DB2 Stored procedure builder tool, we got the following error. Could anyone pls. throw some light on this... 2. Also, we would like to understand the limitations of SQL procedures written in DB2. Our idea is to call the Stored procedures using JAVA. pls. let me know your commentssuggetions on this. D:SYSSQLLIBfunction outinesqlprocSSTDBDB2ADMIN mp>set SQLROUTINE_FILENAME=P5239670 D:SYSSQLLIBfunction outinesqlprocSSTDBDB2ADMIN mp>set db2path=D:SYSSQLLIB D:SYSSQLLIBfunction outinesqlprocSSTDBDB2ADMIN mp>nmake /f D:SYSSQLLIBfunction outinesqlproc.mak   More>>

1. We had wrriteen a SQL Stored Procedure in DB2 UDB ( windows platform ). When we tried to build this procedure from the DB2 Stored procedure builder tool, we got the following error. Could anyone pls. throw some light on this...

2. Also, we would like to understand the limitations of SQL procedures written in DB2. Our idea is to call the Stored procedures using JAVA. pls. let me know your commentssuggetions on this.

D:SYSSQLLIBfunction
outinesqlprocSSTDBDB2ADMIN mp>set SQLROUTINE_FILENAME=P5239670

D:SYSSQLLIBfunction
outinesqlprocSSTDBDB2ADMIN mp>set db2path=D:SYSSQLLIB

D:SYSSQLLIBfunction
outinesqlprocSSTDBDB2ADMIN mp>nmake /f D:SYSSQLLIBfunction
outinesqlproc.mak

'nmake' is not recognized as an internal or external command,
operable program or batch file.

   <<Less

Re: Writing stored procedures in DB2 UDB on Windows 2000.

Posted By:   Christopher_Koenigsberg  
Posted On:   Sunday, December 21, 2003 08:21 PM

...'nmake' is not recognized ...


Isn't "nmake" a Microsoft tool, that comes with Visual Studio? if I recall correctly from many years ago, it is their version of Unix "make?


Apparently you are running a script that expects to find "nmake" on your PATH somewhere.

About | Sitemap | Contact