Quick Tip: Decline All Update Packages Using SQL
Share
A quick way to decline all packages that have been marked for deployment on a development client is use SQL:
UPDATE SY900.F98825 SET UPINPKST=40 --Decline WHERE UPMKEY='DEV_CLIENT_NAME'
Use case:
Development client has been around for a while. You’ve since deployed many update packages. The developer has neglected to take all the update packages. Something goes wrong and you have to install the latest full package. Well, that full package contains all the code changes from the update packages. So, even though those update packages will show up upon login, they are not required in order to stay current.
Author
Stewart Schatz
Average Rating
One thought on “Quick Tip: Decline All Update Packages Using SQL”
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
More Stories
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...
You actually make it seem really easy with your presentation however I in finding this matter to be actually one thing that I feel I
would by no means understand. It sort of feels too complicated and extremely huge for me.
I am taking a look ahead for your next publish, I’ll
attempt to get the grasp of it!