Reading tables across lpars

Products

• OPS/MVS Event Management & Automation

Issue/Introduction

We need to be able to read a RDF table from a remote LPAR. How to do so?

Environment

Release : 13.5 14.0

Component : OPS/MVS

Resolution

Use the SYSTEM keyword to indicate the MSF node where the table resides. For example:

ADDRESS SQL                             
"SELECT NAME FROM STCTBL SYSTEM(msfid)"
IF SQLCODE = 0 THEN                     
DO I = 1 TO NAME.0                      
  SAY 'I=' I 'NAME ' NAME.I             
END                                     

 

 

Additional Information

See the  complete syntax in the link below:

https://techdocs.broadcom.com/us/en/ca-mainframe-software/automation/ca-ops-mvs-event-management-and-automation/14-0/reference-information/command-and-function-reference/relational-data-framework-reference/sql-statements.html