Bookmark and bulk support for ODBC and OLE DB

Sybase supports bookmarks and SQL bulk operations for the ODBC Driver and the OLE DB Provider.

For the ODBC Driver

Sybase supports bulk insertions that use SQLBulkOperations with the option of SQL_ADD and cursor positioned updates & deletes using SQLSetPos (SQL_UPDATE, SQL_DELETE, SQL_POSITION). For instructions on using SQL_ADD and SQLSetPos, refer to the Microsoft Developer Network library’s ODBC Programmer’s Reference:

For the OLE DB Provider

Sybase supports bookmark operations that use the IRowsetLocate interface, which provides methods for comparing bookmarks and retrieving rows, based on bookmarks. For instructions on using IRowsetLocate, refer to the MSDN OLE DB Programmer’s Reference.