Workstation Messages..!!

vliyer

Active Member
Hi,
Is there any way to trap workstation messages (originated by any UBE) and
dump in report???


TIA,
Venkat.

Xe,SP15.1 , AS/400 database.
 

JonSellers

Member
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
 

vbojan

Well Known Member
Media object name is GT01131, table F00165 and “GenericTextKey “ (“GDTXKY”) is “ZZSERK” from F01131. “ZZSERK” is “MathNumeric” and it has to be converted into string because “GDTXKY” is vString(254).

Hope this helps,

Bojan.
 
Top