Here is the original post for some more context.
Lee Dare - Software Development Principles, Plex/2e and everything else in between.: Exploring 2E messages via SQL (leedare-plex2e.blogspot.com)
In addition to the above, I recommend the SQL syntax is improved by catering for 'Mixed Case'
SELECT a.@@MSG, a.MSG, a.TYPOPT, b.SECLVL
FROM YMSGDTARFP a
LEFT JOIN YMSGSECRFP b ON a.@@MSG = b.@@MSG
WHERE UPPER(a.MSG) like '%KD33%' OR
UPPER(a.TYPOPT) LIKE '%KD33%' OR UPPER(b.SECLVL) LIKE '%KD33%'
The actual query above is checking for the message name in the 2E model, the default message text and the second level text associated with the message.
Thanks for reading and as always, interested in any feedback.
Lee.
No comments:
Post a Comment
Thanks for considering leaving some comments about my random rants for everything software development and more.