1 min
Synon 2E - SQL and Model files summary
Synon 2E - SQL and Model files summary Some of the SQL posts over the last year or so. Some useful 2E model files extraction routines, audit stamp updates and some general IBMi…
Read
5 min
Object Usage via SQL
Usually, I would use the Work with Object (WRKOBJ) command and work through them one by one capturing the data in excel or notepad manually. Another option is to build a list of…
Read
3 min
IBMi A few more little SQL's
UPDATE: 06/12/2025 - Added a summary link post to aggregate these types of posts. https://leedare-plex2e.blogspot.com/2025/12/synon-2e-sql-and-model-files-summary.html QSYS2 is a…
Read
3 min
IBMi Reading my Journal
All, Ever had a situation where data was being erroneously written, or simply disappeared and you had no idea why. For anyone with a journaled database on the IBMi this will be an…
Read
6 min
IBMi - Slow running batch tasks - A simple method to get you started (Synon developers guide)
Detailed breakdown for how to spot excessive IO and dependencies in your long running tasks UPDATE: 06/12/2025 - Linked to a summary post dedicated to deep dive long form posts.…
Read