See the BACKUPS table. You should find the answer to your question by querying the COLUMNS table for information about the fields in the BACKUPS table:
select * from columns where tabname='BACKUPS' or, more briefly, select colname, remarks from columns where tabname='BACKUPS' Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Eddie Jones <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/23/2004 08:15 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject sql statement that shows the active files for a client I am trying to write a sql statement that shows the active files for a client. I can not find the field in the list of tables to use. Can anyone help? Thank you in advance. Eddie Jones 770-953-1959 ext.2824 "The greatest lesson in life is to know that even fools are right sometimes." - Sir Winston Spencer Churchill ---***---
