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:[EMAIL PROTECTED]] > > Sent: Thursday, March 28, 2002 5:15 PM > > To: [EMAIL PROTECTED] > > 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 > > >
