Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183

    Angry Unanswered: Stored Proc's in DB2 8.1

    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    May 2004
    Posts
    11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •