Using QMF

Example 3: Connecting to unlike databases

If you are working with QMF at the local DB2 UDB for OS/390 location DALLAS, and you need to create tables at the DB2 for VM database MIAMI, you must first connect to the MIAMI location.

This example assumes that you have the following release levels of DB2 for VM and DB2 installed at the various locations:

• DALLAS, DB2 UDB for OS/390 Version 7.1
• MIAMI, DB2 for VM Version 7.1

You can request a connection to the MIAMI location in two ways:

• Enter CONNECT TO MIAMI on the command line.
• Enter CONNECT ? on the command line, then enter MIAMI on the CONNECT Command Prompt panel displayed over the QMF Home panel.

The panel you see depends on the DB2 for VM release level you have installed at your location and the PROTOCOL option you use for SQLINIT.