ADSM-L

Re: DEF ASSOC domain_name sched_name * - ARRGGHHH

2001-04-18 11:08:19
Subject: Re: DEF ASSOC domain_name sched_name * - ARRGGHHH
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
Date: Wed, 18 Apr 2001 11:08:27 -0400
When I have to do something like that, I have TSM generate the commands I
need by putting fixed text into an SQL select statement.   For example:

select 'delete association', node_name , domain_name, schedule_name from
associations  where CHG_TIME>'2001-04-17 00:00'

That SELECT  generates output with the "delete association" text at the
beginning of each linet.  Pipe the output into a file.  Edit the file to
delete the header lines, and VIOLA, you have a list of commands ready to
execute as a macro.

You will have to adjust the WHERE statements to make sure it pulls out just
the stuff you want to undo.

Hope that helps....
************************************************************************
Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
wanda_prather AT jhuapl DOT edu

"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert
************************************************************************






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