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.
CONNECT DANIEL (Password=PWDANThis command sets your DB2 Server for VM user ID at MIAMI to DANIEL.
CONNECT TO DETROIT
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.
CONNECT DANIEL (Password=PWDANThis command sets your DB2 Server for VM user ID to DANIEL. Now, you connect to a DB2 UDB for z/OS DBMS (DALLAS):
CONNECT TO DALLAS
SET CURRENT SQLID = 'DANIEL'
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: