Did you by chance look at SYSROUTINES table. I believe that table will help you
Thanks,
Steve
Steven Bennett
Manager, Applications Development
AIT Worldwide Logistics, Inc.
Chicago, Illinois, USA
Office: +1 (630)766-8300 / Ext: 6472
Fax: +1 (630) 250-3708
www.aitworldwide.com<
http://www.aitworldwide.com/>
our people deliver.(r)
[cid:image001.png@01D9E1B3.2687A640]<
http://www.facebook.com/aitworldwide> [cid:image002.png@01D9E1B3.2687A640] <
http://www.linkedin.com/company/24870> [cid:image003.png@01D9E1B3.2687A640] <
http://www.glassdoor.com/Overview/Working-at-AIT-Worldwide-Logistics-EI_IE31929.11,34.htm> [cid:image004.png@01D9E1B3.2687A640] <
http://www.youtube.com/user/aitait701>
[cid:image005.jpg@01D9E1B3.2687A640]<
http://fundraising.stjude.org/site/TR/Walk/Walk?team_id=223905&pg=team&fr_id=89696>
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Niels Liisberg
Sent: Thursday, September 7, 2023 3:26 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Question on SQL stored procedures.
CAUTION: This message originated externally, please use caution when clicking on links or opening attachments!
Select * from sysroutines
I prefer this since it covers both functions and procedures
tor. 7. sep. 2023 kl. 21.10 skrev Michael Mayer <michael.mayer@xxxxxxxxxxxxx
<mailto:michael.mayer@xxxxxxxxxxxxx%0b>>:
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<mailto:michael.mayer@xxxxxxxxxxxxx>
https://www.ermco-eci.com<https://www.ermco-eci.com>
IBM i Personal Blog: https://ibmireference.blogspot.com<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<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l<https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l<https://archive.midrange.com/midrange-l>.
Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related
questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l<
https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l<
https://archive.midrange.com/midrange-l>.
Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
**********************************************************************************************************************
This electronic message transmission contains information from AIT Worldwide Logistics, Inc. and is confidential
and/or legally privileged and shall remain the property of AIT Worldwide Logistics, its subsidiaries, affiliates
and parent companies. The information is intended only for the use by the designated person(s) named above. If you
are not the intended recipient, any disclosure, copying, distribution or use of or any other action or reliance based
on the contents of this information is strictly prohibited. If you received this electronic transmission in error,
please notify the sender listed above.
Global services provided by AIT Worldwide Logistics are subject to the applicable terms and conditions published at
http://www.aitworldwide.com/terms-and-conditions.
**********************************************************************************************************************
midrange.com
