Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: Stored Procedure-help-help

    Hi ,
    I ran a stored procedure in aix and db2v7.2, I got error:
    valid Command Line Processor command. During SQL processing it returned:
    SQL10013N The specified library "db2udp" could not be loaded. SQLSTATE=42724

    Please Advise.
    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Stored Procedure-help-help

    Do you have application development client installed on your m/c ... This is a pre-requisite for SQL Stored Procedures ..

    Cheers

    Sathyaram

    Originally posted by David2002
    Hi ,
    I ran a stored procedure in aix and db2v7.2, I got error:
    valid Command Line Processor command. During SQL processing it returned:
    SQL10013N The specified library "db2udp" could not be loaded. SQLSTATE=42724

    Please Advise.
    Thanks

  3. #3
    Join Date
    Jul 2002
    Posts
    86
    Thanks again Sathyaram_s,
    could you please let me know what you mean m/c, and explain more.
    Thanks

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I apologize for not being clear ...

    Well, you need to install Application Development Client and a C Compiler on your server if you intend to create SQL Stored Procedures. I believe that the db2udb comes with your application dev client.

    Make sure you run db2iupdt after installing the application dev client ...

    Hope this helps

    Cheers

    Sathyaram


    Originally posted by David2002
    Thanks again Sathyaram_s,
    could you please let me know what you mean m/c, and explain more.
    Thanks

  5. #5
    Join Date
    Mar 2002
    Posts
    34
    I ran into the same problem when I first starting using db2. It tooks us almost 3 weeks to figure out the dba hadn't set up the compiler correctly.

    Besides, installing the devlopment client "aka stored procedure builder" you need to have a C++ compiler installed as well. You can install the C++ compiler on your local PC and this will enable you compile procedures. Although it makes it a lot easier if your DBA sets it up on the server.

    Note: if you install everthing and are still having problems, make sure the directory path for the compiler is set up correctly.

Posting Permissions

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