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