Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    5

    Unanswered: getting error while creating procedure in DB2 ver 7 FP3

    CREATE PROCEDURE RESULT_SET () LANGUAGE SQL DYNAMIC RESULT SETS 1
    BEGIN
    DECLARE testcur CURSOR WITH HOLD FOR SELECT NOTES, NOTES1, NOTE2, NOTE3, ID FROM TEST;
    open testcur;
    END @


    It says

    SQL1109N The specified DLL "D:\PROGRA~1\SQLLIB\function\db2udp.dll" could not
    be loaded.

    So how can I get this dll. I have installed enterprise edition from where can I get this.

    Thanks,
    Paresh

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

    Re: getting error while creating procedure in DB2 ver 7 FP3

    Have you installed Application Development Client and a C/C++ compiler on your server.

    Though not very sure, I think D:\Program Files\sqllib\function need to be in the PATH Environment variable.

    HTH

    Cheers

    Sathyaram

    Originally posted by pareshpaladiya
    CREATE PROCEDURE RESULT_SET () LANGUAGE SQL DYNAMIC RESULT SETS 1
    BEGIN
    DECLARE testcur CURSOR WITH HOLD FOR SELECT NOTES, NOTES1, NOTE2, NOTE3, ID FROM TEST;
    open testcur;
    END @


    It says

    SQL1109N The specified DLL "D:\PROGRA~1\SQLLIB\function\db2udp.dll" could not
    be loaded.

    So how can I get this dll. I have installed enterprise edition from where can I get this.

    Thanks,
    Paresh

  3. #3
    Join Date
    Nov 2003
    Posts
    1

    how to declare local varibales in triggers

    how can i declare local varibales in db2 udb database trigger program. and also how to fetch cursor into local variables.

    EX:

    DECLARE V_SellerAcctNbr VARCHAR(20)
    DECLARE V_ProgramCd VARCHAR(10)
    DECLARE V_PromoCd VARCHAR(10)

    OPEN cExchRates

    FETCH cExchRates INTO

    V_SellerAcctNbr,
    V_ProgramCd

    Is this syntax is currect.

    please any one help me out to finish this trigger program

    Thanks
    janakiram

Posting Permissions

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