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
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...
How To Delete Journal Receivers (*JRN & *JRNRCV)
The other day, we were trying to refresh a data library on the iSeries and were unable to remove several journal files (*JRN and *JRNRCV)....
SQL Exception Join
I know, for some of you gurus this is old news. However, for me this is brand new and exciting! The iSeries has a special...
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,...