OpenAPI User Guide > OpenAPI User Guide > Introduction > What Is OpenAPI? > Differences Between OpenAPI and Other Application Programming Interfaces
Was this helpful?
Differences Between OpenAPI and Other Application Programming Interfaces
OpenAPI provides comparable functionality to Microsoft Windows ODBC and the X/Open Company SQL Call Level Interface. However, there are a few important differences, such as:
OpenAPI supports the complete function set of Ingres SQL, including FIPS 127-2 and SQL-92 Entry Level.
ODBC and SQL Call Level Interface support only X/Open SQL—an X/Open standard based on the ANSI SQL. This difference enables applications written with OpenAPI to access Ingres databases more efficiently.
OpenAPI is tailored to the C programming language.
OpenAPI uses a callback-driven method for asynchronous programming, whereas ODBC uses a polling method.
SQL Call Level Interface does not provide asynchronous programming.
Last modified date: 11/09/2022