Using QMF

Connecting to a remote database using the QMF CONNECT command

Use the QMF CONNECT command to connect to a remote database during a QMF session.

You can issue the CONNECT command from:

• The command line
• Within a procedure (linear or with logic)
• The callable or command interface

For more information on procedures, see Chapter 8, Creating a Procedure to Run QMF Commands. For more information on the callable or command interface, see Developing QMF Applications, SC26-4722-05. Before connecting to the remote database, QMF completes any work (for example, a large report) at the current location.

To use the CONNECT command:

1. If you need help with the syntax of the CONNECT command, enter:

   CONNECT ?
   

   The CONNECT Command Prompt panel displays:

   
   

   +--------------------------------------------------------------------------------+
   | ______________________________________________________________________________ |
   | +-----------------------------------------------------------------------------+|
   | |                           CONNECT Command Prompt                            ||
   | |                                                              1  to 10 of 10 ||
   | | Userid   (          )                                                       ||
   | |          Enter the SQL/DS userid on whose authority the connection          ||
   | |          is to be made.                                                     ||
   | |                                                                             ||
   | | Password (          )                                                       ||
   | |          Enter the SQL/DS password that allows you to connect to the        ||
   | |          database using the authority of the userid named above.            ||
   | | TO                                                                          ||
   | | Location (                    ) +                                           ||
   | |          Enter the location name to which you want to connect.              ||
   | +-----------------------------------------------------------------------------+|
   | | F1=Help  F3=End  F4=List  F7=Backward  F8=Forward                           ||
   | +-----------------------------------------------------------------------------+|
   |                                                                                |
   | Type command on command line or use PF keys. For help, press PF1 or type HELP. |
   | ______________________________________________________________________________ |
   +--------------------------------------------------------------------------------+

2. Type the information you need to connect to the remote database.

   If a plus sign appears after the Location field, you can press the List function key to display a list of database names. (If you use QMF in the VM environment, the list contains only databases that are specified in the communications directories. It does not necessarily contain all the databases to which you can connect. In VSE it is the DBName directory. If a database is not specified here a connection cannot occur.)

If you select a database from the list, but can not connect to it, check that:

• You have the authority to connect to the database
• The database location supports remote unit of work
• The database is actually up and running

For more information on the CONNECT command, see the QMF Reference, SC26-4716-05 .