DB2 graphic  QMF Version 8

Examples

  1. To display the CONNECT command prompt panel:
      CONNECT ?
  2. To connect to a remote database server with a location name of MIAMI:
      CONNECT TO MIAMI
  3. (VSE only) To change the database user to "QMFADM", having a password of "A12ZDT":
      CONNECT "QMFADM" ( PASSWORD="A12ZDT"
  4. (VSE only) To connect to another location and change the database user:
      CONNECT QMFADM TO MIAMI ( PASSWORD=A12ZDT

Using the CONNECT command in a QMF procedure

You must use double quotes to continue an authorization ID across more than one line within a QMF linear procedure. All continuation lines must have a plus sign (+) in column one:

Figure 4. Continuing an authorization ID across more than one line in a QMF linear procedure

PROC                       Test_Connect                         MODIFIED LINE   1
 CONNECT "A234567890123456789012345678901234567890123456789012345678901234567890
 +1234567890123456789012345678901234567890123456789012345678" (PASSWORD=XYZ)

How connecting to a new location affects your support for long names

When you connect to a new location or the initial location when starting QMF, support for long names is dependent on the database limits and QMF object tables that are in effect for the database that you are connecting to:


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004