I would like to know if anyone could provide an example of a remote call to a server (with specific connect string, etc) from a mainframe PL/1 program. I would like to send a specific account number to the server and bring back addressing information to populate a file layout.

I believe we are going to use either MQSeries or a DRDA call to the database.

The basic SQL syntax if the table would reside on mainframe:

Select First_name
,Last_name
,Address
,City
,State
,Zip
into :First_name
,:Last_name
,:Address
,:City
,tate
,:Zip
from table
where account_number = :account_number;

Thanks in advance.