Remote data access enhancements

Remote Data Access now names remote connections Remote Data Access connections made via ODBC are now given names, so that they can be dropped.

For more information, see “Managing remote data access connections” in Sybase IQ System Administration Guide.

New sp_remote_primary_keys stored procedure In order to obtain primary key information about remote tables using remote data access, a new stored procedure called sp_remote_primary_keys has been added.

To gain the benefits of this enhancement on databases created before this release, you must upgrade the database using ALTER DATABASE UPGRADE.

For more information, see “sp_remote_primary_keys system procedure” in Sybase IQ Reference Manual.

sp_remote_tables system procedure A new argument, tabletype, has been added to the sp_remote_tables stored procedure. This argument returns the remote table's type.

For more information about the tabletype argument, see “sp_remote_tables system procedure” in Sybase IQ Reference Manual.

Remote Data Access now handles UUID/GUID columns Remote Data Access can now manage SQL Server unique identifier columns. For more information, see “Server class mssodbc” in Sybase IQ System Administration Guide.