The INSERT...LOCATION statement includes new syntax that allows users to specify the settings for options on the remote server. INSERT...LOCATION also supports use of a remote login when connecting to a remote server.
In previous versions of IQ, INSERT...LOCATION used
the user ID and password of the current connection to connect to
the remote server. In IQ 12.7, the user ID and password of
the current connection are used only if a remote login has not been
created for the user ID of the current connection.
For details, see INSERT statement in Chapter 6, “SQL Statements” in the Sybase IQ Reference Manual.