Distributed unit of work access (DB2 for OS/390 only)

If your current location is a DB2 for OS/390 database, you can read and update tables and views managed by remote DB2 for OS/390 databases that are part of the communications network defined to your local DB2 for OS/390 database. You cannot access queries, procedures, or forms at a remote location.

In your query, you can specify a remote table or view by using a three-part name or an alias. A three-part name includes the name of the location where the table exists, the name of the table owner, and the name of the table. The parts are separated by periods:

NEW_YORK.JBP.STAMPS

An alias is a locally defined name used to refer to a table or view at the same or a remote DB2 for OS/390 database. You can list aliases that are owned by your primary and current DB2 authorization IDs. Authorization to use the table or the view to which the alias refers is checked when you use the alias in queries or QMF commands.

You can access remote tables or views with the following commands:

Command

Restrictions

DISPLAY

Must use TABLE object type

DRAW

Must use TABLE object type

EDIT

None

EXPORT

Must use TABLE object type

IMPORT

Must use TABLE object type

PRINT

None

SAVE

Must use DATA object type

You can replace a remote table using a SAVE or IMPORT command.