Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Belgium
    Posts
    6

    Unhappy Unanswered: DB2 Stored procedures

    Hello,

    I have created several stored procedures using the Stored procedure builder. They all build an run succesfully within the stored procedure builder. But when I run them via the command line, only 1 runs and the other once are all giving the error message:

    SQL1109N The specified DLL "db2admin.proc2" could not be loaded.

    What am I doing wrong ?

    DB2 version : DB2/NT 7.2.0 on a Windows 2000


    Thanks in advance
    Dominic
    Last edited by dgybels; 03-18-04 at 07:54.

  2. #2
    Join Date
    Jul 2003
    Location
    Belgium
    Posts
    6

    Talking Re: DB2 Stored procedures

    Problem solved,

    the DB2admin.proc2 contains output parameters and running this within the stored procedure builder causes no problems, but running it just from command line return error as listed below.
    Unfortunately this error message is not the best indication...

    Bey


    Originally posted by dgybels
    Hello,

    I have created several stored procedures using the Stored procedure builder. They all build an run succesfully within the stored procedure builder. But when I run them via the command line, only 1 runs and the other once are all giving the error message:

    SQL1109N The specified DLL "db2admin.proc2" could not be loaded.

    What am I doing wrong ?

    DB2 version : DB2/NT 7.2.0 on a Windows 2000


    Thanks in advance
    Dominic

Posting Permissions

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