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'
To: [EMAIL PROTECTED]
> Subject: Re: SELECT equivalent for QUERY EVENT
>
>
> >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
>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.
Thomas - A couple of observations...
- I would caution avoiding going to Sel