Hi,

I want to create some stored procedures in DB2 8.1 (Win XP / Win200). The stored procedures are pure SQL. But may be something else.
When I try to compile the procedure I get an nmake error and the built process is rolled back.

I checked some thing on the web and it seems I need VC/C++ to have nmake. I'm familiar with Informix to create stored procedures and I'm very suprised to see I need to buy and install C/C++ on a (production) server to create stored procedures. I'm sure I'm making a big mistake because this can't be true. Kan anybody tell what I'm doing wrong.

Yes, you do need a C/C++ compiler to make SQL Stored Procedures. But it only needs to be on the development server. You can export and import SP definitions (with some restrictions) using the GET and PUT ROUTINE Stored Procedures.

I understand that in Stinger, this requirement has been eliminated.

HTH

Andy

Hi

This article at DeveloperWorks might help (if you dont have for example VC++ compiler): http://www-106.ibm.com/developerwork...306haungs.html

It worked fine for us (we installed it in Win2003 development server).

Regards,
Antti