Re: Question on SQL stored procedures.

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

I would think that if the developer in question is coming from another
platform he might have thought of that.  Although, I do admit, some
platforms call it sysprocedures and that is what I originally searched for.

On Thu, Sep 7, 2023 at 2:20 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> sysprocs?
> https://www.ibm.com/docs/en/i/7.5?topic=reference-db2-i-catalog-views
>
>
> On Thu, Sep 7, 2023 at 2:10 PM Michael Mayer <michael.mayer@xxxxxxxxxxxxx>
> wrote:
>
> > Hey everyone. I was asked this question:
> >
> > "Do you have an idea what system table holds this type of information?  I
> > am wanting to look for any and all SQL Stored Procedures I may have
> > littered across our environments."
> >
> > The programmer asking doesn't want to use WRKOBJ ... so I'm looking for
> > the SQL table. Anyone know this off the top of their heads?
> > SYSSTATS, OBJECTSTATS ..... all responses greatly appreciated.
> >
> >
> > Respectfully,
> > Michael Mayer
> > IBM i on Power System Admin
> > ERMCO-ECI
> > 2225 Industrial Rd
> > Dyersburg, Tennessee 38024
> > Office and OnCall: 731.676.4318
> > Cell: 518.641.8906
> > Email: michael.mayer@xxxxxxxxxxxxx
> > https://www.ermco-eci.com
> > IBM i Personal Blog: https://ibmireference.blogspot.com
> > "Success is not final. Failure is not fatal. It is the courage to
> > continue that counts".
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.