or this select substr(MESSAGE,1,9) from actlog where 
substr(MESSAGE,1,9)='ANR2565I'



                           mobeenm
                    <mobeenm@MICRO       To:     ADSM-L AT VM.MARIST DOT EDU
                            N.COM>       cc:     (bcc: MUSTAFA 
BAYTAR/ATIM/ICECEK)
                          Sent by:       Subject:     Re: How to use string 
operators in select statement - TSM.
                       "ADSM: Dist
                     Stor Manager"
                    <ADSM-L AT VM DOT MAR
                          IST.EDU>


                        28.02.2002
                             11:21
                    Please respond
                    to "ADSM: Dist
                     Stor Manager"






Sree Kumar,
Its absolutely possiblem to do that. Try the following

select * from actlog where message like 'ANR2565I%'

I think this should do the trick. Hope the climate in Bangalore is good :-)

Regards
Mobeen

Mobeen Mahamood C.M
Systems Manager Lead
Micron Semiconductor Asia
Singapore





> -----Original Message-----
> From: Pothula S Paparao [mailto:9pothula AT SG.IBM DOT COM]
> Sent: Thursday, March 28, 2002 5:15 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: How to use string operators in select statement - TSM.
>
>
> 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
>