Examples
- To display the CONNECT command prompt panel:
CONNECT ?
- To connect to a remote database server with a location name
of MIAMI:
CONNECT TO MIAMI
- (VSE only) To change the database user to "QMFADM", having a
password of "A12ZDT":
CONNECT "QMFADM" ( PASSWORD="A12ZDT"
- (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:
- The length of the authorization ID used on the connection must
not be longer than either the authorization ID supported by the
database or the authorization ID supported by the QMF control tables.
- The maximum length of table names is dependent on the maximum
length supported by the database that you are connecting to.
- The maximum length of table column names is dependent on the
maximum length supported by the database that you are connecting
to.
- The maximum length of QMF object names is dependent on the maximum length
supported by the QMF control tables (18 bytes for QMF Version 7.2 and
earlier; 128 bytes for DB2 QMF Version 8.1 control tables after
migration to long name QMF object tables).
