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 <bdis...@dissensoftware.com> wrote: > On Tue, 7 Feb 2023 19:36:12 +0000 Sri h Kolusu <skol...@us.ibm.com> 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 <bdis...@dissensoftware.com> > http://www.dissensoftware.com > > Director, Dissen Software, Bar & Grill - Israel > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Mike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
