Srinath, Schedules table doesn't exist !!! You should try with CLIENT_SCHEDULES or ADMIN_SCHEDULES ... To get an idea of existing tables : select * from tables. Cheers.
Arnaud ************************************************************************ ****** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: Thursday, 05 October, 2006 16:33 To: [email protected] Subject: Re: Select Statement Syntax to view the schedule Hi All, I am able to see the node info using the following command TSM>Select * from nodes However, the same doesn't work as TSM>Select * from schedules Can anybody let me know the right command for getting info about schedules using select statement Regards, Srinath G This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies.
