Quick Tip: How To Delete Multiple SQLPKGs

Read Time:21 Sec

Run the following command to delete all the SQLPKG’s in the QRECOVERY library with a name beginning with “OW”

DLTSQLPKG SQLPKG(QRECOVERY/OW*)

Of course, this command can be used to delete SQLPKG’s in any library. However, this is very powerful and dangerous so you need to know exactly what you are doing.

***DO NOT DELETE ANY SQLPKG’s IN LIBRARIES: QIWS or QSYS ***
***DO NOT DELETE ANY SQLPKG STARTING WITH “Q” ***

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

One thought on “Quick Tip: How To Delete Multiple SQLPKGs

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

E1Tips.com - SQL Ninja Previous post Quick Tip: Hold All JDE Job Queues
E1Tips Qucik Tip Next post Find Windows Server Uptime Using Net Statistics Server