How to use string operators in select statement - TSM.

[Pothula S Paparao]

Hi TSM'ers
The below is the message from select output (select * from actlog)
All I want to know is whether or not possible to caputue only the message
no (ex. ANR2565I) using select query. I tried using string operations in
select command. didnt help much. If any select expert tried this pls let me
know. Im very much intrested to know about it.

Thanks in advance.


DATE_TIME: 2001-12-30 00:00:02.000000
    MSGNO: 2565
 SEVERITY: I
  MESSAGE: ANR2565I 0 schedules for immediate client actions have been
            deleted.


Regards

Sreekumar.
SO
IBM Singapore.
Phone : 65-8402634