ArcSDE provides three API’s for accessing data in a versioned database; C, Java, and SQL.

The ArcSDE C and Java Versioning APIs provide full access to the version and state objects. This C Versioning API follows the traditional ArcSDE API coding conventions, providing SE_versioninfo and SE_stateinfo objects for accessing version and state properties. The standard ArcSDE alter, create, delete, and list functions are provided for states and versions, as well as specialized methods for these objects. The Java API provides the same functionality as the C API. A few additional functions are provided in the APIs for setting versions on stream queries, to set difference filters on stream queries, and to determine if an ArcSDE registered table is versioned.

The Native SQL access provides a single SQL Stored Procedure to set the desired version—all insert, update, delete, and query operations will be processed against that version.

Entities:

Version

State