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

Writing stored procedures in DB2 UDB on Windows 2000.

1 posts in topic

Flat View

Thread View

Older Post First | Reply to Topic

TOPIC ACTIONS:

Print Topic

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>>

Report | Quote This | Send private message | Reply | Print

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.

Report | Quote This | Send private message | Reply | Print