Skip to main content

SQL developers

Overview for using FairCom products as a SQL developer

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.

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.

ODBC configuration

Explanation for configuring and troubleshooting ODBC for FairCom DBSQL.

SQL operations

Advanced FairCom SQL features, options, and utilities.

Installation and error codes

The General information section provides information that applies to all products.

Section

Description

Install FairCom products

Quick and advanced installation guides.

Error codes

Complete list of FairCom error codes.

Summary for SQL Developers Using FairCom FairCom provides a robust SQL development environment through FairCom DB, supporting various tools and features for database management and optimization. Key Resources: iSQL Tutorial & CLI – Guides for using FairCom’s interactive SQL command-line utility, including automation for importing/exporting data (CSV, fixed-length files). SQL Reference – Complete guide to FairCom DB’s SQL language. Full-Text Search – Instructions for implementing advanced text search. SQL Stored Procedures – Best practices for using Java and C# to implement stored procedures and triggers. JDBC & ODBC Support: JDBC Quick Start – Tutorials for using FairCom’s JDBC driver in Java. JDBC Developer Guide – How to integrate FairCom DB’s SQL with Java applications. ODBC Quick Start & Configuration – Guides for using and troubleshooting ODBC drivers on Windows and Linux. Advanced SQL Operations: Covers optimizations, features, and utilities for managing complex database tasks.

SQL Development: iSQL, command-line utility, automation, CSV import/export Database Management: SQL language, stored procedures, triggers, full-text search Connectivity & Integration: JDBC, ODBC, FairCom DB SQL operations, optimization Advanced Features: SQL utilities, indexing, query performance tuning