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
4 min
Synon 2E Understanding CONstant usages
UPDATE: 06/12/2025 - Linked to a summary post dedicated to deep dive long form posts. https://leedare-plex2e.blogspot.com/2025/12/synon-2e-technical-deep-dives.html One of my…
Read
1 min
Synon 2E Exploring messages via SQL (Update)
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 Last year I…
Read
1 min
Synon 2E Exploring messages via SQL
Bitesized post today. I needed to query the model to see if a particular function was called in second level message text. I also wanted to see if it was referenced in the message…
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
SQL is your friend by my mate Nick
Source SQL code for audit updated in a typical synon 2E file UPDATE: 06/12/2025 - Added a summary link post to aggregate these types of posts.…
Read