ADSM-L

How to use string operators in select statement - TSM.

2002-02-28 04:19:13
Subject: How to use string operators in select statement - TSM.
From: Pothula S Paparao <9pothula AT SG.IBM DOT COM>
Date: Thu, 28 Mar 2002 17:15:16 +0800
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