DB2 graphic  QMF Version 8

Example 1: How connecting to a new location affects your user ID

DB2 Server for VM application requester and a DB2 for VM application server: When you connect to a new location, your DB2 Server for VM user ID is not in effect after a connection to a different location. Instead, it is based on the VM logon ID at the previous location.

DB2 Server for VM application requester and a DB2 UDB for z/OS application server: You can set your user ID to DANIEL at a new location by using the SET CURRENT SQLID SQL statement, if your DBMS at that location is DB2 UDB for z/OS, and you are connected to that location.

Because SET CURRENT SQLID is an SQL statement, you issue it through an SQL statement. Consequently, the following restrictions apply to the user ID you specify:


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