Using QMF

Reconnecting to a location

You can reconnect to a remote database if the connection is lost. The steps you need to take to reconnect may vary depending on how you are issuing your QMF commands. You can issue QMF commands in any of the following ways:

• Enter QMF commands interactively (by entering a command on the QMF command line or by using a function key)
• Run either a linear procedure or a procedure with logic that contains QMF commands
• Run a batch application that contains QMF commands

Reconnecting if you are entering QMF commands interactively

If you are entering QMF commands interactively and the connection to the remote location is lost, the Lost Connection Prompt panel displays.

To reconnect to the remote database:

1. Type 1 to reconnect to the remote database, or type 2 to exit QMF.

   If you type 1 to reconnect to the remote database, the CONNECT Command Prompt panel displays.

   The name of the location to which you were previously connected appears in the TO Location field. If you are using SQL/DS, your user ID appears in the Userid field.

2. Enter the information you need to reconnect to the remote database.

   If QMF cannot connect to the location you specify, the CONNECT Command Prompt panel displays so you can try to connect again.

Reconnecting if you are running QMF commands in a procedure

If you are running QMF commands in a linear procedure and the connection to the remote location is lost, the procedure ends. If you are running the procedure interactively, the Lost Connection Prompt panel displays so you can reconnect.

If you are running QMF commands in a procedure with logic, the logic of the procedure determines how the procedure ends. When the procedure finishes, and if you are running the procedure interactively, the Lost Connection Prompt panel displays so you can reconnect.

Reconnecting if you are running QMF commands in a batch application

If you are entering QMF commands in a batch application and the connection to the remote location is lost, QMF ends.

To reconnect to the remote location:

1. Start your QMF session.
2. Unless you automatically connect to the remote database when you start QMF, use the CONNECT command to connect to the remote database.

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

What you can expect when you reconnect

If you are using the Table Editor to update a remote database, and you lose the connection to the database, any updates you have not saved are lost.

If you are running QMF commands from a list of database objects, and the connection to that database is lost, the database list is obsolete. You can still display the list, but if you type a command on the list, you get an error.