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:
- 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 DB2 QMF Reference.
- Commands that affect the database (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 will 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).
