Quick Tip: Hold All JDE Job Queues
The following SQL statement will put all JDE Job Queues on hold: UPDATE SY920.F986130 SET QCQUSTS='02' This statement is very helpful when dealing with a...
How To Disable Client Package Deployment
If you have a development client that has been neglected and JDE wants you to install 15 update packages but all you really want to...
Quick Tip: Limit The Number Of Rows Returned From A SQL Query
This is pretty basic, but I had to look up the syntax to use for SQL on IBM DB2 so I thought I'd write a...
Quick Tip: Where Is An Application On The Menu?
The following SQL will give you a good idea if an application or UBE is on the menu and where it is: SELECT * FROM...
Quick Tip: Decline All Update Packages Using SQL
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...