Skip to main content

SQL APIs

List of FairCom SQL APIs and guides for developers, programming languages, and environments

Abstract

This page includes a list of SQL APIs and Guides for a variety of developers, programming languages, and environments. SQL is available in all FairCom products that include the FairCom database engine.

This page includes a list of SQL APIs and Guides for a variety of developers, programming languages, and environments. SQL is available in all FairCom products that include the FairCom database engine.

SQL developer guides

Section	Description
ISQL tutorial	Tutorials for using FairCom's interactive SQL command line utility (iSQL).
ISQL CLI	Guide for automating database operations using FairCom's iSQL command line utility and for importing and exporting data using variable-length and fixed-length flat files — such as CSV.
SQL reference	FairCom DBSQL language reference guide.
Full text search	Guide for using the full-text search.
SQL stored procedures	Guide for using Java and C# to implement SQL stored procedures and triggers.
Java stored procedures	Tutorial for using Java to implement SQL stored procedures and triggers in .
C# stored procedures	Tutorial for using the C# to implement SQL stored procedures in FairCom DB.
JDBC quick start	Tutorials for using FairCom's JDBC driver in Java.
JDBC developer guide	Guide for using the JDBC driver with FairCom DBSQL in order to use SQL in Java applications (ideal for client-server applications that run in the same data center as the database).
ODBC quick start	Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DBSQL.
Direct SQL	Guidelines for FairCom DBDirect SQL developers.
JSON DB API	The `"getRecordsUsingSQL"` and `"runSqlStatements"` actions embed SQL in JSON Action calls over HTTPS and return results as JSON.
ODBC configuration	Explanation for configuring and troubleshooting ODBC for FairCom DBSQL.
SQL operations	Advanced FairCom SQL features, options, and utilities.
SQL error codes	Complete list of SQL error codes.

SQL guides for C and C++ programmers

Section	Description
Direct SQL	Guidelines for FairCom DBDirect SQL developers.
JSON DB API	The `"getRecordsUsingSQL"` and `"runSqlStatements"` actions embed SQL in JSON Action calls over HTTPS and return results as JSON.
SQL operations	Advanced FairCom SQL features, options, and utilities.

SQL guides for Java developers

Section	Description
JDBC quick start	Tutorials for using FairCom's JDBC driver in Java.
JDBC developer guide	Guide for using the JDBC driver with FairCom DBSQL in order to use SQL in Java applications (ideal for client-server applications that run in the same data center as the database).
JSON DB API	The `"getRecordsUsingSQL"` and `"runSqlStatements"` actions embed SQL in JSON Action calls over HTTPS and return results as JSON.
Java stored procedures	Tutorial for using Java to implement SQL stored procedures and triggers in .
SQL operations	Advanced FairCom SQL features, options, and utilities.

SQL guides for C# and Visual Basic developers

Section	Description
ODBC quick start	Tutorials for using FairCom's Windows and Linux ODBC driver with FairCom DB.
ADO.NET API	Guide for using SQL with FairCom DB.
JSON DB API	The `"getRecordsUsingSQL"` and `"runSqlStatements"` actions embed SQL in JSON Action calls over HTTPS and return results as JSON.
C# stored procedures	Tutorial for using the C# to implement SQL stored procedures in FairCom DB.
SQL stored procedures	Guide for using Java and C# to implement SQL stored procedures and triggers.
ODBC configuration	Explanation for configuring and troubleshooting ODBC for FairCom DBSQL.
SQL operations	Advanced FairCom SQL features, options, and utilities.

SQL guides for Python developers

Section	Description
Python quick start	Tutorials for using SQL with FairCom DB.
SQLAlchemy API	Guide for using SQL with FairCom DB.
ODBC configuration	Explanation for configuring and troubleshooting ODBC for FairCom DBSQL.
JSON DB API	The `"getRecordsUsingSQL"` and `"runSqlStatements"` actions embed SQL in JSON Action calls over HTTPS and return results as JSON.

SQL guides for PHP developers

Section	Description
PDO quick start	Tutorials for using PHP PDO with FairCom DB.
ODBC configuration	Explanation for configuring and troubleshooting ODBC for FairCom DBSQL.
JSON DB API	The `"getRecordsUsingSQL"` and `"runSqlStatements"` actions embed SQL in JSON Action calls over HTTPS and return results as JSON.