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:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 13 October 2005 21:13 To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED]> [EMAIL PROTECTED]