ADSM-L

Re: How to use string operators in select statement - TSM.

2002-02-28 19:35:27
Subject: Re: How to use string operators in select statement - TSM.
From: Joel Fuhrman <joelf AT CAC.WASHINGTON DOT EDU>
Date: Thu, 28 Feb 2002 16:32:59 -0800
Or you can do a "query act msg=2565"

On Thu, 28 Feb 2002, mobeenm wrote:

> 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
> >
>