INSERT...LOCATION statement enhancements

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.

NoteIn 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.