Geoff,

I'm not 100% sure, but I think that what you're asking for is the
classic SQL union of 2 select statements. As I understand it, this is
possible in a traditional DB2, but the union & intersect operations are
not available in the TSM SQL subset. The closest I can manage is the
following

select A.SCHEDULE_NAME,NODE_NAME,ACTION,STARTDATE,STARTTIME,DURATION
from client_schedules A, associations

Unfortunately, this gives you the duplicate information for every
nodename in the schedule. You want the much tidier output of a single
entry for each schedule, nodename, etc etc and then a following list of
the nodenames.

I can't get this in one single select statement. The only solution I can
manage would be to script it.

Leigh

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Gill, Geoffrey L.
Sent: 13 October 2005 21:13
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Query for schedule and node

Hello all,

I'm wondering if anyone has a query for this. Something broken out by
schedule name with the nodes associated with each schedule. I'm looking
for
schedule name, Action, Date/Time, Period and Duration, Platform and the
node
names associated with each schedule.



Thanks,



Geoff Gill

TSM Administrator

SAIC M/S-G1b

(858)826-4062

Email:  <mailto:geoffrey.l.gill AT saic DOT com> geoffrey.l.gill AT saic DOT com