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 [email protected] HTH, Scott Scott T. Harder Tech Support & Product Development ASPG, Inc. Ph: 239-649-1548 / Ext. 203 Fax: 239-649-6391 General Support Email: [email protected] -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Lizette Koehler Sent: Wednesday, February 18, 2009 1:56 PM To: [email protected] 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 [email protected] 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 [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
