Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Bath, England
    Posts
    7

    Unanswered: db2udp error message

    My client has recently installed a C compiler on their DB2 UDB 7.2 server. When I build the following, very simple, stored procedure in the Stored Procedure Builder (using the wizard), I get the error message shown, which relates to dll db2udp. I'm hoping this a 'teething trouble' error for a new installation, but would appreciate explanation of the message from somebody who has been here before.

    Many thanks if you can help.

    Marc


    Stored Procedure:-

    CREATE PROCEDURE USP_AUDITLETTERS ( )
    RESULT SETS 1
    LANGUAGE SQL
    ------------------------------------------------------------------------
    -- SQL Stored Procedure
    ------------------------------------------------------------------------
    P1: BEGIN
    -- Declare cursor
    DECLARE cursor1 CURSOR WITH RETURN FOR
    SELECT
    *
    FROM
    MYNAME1.AUDITLETTER;

    -- Cursor left open for client application
    OPEN cursor1;

    END P1


    Error message:-

    MYNAME1.USP_AUDITLETTERS - Create stored procedure returns -1109.

    MYNAME1.USP_AUDITLETTERS: [IBM][CLI Driver][DB2/NT] SQL1109N The specified DLL "db2udp" could not be loaded. SQLSTATE=42724

    MYNAME1.USP_AUDITLETTERS - Build failed.

    MYNAME1.USP_AUDITLETTERS - Changes rolled back.

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

    Re: db2udp error message

    Did you install the application Dev Client ?

    Use the search feature in this site and search for db2udp in this forum and also in comp.databases.ibm-db2 I have seen a number of posts about this error

    HTH

    Cheers

    Sathyaram



    Originally posted by PastaSalad
    My client has recently installed a C compiler on their DB2 UDB 7.2 server. When I build the following, very simple, stored procedure in the Stored Procedure Builder (using the wizard), I get the error message shown, which relates to dll db2udp. I'm hoping this a 'teething trouble' error for a new installation, but would appreciate explanation of the message from somebody who has been here before.

    Many thanks if you can help.

    Marc


    Stored Procedure:-

    CREATE PROCEDURE USP_AUDITLETTERS ( )
    RESULT SETS 1
    LANGUAGE SQL
    ------------------------------------------------------------------------
    -- SQL Stored Procedure
    ------------------------------------------------------------------------
    P1: BEGIN
    -- Declare cursor
    DECLARE cursor1 CURSOR WITH RETURN FOR
    SELECT
    *
    FROM
    MYNAME1.AUDITLETTER;

    -- Cursor left open for client application
    OPEN cursor1;

    END P1


    Error message:-

    MYNAME1.USP_AUDITLETTERS - Create stored procedure returns -1109.

    MYNAME1.USP_AUDITLETTERS: [IBM][CLI Driver][DB2/NT] SQL1109N The specified DLL "db2udp" could not be loaded. SQLSTATE=42724

    MYNAME1.USP_AUDITLETTERS - Build failed.

    MYNAME1.USP_AUDITLETTERS - Changes rolled back.

Posting Permissions

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