Notes

• Connecting to a database server resets the database authorization ID.
• The default database authorization ID for each server is system defined.
• The database authorization ID at a DB2 for OS/390 server can be changed by running a QMF SQL Query with a SET CURRENT SQLID statement. For example:

    SET CURRENT SQLID = 'QMFADM'

  The QMF session is connected to a DB2 for OS/390 server when the global variable DSQAO_DB_MANAGER has the value of 2.

• The database authorization ID cannot be changed when the global variable DSQAO_DB_MANAGER has a value other than 2.
• Differences between the CONNECT command and the DSQSDBNM program parameter:
  • The DSQSDBNM parameter establishes the initial database server used for the QMF session.
  • The CONNECT command changes the database server after a QMF session is established.
• The SQL CONNECT statement cannot be used in a QMF query.