ADSM-L

Re: sql statement that shows the active files for a client

2004-02-23 10:27:32
Subject: Re: sql statement that shows the active files for a client
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 23 Feb 2004 08:27:07 -0700
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


---***---

<Prev in Thread] Current Thread [Next in Thread>