Database Manipulation

The RDM system supports multiple database APIs to read and write data to the database. Each of the APIs connect with a Database Storage Engine to access the database.

C / C++ API

The C and C++ Core Cursor APIs are the access methods to the database. C database programming is approached in a linear fashion with cleanup is handled by the developer. C++ database programming has the advantage of automatically generated access methods based on the schema definition.

SQL CLI API

The SQL CLI API is modeled after the ODBC 3.5 Specification of the API and implemented in the RDM libraries. This allows the developer to use a well documented C-API for SQL for any application on any target platform or configuration.

ODBC Driver Manager

The ODBC Driver Manager access allows for the use of third-party tools with the RDM database. This access method can be used if the database storage engine (TFS) is configured to allow remote connections.

JDBC

The Java Database Connectivity (JDBC) API provides universal data access from the Java programming language. Application developers can use the JDBC 3.0 API driver for RDM to write database applications and execute SQL statements. This access method can be used if the database storage engine (TFS) is configured to allow remote connections.