Rachel,
Try this select query.
select volume_name from volhistory where
date_time<timestamp(date(current_timestamp),'00:00') and type in
('BACKUPFULL','BACKUPINCR')
Following pdf By Andrew Reibeck is the best place to start with tsm sql.
http://www-dat.lrz.de/dat/8/asys/doc/tsmserv/adsmserv-sql/doc/pdf/adsm_s
ql.pdf
Regards, Samiran Das
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Smith, Rachel
Sent: Wednesday, October 06, 2004 11:31 AM
To: [EMAIL PROTECTED]
Subject: select command
Hi,
I am trying to complete a select command to "select volume_name from
volhistory where type='backupfull' and date_time>'today'" which fails
because today is incorrect, can you tell me the correct format. Also
when the above runs successfully, I will require it to use the out but
from the select command to move the media to tost=vault.
Any ideas on how to do this or a web site that helps us understand SQL
better?
Thanks..
--------------------------------------------------------
If you are not an intended recipient of this e-mail, please notify the sender, delete
it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click
here for important additional terms relating to this e-mail.
http://www.ml.com/email_terms/
--------------------------------------------------------
