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.

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.

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.

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.

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.

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.

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.