Using QMF CONNECT within a procedure

The QMF CONNECT command lets you connect to another user ID or to a remote DB2^(R) database to use the remote unit of work support. You can use this command within a linear procedure or a procedure with logic.

When you write procedures that use the QMF CONNECT command to access remote databases, be aware of the following:

• If you are connected to a remote database and issue a RUN PROC command, that procedure and all the objects used in that procedure must be stored at the remote database.
• All QMF commands in the procedure are run in QMF temporary storage at the system where QMF is running (the local system). However, all objects used by these QMF commands (such as queries, procedures, or forms) must be defined in the database at the current location (the remote system).

  For more information about using the QMF CONNECT command and remote unit of work support, see QMF Reference (for command syntax).

• All commands that affect the database (for example, SQL statements, QMF queries, or EDIT TABLE updates) run at the current location.
• If the procedure contains system-specific commands (CICS, CMS, or TSO), these commands run at the system where QMF is running (the local system).

  If your procedures contain system-specific commands that do not run on the system where QMF runs, your procedure does not run successfully.

• Any files or data sets used in a system-specific command must exist on the system where QMF is running (the local system).