Re: sql statement that shows the active files for a client
2004-02-23 10:27:32
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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
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 <Eddie_Jones AT CANADALIFEUS DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
02/23/2004 08:15
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L AT VM.MARIST DOT EDU
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
---***---
|
|
|