Thomas, There is no existing [SQL] table you can run SELECT from to get this data. BUT you can map one of the hidden tables to create new SQL table and then run your SELECT against this new table. I'd recommend you to search ADSM-L archive for the command to do the mapping; this is 'undocumented' one.....table you need to map is "Schedule.Event"
Sergey -----Original Message----- From: Thomas Rupp, Vorarlberger Illwerke AG [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:09 AM To: [EMAIL PROTECTED] Subject: SELECT equivalent for QUERY EVENT Hi *sm-gurus, as our VM mainframe is soon going to die I'm rewriting all my CMS REXX programs using REGINA and REXXSQL on Windows XP. As I have to rewrite the code I would like to brush it up and replace those QUERYs with SELECTs. I was playing around (and even reading the manuals ;-) but couldn't find a SELECT statement for the following QUERY: QUERY EVENT * * TYPE=CLIENT Begindate=TODAY-1 BEGINTIME=19:00 EXceptionsonly=YES FORMAT=DETAILED I would like to know what events ended with errors. TSM Server 4.2.2.8 (I know it's far too old) Kind regards Thomas Rupp Vorarlberger Illwerke AG
