Here is some SQL that lists the Log Message actions in Application Programs:
SELECT A.AE_APPLID, A.AE_SECTION, A.AE_STEP, M.AE_MESSAGE_PARMS, S.MESSAGE_SET_NBR, S.MESSAGE_NBR FROM PSAESTMTDEFN A, PSAESTEPMSGDEFN M, PSAESTEPDEFN S WHERE A.AE_APPLID = M.AE_APPLID AND A.AE_APPLID = S.AE_APPLID AND A.AE_SECTION = M.AE_SECTION AND A.AE_SECTION = S.AE_SECTION AND A.MARKET = M.MARKET AND A.MARKET = S.MARKET AND A.DBTYPE = M.DBTYPE AND A.DBTYPE = S.DBTYPE AND A.EFFDT = M.EFFDT AND A.EFFDT = S.EFFDT AND A.AE_STEP = M.AE_STEP AND A.AE_STEP = S.AE_STEP AND A.AE_STMT_TYPE = 'M'
Thanks
Very much ^_^
http://www.mzuonqtr.com
ty