Assigns an alternate login name and password to be used when communicating with a remote server.
CREATE EXTERNLOGIN login-name TO remote-server REMOTE LOGIN remote-user [ IDENTIFIED BY remote-password ]
CREATE EXTERNLOGIN dba TO sybase1 REMOTE LOGIN sa IDENTIFIED BY 4TKNOX
Changes made by CREATE EXTERNLOGIN do not take effect until the next connection to the remote server.
By default, SAP Sybase IQ uses the names and passwords of its clients whenever it connects to a remote server on behalf of those clients. CREATE EXTERNLOGIN assigns an alternate login name and password to be used when communicating with a remote server. It stores the password internally in encrypted form.
The remote_server must be known to the local server by an entry in the ISYSSERVER system table. For more information, see the CREATE SERVER Statement.
Creating a remote login with the CREATE EXTERNLOGIN statement and defining a remote server with a CREATE SERVER statement sets up an external login and password for the INSERT...LOCATION such that any user can use the login and password in any context. This avoids possible errors due to inaccessibility of the login or password, and is the recommended way to connect to a remote server.
Sites with automatic password expiration should plan for periodic updates of passwords for external logins.
CREATE EXTERNLOGIN cannot be used from within a transaction.
The remote-user and remote-password combination must be valid on remote-server.