Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    20

    Unanswered: db2: Calling stored procedure from a function

    Hi All,

    How can I call a stored procedure from a function? I get an error if I try

    call JG_FN(retVal);

    The error message is:

    administrator.C_JG: 9: [IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "call JG_FN(retVal)" was found following "clare retVal float; ". Expected tokens may include: "<SQL_condition_declaration>". LINE NUMBER=9. SQLSTATE=42601


    Thanks and Regards,
    Deepak Ajmera

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

    Re: db2: Calling stored procedure from a function

    Not possible, AFAIK
    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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