DB2 graphic  QMF Version 8

Connecting to DB2 or DB2 Server for VSE and/or VM databases within a distributed network

When you connect to a remote location, it becomes your current location. These connections can be made between like (DB2 -DB2) and unlike (DB2 Server for VSE and/or VM) locations. You can establish this connection during QMF initialization by using the DSQSDBNM program parameter of the START command or from within a QMF session with the QMF CONNECT command.

When you are connected to a remote location, all SQL statements you issue (except CONNECT) are directed to the database at the remote location for processing. Therefore, you can access data and QMF objects at a remote location in the same way you would access data and objects at your own location. For example, you can create a table or replace comments on a table at a remote location by first connecting to that location with remote unit of work.

Note:QMF does not support connection to a database containing a QMF object table that has an authorization ID with a maximum length shorter than the current authorization ID being used for the connection. For example, if your current authorization ID is "A23456789" and you are trying to connect to a database that contains QMF object tables that have an authorization ID with a maximum length of 8, an error will be returned and no connection to the database will be made.


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