Great iSeries SQL Reference When Working With Dates & Times
I really used this page a lot when working with SQL and dates & times. DB2 Basics: Fun With Dates and Times
End Subsystem Jobs Using SQL
We have noticed many orphaned subsystem jobs piling up in the F986113. In tracking them down we found that the way we stop the subsystem...
EnterpriseOne SubSystem Jobs Not Starting
For a while now we have had an issue where our subsystem Purchase Order Print job (R43500) will not run in JPD900 but it will...
Add A JDE EnterpriseOne Environment To Every Role/Group
You can use the below SQL to add an EnterpriseOne environment to every role or group in your installation: INSERT INTO SY910/F0093 (LLUSER,LLLL,LLSEQ,LLMNI) SELECT ULUSER,...
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