DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide

Coding Methods for Distributed Data

There are different ways of accessing distributed data and there are also considerations for preparing and binding programs that will be executing statements against this data. We will take a look at connect options, program preparation, and bind options, as well as additional considerations for coordinating updates.

Three-Part Names

You can use three-part table names to access data at a remote location through DRDA access or DB2 private protocol access. When you use three-part table names, the way you code your application is the same, regardless of the access method you choose. You determine the access method when you bind the SQL statements into a package or plan. If you use DRDA access, you must bind the ...