Programming techniques for accessing remote servers

As the chapter introduction explains, you can connect to a remote server in different ways. You can code an application that uses DRDA to access data at a remote location by using these methods:

  • CONNECT statements

  • Three-part names and aliases

Using CONNECT statements provides application portability across all IBM clients and requires that the application manage connections. Using three-part object names and aliases provides the application with location transparency; objects can move to a new location without requiring changes to the application. Instead, the DBMS manages the underlying connections.

Using either method, you must bind the DBRMs for the SQL statements that are to execute at the ...

Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.