Daniel Taylor
dan.taylor@faircom.com
Articles by Daniel
-
-
C API Functions M
161 views Updated August 26th, 2026 -
Users, schemas, and roles
322 views Updated May 15th, 2026 -
LDAP
65 views Updated August 11th, 2026 -
Commit
219 views Updated August 13th, 2026 -
cpybuf
200 views Updated May 12th, 2026 -
ctfcpCopyFile
185 views Updated May 12th, 2026 -
ctGetNullKeyValue
180 views Updated May 12th, 2026 -
ctGetIsamFileNbr
185 views Updated May 12th, 2026 -
RTG Breaking Changes and Compatibility
26 views Updated November 13th, 2026 -
Internationalization Support
Key encoding concepts, supported charsets, function signatures, upgrade/migration guidelines, and runtime conversion behaviors
66 views Updated November 9th, 2026 -
ctGetAccountExpirationTime
194 views Updated May 12th, 2026 -
ctfiltercbRemoveFilter
189 views Updated May 12th, 2026 -
RTG troubleshooting
This section provides some useful troubleshooting tips.
384 views Updated August 17th, 2026 -
DB Function Descriptions T
480 views Updated July 24th, 2026 -
C API Functions I
224 views Updated August 26th, 2026 -
Begin
234 views Updated August 13th, 2026 -
ctFILMTX
201 views Updated May 12th, 2026 -
ISAM server setup
529 views Updated March 26th, 2026 -
DB SnapShot Function
99 views Updated August 28th, 2026 -
ISAM settings elements
653 views Updated October 23rd, 2026 -
ctfiltercb_rowl
199 views Updated May 12th, 2026 -
ISAM logging, error codes, and troubleshooting
641 views Updated March 27th, 2026 -
MQ releases
Explore FairCom MQ releases, featuring enhancements and new capabilities.
378 views Updated November 5th, 2026 -
MQ Breaking Changes and Compatibility
20 views Updated November 13th, 2026 -
C API Functions R
248 views Updated August 26th, 2026 -
DB Function Descriptions Q
289 views Updated July 22nd, 2026 -
Edge Breaking Changes and Compatibility
19 views Updated November 13th, 2026 -
Basic JDBC driver operations
360 views Updated May 19th, 2026 -
clearTranError
205 views Updated May 12th, 2026 -
ctFILBLK
215 views Updated May 12th, 2026 -
Application data setup (standalone SQL)
397 views Updated August 24th, 2026 -
C API Functions V
178 views Updated August 25th, 2026 -
C API Functions H
161 views Updated August 24th, 2026 -
Migration, Troubleshooting, and Glossary for FairCom ODBC
304 views Updated August 24th, 2026 -
DB Function Descriptions R
686 views Updated July 24th, 2026 -
C API Functions E
156 views Updated August 25th, 2026 -
Partitioned files with RTG
509 views Updated July 7th, 2026 -
AddCtResource
190 views Updated July 30th, 2026 -
C API Functions G
421 views Updated October 14th, 2026 -
DB Function Descriptions G
804 views Updated July 21st, 2026 -
Migrating to FairCom DB SQL
374 views Updated May 18th, 2026 -
Math functions
308 views Updated May 14th, 2026 -
DB Function Descriptions D
637 views Updated July 20th, 2026 -
DB Function Descriptions I
442 views Updated July 21st, 2026 -
DB SQL Features
This chapter explains the important features provided by FairCom DB SQL.
545 views Updated May 18th, 2026 -
Clustering concepts
565 views Updated January 16th, 2026 -
C API Functions S
550 views Updated November 11th, 2026 -
ctsqlimp - DB SQL Import Utility
525 views Updated May 18th, 2026 -
DB Breaking Changes and Compatibility
33 views Updated November 13th, 2026 -
ISAM Breaking Changes and Compatibility
27 views Updated November 13th, 2026 -
ISQL Statement Descriptions
542 views Updated August 13th, 2026 -
DB Function Descriptions C
1540 views Updated November 19th, 2026 -
Replication, Clusters, High Availability, and Disaster Recovery
522 views Updated February 27th, 2026 -
DB Function Descriptions L
548 views Updated August 21st, 2026 -
DB SQL built-in stored procedures
518 views Updated May 14th, 2026 -
DB Function Descriptions U
500 views Updated July 24th, 2026 -
DB Function Descriptions E
386 views Updated July 20th, 2026 -
DB Function Descriptions B
442 views Updated July 15th, 2026 -
FairCom DB SQL configuration keywords
629 views Updated October 15th, 2026 -
DB Function Descriptions F
446 views Updated July 21st, 2026 -
Ranking functions
469 views Updated August 14th, 2026 -
forwardToExternalBrokers
447 views Updated October 13th, 2026 -
RTG driver errors
536 views Updated March 2nd, 2026 -
DB Function Descriptions A
542 views Updated July 15th, 2026 -
RTG ctutil
778 views Updated August 12th, 2026 -
DB Releases
Explore FairCom DB releases, featuring enhancements and new capabilities.
807 views Updated November 5th, 2026 -
RTG configuration overview
615 views Updated August 17th, 2026 -
DB Function Descriptions K
381 views Updated July 21st, 2026 -
Search Conditions
419 views Updated May 15th, 2026 -
DB Function Descriptions S
847 views Updated September 16th, 2026 -
DB Function Descriptions N
474 views Updated July 22nd, 2026 -
Database Integrity Utilities Overview
48 views Updated October 27th, 2026 -
ISAM ctutil
649 views Updated August 12th, 2026 -
DB Function Descriptions W
461 views Updated August 21st, 2026 -
Logical functions
440 views Updated May 15th, 2026 -
Combining FairCom DB SQL with ISAM
564 views Updated May 18th, 2026 -
DB SQL identifiers
471 views Updated May 15th, 2026 -
CreateISAM
207 views Updated May 12th, 2026 -
RTG performance tuning
515 views Updated August 12th, 2026 -
Other RTG utilities
691 views Updated July 16th, 2026 -
RTG server setup
634 views Updated August 12th, 2026 -
ODBC driver errors
FairCom ODBC Driver error codes are returned by FairCom's ODBC driver
372 views Updated February 9th, 2026 -
ISAM configuration
606 views Updated July 16th, 2026 -
RTG structure elements
554 views Updated August 12th, 2026 -
Field conversion example
300 views Updated May 14th, 2026 -
Standalone SQL encryption
322 views Updated August 24th, 2026 -
ISAM cttrnmod (change transaction mode utility)
485 views Updated January 30th, 2026 -
RTG tutorials
504 views Updated August 12th, 2026 -
Conversion functions
450 views Updated May 15th, 2026 -
ISAM overview
FairCom ISAM documentation home
421 views Updated August 17th, 2026 -
Configuring FairCom DB SQL Data Sources
719 views Updated May 14th, 2026 -
Aggregate functions
304 views Updated May 15th, 2026 -
RTG XDD schema structure
713 views Updated March 24th, 2026 -
FairCom Terms Glossary
Definitions of technical terms used by FairCom products
791 views Updated August 14th, 2026 -
ISAM structure elements
634 views Updated November 20th, 2026 -
deadbandLowerLimit
447 views Updated October 13th, 2026 -
ctmigra (ISAM conversion utility)
327 views Updated October 27th, 2026 -
RTG utilities overview
331 views Updated August 14th, 2026 -
ODBC Conformance Notes
This chapter details the ODBC functionality that FairCom DB SQL supports through the ODBC Driver.
351 views Updated May 14th, 2026 -
newTagName
422 views Updated October 13th, 2026 -
Data replication errors
FairCom Data Replication error codes are returned by the Data Replication APIs and Replication Manager application
336 views Updated February 9th, 2026 -
Configurable Log Output
319 views Updated February 11th, 2026 -
atEnd
465 views Updated August 24th, 2026 -
length
454 views Updated October 13th, 2026 -
Configure modbus to output data to a device
258 views Updated January 9th, 2026 -
ISAM ctfileid (update file IDs)
477 views Updated March 27th, 2026 -
RTG data conversion
816 views Updated March 2nd, 2026 -
RTG/ISAM errors
Errors specific to RTG and ISAM
552 views Updated January 16th, 2026 -
Relationships tutorial
How to build table/file relationships using the FairCom DB SQL ODBC Interface
308 views Updated May 14th, 2026 -
RTG directories
519 views Updated January 28th, 2026 -
ISAM SQL access
622 views Updated August 12th, 2026 -
DB SQL query expressions
510 views Updated August 14th, 2026 -
ISAM setup
537 views Updated January 29th, 2026 -
DB SQL expressions
469 views Updated May 15th, 2026 -
DB SQL types SDK sverview
278 views Updated May 14th, 2026 -
Transaction processing tutorial
302 views Updated May 14th, 2026 -
Record/row locking tutorial
307 views Updated May 14th, 2026 -
Replicating RTG file operations
338 views Updated February 10th, 2026 -
ThingWorx Troubleshooting
Troubleshoot ThingWorx errors
517 views Updated August 20th, 2026 -
DBQL with Callbacks
400 views Updated May 18th, 2026 -
UTF-8 data stored in RTG
310 views Updated February 10th, 2026 -
jsonActionApiDefaults
416 views Updated October 13th, 2026 -
FairCom DB SQL Reserved Words
285 views Updated May 14th, 2026 -
JDBC relationships tutorial
298 views Updated May 14th, 2026 -
DBL Java configuration
FairCom DB SQL Java Configuration for Stored Procedures, Triggers and User Defined Functions
447 views Updated May 14th, 2026 -
mqttPayloadType
477 views Updated August 24th, 2026 -
ISAM substitution specifiers
474 views Updated January 29th, 2026 -
List of variant types
Explore supported types of variants, understanding of their significance and use cases.
367 views Updated September 11th, 2026 -
DB SQL data types
492 views Updated May 15th, 2026 -
The RTG configuration file
536 views Updated August 17th, 2026 -
RTG transaction support
522 views Updated August 12th, 2026 -
Install Standalone SQL
343 views Updated May 18th, 2026 -
More information on Standalone SQL
310 views Updated August 24th, 2026 -
Upgrade files to RTG 5 attribute resource format (Unified Data Types)
711 views Updated October 16th, 2026 -
ISAM utilities overview
345 views Updated August 12th, 2026 -
JDBC record/row locking tutorial
287 views Updated May 14th, 2026 -
RTG Overview
FairCom RTG documentation home
355 views Updated August 17th, 2026 -
JDBC Conformance
Support for standard JDBC data types, return values, andf error messages provided by the FairCom DB SQL JDBC Driver.
305 views Updated May 19th, 2026 -
Date-Time format strings
417 views Updated May 14th, 2026 -
includeThingProperties
413 views Updated August 24th, 2026 -
JDBC transaction processing tutorial
305 views Updated May 14th, 2026 -
xddgen
577 views Updated September 9th, 2026 -
Copying server-controlled files
541 views Updated March 2nd, 2026 -
ISAM configuration file elements overview
541 views Updated March 27th, 2026 -
Install DB SQL
427 views Updated May 18th, 2026 -
Advanced ISAM techniques
547 views Updated January 30th, 2026 -
SQL language elements overview
450 views Updated May 14th, 2026 -
Btrieve compatibility
602 views Updated February 4th, 2026 -
RTG hot alter table
494 views Updated February 27th, 2026 -
System and metadata functions
470 views Updated May 14th, 2026 -
RTG quick start
532 views Updated July 22nd, 2026 -
DB Function Descriptions P
560 views Updated July 22nd, 2026 -
DB SQL options
FairCom DB SQL supports a variety of options that allows you to address your needs.
569 views Updated June 10th, 2026 -
C API Functions B
200 views Updated October 13th, 2026 -
C API Functions A
316 views Updated October 13th, 2026 -
ISAM data conversion
599 views Updated August 12th, 2026 -
RTG settings elements
712 views Updated October 16th, 2026 -
C API Functions T
260 views Updated August 26th, 2026 -
C API Functions C
251 views Updated August 25th, 2026 -
String functions
352 views Updated May 15th, 2026 -
ISAM quick start
531 views Updated August 12th, 2026 -
autoValue
594 views Updated August 24th, 2026 -
DB SQL statements
This chapter provides detailed reference material on each SQL statement.
862 views Updated November 19th, 2026 -
Importing tables into FairCom DB SQL
330 views Updated May 18th, 2026 -
C API Functions L
172 views Updated August 26th, 2026 -
FairCom Edge APIs
FairCom Edge's API documentation for software developers, equipment manufacturers, and automation engineers
427 views Updated November 2nd, 2026 -
C API Functions Alphabetical List
67 views Updated August 10th, 2026 -
RTG SQL access
899 views Updated May 12th, 2026 -
JDBC glossary
295 views Updated May 14th, 2026 -
ISAM Releases
527 views Updated November 5th, 2026 -
SQL access to your standalone database (Overview)
339 views Updated October 31st, 2026 -
RTG runtime drivers
614 views Updated August 12th, 2026 -
DB SQL joins
452 views Updated May 14th, 2026 -
DB SQL utilities list
489 views Updated May 18th, 2026 -
C API Functions P
150 views Updated August 24th, 2026 -
C API Functions D
321 views Updated August 25th, 2026 -
DB Function Descriptions V
377 views Updated July 24th, 2026 -
Partitioned Files (ISAM for C)
262 views Updated October 15th, 2026 -
C API Functions W
165 views Updated August 25th, 2026 -
RTG Releases
472 views Updated November 13th, 2026 -
Which functions are safe?
267 views Updated May 14th, 2026 -
DB SQL system catalog tables
318 views Updated May 14th, 2026 -
More ISAM utilities
500 views Updated March 27th, 2026 -
ISAM XDD schema structure
756 views Updated March 27th, 2026 -
ISAM driver installation
480 views Updated February 11th, 2026 -
RTG substitution specifiers
517 views Updated February 10th, 2026 -
Date and Time functions
367 views Updated May 15th, 2026 -
ODBC quick tour
427 views Updated October 22nd, 2026 -
deadbandUpperLimit
438 views Updated October 13th, 2026 -
JDBC Introductory tutorial
501 views Updated August 21st, 2026 -
includeInputConnectorProperties
421 views Updated August 24th, 2026 -
File maintenance with RTG
338 views Updated February 27th, 2026 -
A-B Ethernet/IP connector errors
Allen-Bradley Ethernet/IP IoT connector error codes
344 views Updated January 16th, 2026 -
normalLowerLimit
418 views Updated October 13th, 2026 -
DB SQL reserved words and error messages
303 views Updated May 15th, 2026 -
Direct Link FairCom DB SQL ODBC Driver
582 views Updated May 14th, 2026 -
Listing connections with a particular file open
294 views Updated March 2nd, 2026 -
includeTopicProperties
423 views Updated August 24th, 2026 -
DB Function Descriptions O
428 views Updated July 22nd, 2026 -
C API Functions F
228 views Updated October 13th, 2026 -
DB SQL functions overview
293 views Updated May 14th, 2026 -
C API Functions U
211 views Updated October 13th, 2026 -
RTG setup and installation overview
351 views Updated January 28th, 2026 -
C API Functions N
188 views Updated August 26th, 2026 -
C API Functions O
186 views Updated August 26th, 2026 -
C API Functions J
161 views Updated August 24th, 2026 -
includeOutputConnectorProperties
418 views Updated August 24th, 2026 -
fixedLengthCharFormat
487 views Updated August 24th, 2026 -
binaryFormat
495 views Updated October 13th, 2026