There is a "short message" field in the Workcenter table which is a text field and can be easily displayed.
(The message that is displayed while in the workcenter application is a media object and is not easily retrieved).
I used as400 sql to retrieve the message along with some other information (User An8, Run date/time, etc).
In the example below I wanted to reduce amount of output so I specified a run date and report name.
Here is the sql:
SELECT SUBSTR(B.ZMTSV,1,32),
C.ZMMSGP,
A.ZZDTI,
A.ZZAN8,
A.ZZTSV,
A.ZZUPMT
FROM F01131 A,
F01131M B,
F01131M C
WHERE
A.ZZDTI = 101200 AND
A.ZZTSV = 'R01010Z' AND
B.ZMPSRK = A.ZZSERK AND
B.ZMSERK = C.ZMPSRK AND
C.ZMMSGP <> ' '
Regards.
JS
AS/400 (ES), Windows NT , XE B7333 15.1, Terminal Sever