Found the problem: I needed to specify PACKAGE PATH in the CREATE PROCEDURE.
On Tue, 7 Feb 2023 15:21:07 -0600 Mike Bell <[email protected]> wrote: :>start from the basics - I assume the plan name is DSNREXX. you can :>1. bind the DSNREXX plan with your collection and it will find it in the :>search list :>2; SET CURRENT PACKAGESET = 'your collection' :>I haven't played in this area but those are the basics. :>Mike :> :>On Tue, Feb 7, 2023 at 2:25 PM Binyamin Dissen <[email protected]> :>wrote: :> :>> On Tue, 7 Feb 2023 19:36:12 +0000 Sri h Kolusu <[email protected]> wrote: :>> :>> :>>> The -805 is occurring for the SQL statement (a SELECT INTO) in the SP. :>> :>> :>Try the steps listed under "Problem determination" in the link below :>> :>> :>https://www.ibm.com/docs/en/db2-for-zos/11?topic=codes-805 :>> :>> Thanks. The only possibility is the packageset. :>> :>> Is there a need to set a packageset before binding the SP package? :>> :>> Alternatively, is there a need for the CALLing program to set the :>> packageset :>> before issuing the SELECT INTO? :>> :>> I am missing something obvious. -- Binyamin Dissen <[email protected]> http://www.dissensoftware.com Director, Dissen Software, Bar & Grill - Israel ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
