Increased security for INSERT...LOCATION

The new INSERT...LOCATION statement parameter ENCRYPTED PASSWORD allows you to specify the use of password encryption when connecting to a remote server that supports Open Client Library default password encryption, such as Adaptive Server Enterprise.

When you connect to Adaptive Server Enterprise using INSERT...LOCATION, Sybase IQ identifies itself as the connecting program in the sysprocesses table in the ASE master database.

For more information on INSERT...LOCATION, see Chapter 6, “SQL Statements” in the Sybase IQ Reference Manual.