Daniel Taylor

9 views Updated January 23rd, 2026

ODBC Conformance Notes

This chapter details the ODBC functionality that FairCom DB SQL supports through the ODBC Driver.

FairCom RTG Overview

FairCom RTG documentation home

17 views Updated February 27th, 2026

RTG quick start

18 views Updated February 27th, 2026

RTG/ISAM errors

Errors specific to RTG and ISAM

19 views Updated January 16th, 2026

File maintenance with RTG

19 views Updated February 27th, 2026

RTG server setup

16 views Updated February 27th, 2026

RTG directories

31 views Updated January 28th, 2026

DB SQL functions overview

DB SQL expressions

DB SQL reserved words and error messages

DB SQL built-in stored procedures

8 views Updated February 6th, 2026

Aggregate functions

DB SQL options

FairCom DB SQL supports a variety of options that allows you to address your needs.

8 views Updated February 6th, 2026

Logical functions

Date and Time functions

8 views Updated January 27th, 2026

ISAM quick start

16 views Updated January 29th, 2026

Clustering concepts

20 views Updated January 16th, 2026

More information

9 views Updated January 22nd, 2026

ISAM data conversion

18 views Updated January 29th, 2026

RTG SQL access

16 views Updated January 28th, 2026

ISAM server setup

12 views Updated February 11th, 2026

ISAM driver installation

13 views Updated February 11th, 2026

Migrating to FairCom DB SQL

10 views Updated January 26th, 2026

DB SQL query expressions

10 views Updated January 27th, 2026

Secure topics and integration tables

Secure your topics and integration tables by managing roles

32 views Updated January 13th, 2026

Conversion functions

8 views Updated February 6th, 2026

RTG transaction support

13 views Updated March 2nd, 2026

DB SQL data types

11 views Updated January 27th, 2026

DB SQL joins

Application data setup

8 views Updated January 22nd, 2026

Combining FairCom DB SQL with ISAM

10 views Updated January 26th, 2026

Relationships tutorial

How to build table/file relationships using the FairCom DB SQL ODBC Interface

9 views Updated February 4th, 2026

SQL access to your standalone database (Overview)

9 views Updated January 22nd, 2026

Direct Link FairCom DB SQL ODBC Driver

8 views Updated February 4th, 2026

Encryption

11 views Updated February 5th, 2026

FairCom Terms Glossary

Definitions of technical terms used by FairCom products

19 views Updated January 16th, 2026

FairCom DB SQL Reserved Words

12 views Updated February 5th, 2026

FairCom DB SQL configuration keywords

Importing tables into FairCom DB SQL

10 views Updated January 23rd, 2026

ODBC quick tour

SQL language elements overview

23 views Updated January 27th, 2026

Introductory tutorial

20 views Updated January 23rd, 2026

UTF-8 data stored in RTG

16 views Updated February 10th, 2026

Users, schemas, and roles

9 views Updated January 30th, 2026

JDBC Conformance

Support for standard JDBC data types, return values, andf error messages provided by the FairCom DB SQL JDBC Driver.

JDBC record/row locking tutorial

11 views Updated January 29th, 2026

ISAM SQL access

JDBC glossary

9 views Updated February 4th, 2026

JDBC transaction processing tutorial

A-B Ethernet/IP connector errors

Allen-Bradley Ethernet/IP IoT connector error codes

15 views Updated January 16th, 2026

JDBC relationships tutorial

9 views Updated February 4th, 2026

Transaction processing tutorial

Math functions

29 views Updated January 7th, 2026

List of variant types

ISAM utilities overview

13 views Updated February 12th, 2026

Ranking functions

8 views Updated January 27th, 2026

ISAM structure elements

17 views Updated February 12th, 2026

Install DB SQL

10 views Updated January 26th, 2026

System and metadata functions

9 views Updated February 6th, 2026

RTG hot alter table

16 views Updated February 27th, 2026

DBL Java configuration

FairCom DB SQL Java Configuration for Stored Procedures, Triggers and User Defined Functions

12 views Updated February 12th, 2026

ISAM configuration file elements overview

Partitioned files with RTG

14 views Updated February 27th, 2026

Replication, Clusters, High Availability, and Disaster Recovery

15 views Updated February 27th, 2026

RTG tutorials

15 views Updated February 26th, 2026

Configurable Log Output

16 views Updated February 11th, 2026

RTG driver errors

20 views Updated March 2nd, 2026

RTG utilities overview

13 views Updated February 27th, 2026

ISAM ctmigra (conversion utility)

12 views Updated February 12th, 2026

ISAM ctutil

20 views Updated February 17th, 2026

Breaking changes

DB product feature changes that create incompatibilities with previous versions

25 views Updated March 13th, 2026

Listing connections with a particular file open

15 views Updated March 2nd, 2026

Copying server-controlled files

20 views Updated March 2nd, 2026

ctsqlimp - DB SQL Import Utility

15 views Updated February 6th, 2026

DB SQL statements

This chapter provides detailed reference material on each SQL statement.

String functions

14 views Updated March 2nd, 2026

Troubleshooting

This section provides some useful troubleshooting tips.

RTG XDD schema structure

18 views Updated March 5th, 2026

RTG setup and installation overview

14 views Updated January 28th, 2026

FairCom Edge APIs

FairCom Edge's API documentation for software developers, equipment manufacturers, and automation engineers

25 views Updated January 13th, 2026

Upgrade files to RTG 5 attribute resource format (Unified Data Types)

16 views Updated February 11th, 2026

RTG performance tuning

19 views Updated March 2nd, 2026

RTG configuration

18 views Updated January 28th, 2026

Configuring FairCom DB SQL Data Sources

26 views Updated January 23rd, 2026

Advanced ISAM techniques

12 views Updated January 30th, 2026

DB SQL Features

This chapter explains the important features provided by FairCom DB SQL.

10 views Updated February 5th, 2026

FairCom DB SQL built-in stored procedures

ctutil

19 views Updated February 27th, 2026

xddgen

14 views Updated February 27th, 2026

RTG settings elements

23 views Updated March 2nd, 2026

ODBC driver errors

FairCom ODBC Driver error codes are returned by FairCom's ODBC driver

13 views Updated February 9th, 2026

Data replication errors

FairCom Data Replication error codes are returned by the Data Replication APIs and Replication Manager application

18 views Updated February 9th, 2026

Other RTG utilities

16 views Updated February 27th, 2026

ThingWorx Troubleshooting

Troubleshoot ThingWorx errors

21 views Updated January 14th, 2026

RTG configuration file overview

17 views Updated March 2nd, 2026

RTG structure elements

19 views Updated March 2nd, 2026

RTG runtime drivers

19 views Updated February 27th, 2026

DB SQL types SDK sverview

7 views Updated February 5th, 2026

Field conversion example

8 views Updated January 26th, 2026

FairCom ISAM overview

FairCom ISAM documentation home

18 views Updated January 21st, 2026

DBQL with Callbacks

12 views Updated January 29th, 2026

ISAM setup

ISAM configuration

17 views Updated February 11th, 2026

Replicating RTG file operations

15 views Updated February 10th, 2026

Date-Time format strings