Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Creating Stored Procedures

    I need to create Stored procedure on one of dev servers

    When I issue the command

    Code:
    db2 -td@ -f d:\td\sp1
    I get an Error as below

    Code:
    'nmake' is not recognized as an internal or external command,
    operable program or batch file.
    
    -- END OF LOG FILE (SQLCODE: -7032)
    It seems that we don't have compiler installed.

    What should I do ?

    DBFinder

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version and OS are you using?

    Andy

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    DB2 Ver 8.1.5


    C:\Documents and Settings\db2admin>db2level
    DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08015" with
    level identifier "02060106".
    Informational tokens are "DB2 v8.1.5.449", "s040212", "WR21334", and FixPak
    "5".
    Product is installed at "C:\SQLLIB".

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    For DB2 prior to 8.2, you need a C compiler to create SQL stored procedures. Either upgrade to 8.2, 9.1, or 9.5, or get a C compiler.

    Andy

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can upgrade for free to V8 FP17a, which is the latest 8.2 release.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks Friends,

    Your Help will always be remembered.

    I used following Link

    Configuring DB2 V8.1 to compile stored procedures with WebSphere Business Integration Server V4.2

    Thanks again
    DBFinder

Posting Permissions

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