Find All Checked Out Objects Using SQL
Use the SQL statement below to find all the objects that are checked out:
select * from ol900/f9861 where sistce=3
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.
More Stories
F986110.JCPRTQ Is Not The Print Queue
In the F986110, the JCPRTQ (Data Dictionary = Print Queue) column is used to store the port number of the JDE services running on the execution host.
JDE CNC + JDE Developer ≠ 1
Recently, while scrolling on this platform, where we all strive to present our best professional selves, I came across a job posting titled JD Edwards E1 CNC/Developer. To be honest, it kind of scared me.
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...
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...
Needle: Package Manifest Browser
Here is a common discussion between a CNC Admin and a JDE Development Manager (if you are lucky enough 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...
Average Rating