Sybase IQ uses the names and passwords of its clients when it connects to a remote server on behalf of those clients. However, this behavior can be overridden by creating external logins. External logins are alternate login names and passwords that are used when communicating with a remote server.
When Sybase IQ connects to the remote server, INSERT...LOCATION uses the remote login for the user ID of the current connection, if a remote login has been created with CREATE EXTERNLOGIN and the remote server has been defined with a CREATE SERVER statement. If the remote server is not defined, or a remote login has not been created for the user ID of the current connection, IQ connects using the user ID and password of the current connection. For more information and an example of INSERT...LOCATION using a remote login, see INSERT statement in Reference: Statements and Options.
If you are using an integrated login, the IQ name and password of the IQ client is the same as the database login ID and password that the IQ userid maps to in syslogins.
