OPS/MVS Rexx Question with SQL

2009-02-18 Thread Lizette Koehler 
I am trying to help a friend create some OPS/MVS Rule to read the STCTBL and 
retrieve only those entries that begin with CICS on LPARx.

I know in SQL you can code
Select * from STCBL
Where name like 'CICS'

However I am not finding something similar in OPS/MVS Rexx.

Any body point me in the right direction?

Lizette

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Re: OPS/MVS Rexx Question with SQL

2009-02-18 Thread Patrick Loftus 
You could probably use the below somehow.  The manuals on the CA website are
quite good, so I'd check those first.

table = 'SWZ_STCTBL'  
ADDRESS SQL
 "SELECT NAME INTO :TASK FROM "table" WHERE CURRENT_STATE = 'UP'" 

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Re: OPS/MVS Rexx Question with SQL

2009-02-19 Thread Scott T. Harder 
Hi Lizette,

I'm an old AutoMate/MVS guy but didn't really get to work with OPS too
much before moving on (miss it a lot, though).  I would try posting this
question on the ProTech automation list:

AUTOMATION (Hosted by ProTech) 
Discussion forum for Data Center Automation and Enterprise Systems
Management.  You can join this group by sending the message "join
automation" (in body of email) to list...@protechpts.com

HTH,
Scott

Scott T. Harder
Tech Support & Product Development
ASPG, Inc.
Ph:   239-649-1548 / Ext. 203
Fax:  239-649-6391
General Support Email:  aspgt...@aspg.com


-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
Behalf Of Lizette Koehler
Sent: Wednesday, February 18, 2009 1:56 PM
To: IBM-MAIN@bama.ua.edu
Subject: OPS/MVS Rexx Question with SQL

I am trying to help a friend create some OPS/MVS Rule to read the STCTBL
and retrieve only those entries that begin with CICS on LPARx.

I know in SQL you can code
Select * from STCBL
Where name like 'CICS'

However I am not finding something similar in OPS/MVS Rexx.

Any body point me in the right direction?

Lizette

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html