Daniel Taylor
dan.taylor@faircom.com
Articles by Daniel
-
-
The RTG configuration file
459 views Updated August 17th, 2026 -
DB Function Descriptions V
298 views Updated July 24th, 2026 -
MQ releases
Explore FairCom MQ releases, featuring enhancements and new capabilities.
312 views Updated July 22nd, 2026 -
C API Functions Alphabetical List
4 views Updated August 10th, 2026 -
Other RTG utilities
563 views Updated July 16th, 2026 -
Basic JDBC driver operations
284 views Updated May 19th, 2026 -
ctGetAccountExpirationTime
163 views Updated May 12th, 2026 -
C API Functions O
118 views Updated June 17th, 2026 -
ctfiltercb_rowl
176 views Updated May 12th, 2026 -
C API Functions F
133 views Updated July 17th, 2026 -
C API Functions R
142 views Updated July 17th, 2026 -
Commit
179 views Updated August 13th, 2026 -
clearTranError
177 views Updated May 12th, 2026 -
Begin
192 views Updated August 13th, 2026 -
Users, schemas, and roles
248 views Updated May 15th, 2026 -
AddCtResource
160 views Updated July 30th, 2026 -
LDAP
9 views Updated August 11th, 2026 -
DB Function Descriptions Q
200 views Updated July 22nd, 2026 -
RTG troubleshooting
This section provides some useful troubleshooting tips.
300 views Updated August 17th, 2026 -
DB Function Descriptions U
377 views Updated July 24th, 2026 -
cpybuf
180 views Updated May 12th, 2026 -
Partitioned Files (ISAM for C)
168 views Updated July 14th, 2026 -
DB SnapShot Function
14 views Updated August 6th, 2026 -
ISAM logging, error codes, and troubleshooting
515 views Updated March 27th, 2026 -
ctfcpCopyFile
161 views Updated May 12th, 2026 -
DB Function Descriptions F
359 views Updated July 21st, 2026 -
ctGetNullKeyValue
159 views Updated May 12th, 2026 -
C API Functions G
204 views Updated August 12th, 2026 -
ctFILBLK
166 views Updated May 12th, 2026 -
ctGetIsamFileNbr
160 views Updated May 12th, 2026 -
DB Function Descriptions O
331 views Updated July 22nd, 2026 -
DB Function Descriptions P
432 views Updated July 22nd, 2026 -
ctfiltercbRemoveFilter
161 views Updated May 12th, 2026 -
C API Functions C
139 views Updated August 13th, 2026 -
C API Functions P
97 views Updated June 17th, 2026 -
FairCom Edge APIs
FairCom Edge's API documentation for software developers, equipment manufacturers, and automation engineers
340 views Updated August 10th, 2026 -
DB Function Descriptions R
456 views Updated July 24th, 2026 -
CreateISAM
180 views Updated May 12th, 2026 -
File Security and Encryption
206 views Updated August 13th, 2026 -
ISAM settings elements
527 views Updated August 13th, 2026 -
forwardToExternalBrokers
381 views Updated April 23rd, 2026 -
DB Function Descriptions T
360 views Updated July 24th, 2026 -
ctFILMTX
168 views Updated May 12th, 2026 -
DB Function Descriptions A
409 views Updated July 15th, 2026 -
ISAM server setup
444 views Updated March 26th, 2026 -
DB Function Descriptions I
348 views Updated July 21st, 2026 -
DB Function Descriptions B
342 views Updated July 15th, 2026 -
DB Function Descriptions E
308 views Updated July 20th, 2026 -
DB Function Descriptions S
602 views Updated August 18th, 2026 -
C API Functions T
164 views Updated July 17th, 2026 -
C API Functions I
141 views Updated June 18th, 2026 -
C API Functions N
115 views Updated June 17th, 2026 -
C API Functions E
100 views Updated June 18th, 2026 -
C API Functions U
128 views Updated July 17th, 2026 -
C API Functions A
175 views Updated August 13th, 2026 -
C API Functions D
193 views Updated August 14th, 2026 -
C API Functions M
98 views Updated June 24th, 2026 -
C API Functions L
101 views Updated June 18th, 2026 -
C API Functions B
135 views Updated June 16th, 2026 -
C API Functions W
105 views Updated June 18th, 2026 -
C API Functions H
106 views Updated June 18th, 2026 -
C API Functions V
109 views Updated June 18th, 2026 -
C API Functions J
106 views Updated June 18th, 2026 -
DB SQL Features
This chapter explains the important features provided by FairCom DB SQL.
451 views Updated May 18th, 2026 -
DB Function Descriptions L
397 views Updated July 21st, 2026 -
DB Function Descriptions D
467 views Updated July 20th, 2026 -
DB SQL utilities list
413 views Updated May 18th, 2026 -
C API Functions S
305 views Updated July 22nd, 2026 -
DB releases and breaking changes
Explore FairCom DB releases, featuring enhancements and new capabilities.
589 views Updated July 22nd, 2026 -
DB Function Descriptions G
582 views Updated July 21st, 2026 -
DB Function Descriptions C
1097 views Updated August 18th, 2026 -
DB Function Descriptions K
305 views Updated July 21st, 2026 -
ISQL Statement Descriptions
369 views Updated August 13th, 2026 -
DB Function Descriptions N
366 views Updated July 22nd, 2026 -
DB Function Descriptions W
344 views Updated July 24th, 2026 -
Logical functions
385 views Updated May 15th, 2026 -
Combining FairCom DB SQL with ISAM
487 views Updated May 18th, 2026 -
DB SQL identifiers
401 views Updated May 15th, 2026 -
RTG performance tuning
455 views Updated August 12th, 2026 -
FairCom Terms Glossary
Definitions of technical terms used by FairCom products
678 views Updated August 14th, 2026 -
RTG server setup
554 views Updated August 12th, 2026 -
ODBC driver errors
FairCom ODBC Driver error codes are returned by FairCom's ODBC driver
293 views Updated February 9th, 2026 -
ISAM configuration
486 views Updated July 16th, 2026 -
ISAM XDD schema structure
626 views Updated March 27th, 2026 -
JDBC glossary
249 views Updated May 14th, 2026 -
RTG structure elements
479 views Updated August 12th, 2026 -
ISAM driver installation
406 views Updated February 11th, 2026 -
Field conversion example
250 views Updated May 14th, 2026 -
Encryption
249 views Updated May 18th, 2026 -
ISAM quick start
440 views Updated August 12th, 2026 -
Direct Link FairCom DB SQL ODBC Driver
419 views Updated May 14th, 2026 -
ISAM cttrnmod (change transaction mode utility)
417 views Updated January 30th, 2026 -
Which functions are safe?
222 views Updated May 14th, 2026 -
Configuring FairCom DB SQL Data Sources
597 views Updated May 14th, 2026 -
Introductory tutorial
437 views Updated May 14th, 2026 -
RTG tutorials
451 views Updated August 12th, 2026 -
Conversion functions
373 views Updated May 15th, 2026 -
ISAM overview
FairCom ISAM documentation home
322 views Updated August 17th, 2026 -
FairCom DB SQL built-in stored procedures
440 views Updated July 17th, 2026 -
DB SQL options
FairCom DB SQL supports a variety of options that allows you to address your needs.
476 views Updated June 10th, 2026 -
More info
242 views Updated May 14th, 2026 -
DB SQL functions overview
243 views Updated May 14th, 2026 -
normalLowerLimit
356 views Updated April 23rd, 2026 -
Aggregate functions
240 views Updated May 15th, 2026 -
RTG SQL access
781 views Updated May 12th, 2026 -
Clustering concepts
471 views Updated January 16th, 2026 -
RTG XDD schema structure
626 views Updated March 24th, 2026 -
ODBC quick tour
292 views Updated August 14th, 2026 -
RTG runtime drivers
517 views Updated August 12th, 2026 -
deadbandLowerLimit
380 views Updated April 23rd, 2026 -
ISAM ctmigra (conversion utility)
261 views Updated March 27th, 2026 -
RTG utilities overview
276 views Updated August 14th, 2026 -
ISAM structure elements
498 views Updated June 30th, 2026 -
Migrating to FairCom DB SQL
296 views Updated May 18th, 2026 -
ODBC Conformance Notes
This chapter details the ODBC functionality that FairCom DB SQL supports through the ODBC Driver.
287 views Updated May 14th, 2026 -
RTG settings elements
596 views Updated August 20th, 2026 -
newTagName
366 views Updated April 23rd, 2026 -
RTG ctutil
611 views Updated August 12th, 2026 -
Importing tables into FairCom DB SQL
256 views Updated May 18th, 2026 -
Data replication errors
FairCom Data Replication error codes are returned by the Data Replication APIs and Replication Manager application
269 views Updated February 9th, 2026 -
String functions
291 views Updated May 15th, 2026 -
DB SQL built-in stored procedures
405 views Updated May 14th, 2026 -
ISAM setup
447 views Updated January 29th, 2026 -
Configurable Log Output
259 views Updated February 11th, 2026 -
atEnd
390 views Updated April 23rd, 2026 -
Modbus: convert collected integers to floating point numbers
248 views Updated April 15th, 2026 -
ISAM ctutil
495 views Updated August 12th, 2026 -
DB SQL joins
372 views Updated May 14th, 2026 -
length
370 views Updated August 20th, 2026 -
Configure modbus to output data to a device
224 views Updated January 9th, 2026 -
ISAM ctfileid (update file IDs)
418 views Updated March 27th, 2026 -
Search Conditions
343 views Updated May 15th, 2026 -
Math functions
254 views Updated May 14th, 2026 -
RTG data conversion
705 views Updated March 2nd, 2026 -
RTG/ISAM errors
Errors specific to RTG and ISAM
484 views Updated January 16th, 2026 -
Relationships tutorial
How to build table/file relationships using the FairCom DB SQL ODBC Interface
244 views Updated May 14th, 2026 -
RTG directories
460 views Updated January 28th, 2026 -
ISAM SQL access
523 views Updated August 12th, 2026 -
DB SQL query expressions
424 views Updated August 14th, 2026 -
ISAM releases and breaking changes
441 views Updated July 22nd, 2026 -
DB SQL expressions
407 views Updated May 15th, 2026 -
Replication, Clusters, High Availability, and Disaster Recovery
447 views Updated February 27th, 2026 -
RTG setup and installation overview
298 views Updated January 28th, 2026 -
Partitioned files with RTG
453 views Updated July 7th, 2026 -
DB SQL types SDK sverview
231 views Updated May 14th, 2026 -
Transaction processing tutorial
243 views Updated May 14th, 2026 -
Record/row locking tutorial
254 views Updated May 14th, 2026 -
ISAM data conversion
488 views Updated August 12th, 2026 -
Ranking functions
377 views Updated August 14th, 2026 -
DB SQL statements
This chapter provides detailed reference material on each SQL statement.
647 views Updated August 14th, 2026 -
Replicating RTG file operations
284 views Updated February 10th, 2026 -
ThingWorx Troubleshooting
Troubleshoot ThingWorx errors
459 views Updated August 20th, 2026 -
DBQL with Callbacks
344 views Updated May 18th, 2026 -
Application data setup
330 views Updated May 18th, 2026 -
UTF-8 data stored in RTG
254 views Updated February 10th, 2026 -
jsonActionApiDefaults
358 views Updated August 20th, 2026 -
RTG driver errors
465 views Updated March 2nd, 2026 -
FairCom DB SQL Reserved Words
237 views Updated May 14th, 2026 -
JDBC relationships tutorial
242 views Updated May 14th, 2026 -
includeInputConnectorProperties
362 views Updated April 23rd, 2026 -
DBL Java configuration
FairCom DB SQL Java Configuration for Stored Procedures, Triggers and User Defined Functions
370 views Updated May 14th, 2026 -
mqttPayloadType
375 views Updated July 21st, 2026 -
Listing connections with a particular file open
241 views Updated March 2nd, 2026 -
DB SQL reserved words and error messages
241 views Updated May 15th, 2026 -
ISAM substitution specifiers
411 views Updated January 29th, 2026 -
List of variant types
263 views Updated August 20th, 2026 -
DB SQL data types
391 views Updated May 15th, 2026 -
RTG transaction support
455 views Updated August 12th, 2026 -
Install Standalone SQL
258 views Updated May 18th, 2026 -
More information
238 views Updated May 18th, 2026 -
ctsqlimp - DB SQL Import Utility
432 views Updated May 18th, 2026 -
Upgrade files to RTG 5 attribute resource format (Unified Data Types)
609 views Updated July 16th, 2026 -
ISAM utilities overview
265 views Updated August 12th, 2026 -
JDBC record/row locking tutorial
233 views Updated May 14th, 2026 -
RTG Overview
FairCom RTG documentation home
293 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.
241 views Updated May 19th, 2026 -
Date-Time format strings
360 views Updated May 14th, 2026 -
RTG releases and breaking changes
404 views Updated July 22nd, 2026 -
includeThingProperties
348 views Updated April 23rd, 2026 -
JDBC transaction processing tutorial
243 views Updated May 14th, 2026 -
xddgen
474 views Updated February 27th, 2026 -
More ISAM utilities
433 views Updated March 27th, 2026 -
Date and Time functions
279 views Updated May 15th, 2026 -
Copying server-controlled files
470 views Updated March 2nd, 2026 -
ISAM configuration file elements overview
427 views Updated March 27th, 2026 -
RTG configuration overview
516 views Updated August 17th, 2026 -
DB SQL system catalog tables
261 views Updated May 14th, 2026 -
Install DB SQL
325 views Updated May 18th, 2026 -
autoValue
522 views Updated April 23rd, 2026 -
Advanced ISAM techniques
466 views Updated January 30th, 2026 -
Secure topics and integration tables
Secure your topics and integration tables by managing roles
493 views Updated August 13th, 2026 -
SQL language elements overview
373 views Updated May 14th, 2026 -
Btrieve compatibility
514 views Updated February 4th, 2026 -
RTG hot alter table
434 views Updated February 27th, 2026 -
System and metadata functions
395 views Updated May 14th, 2026 -
RTG quick start
477 views Updated July 22nd, 2026 -
SQL access to your standalone database (Overview)
250 views Updated May 18th, 2026 -
RTG substitution specifiers
453 views Updated February 10th, 2026 -
deadbandUpperLimit
381 views Updated April 23rd, 2026 -
File maintenance with RTG
271 views Updated February 27th, 2026 -
A-B Ethernet/IP connector errors
Allen-Bradley Ethernet/IP IoT connector error codes
265 views Updated January 16th, 2026 -
includeTopicProperties
351 views Updated April 23rd, 2026 -
fixedLengthCharFormat
430 views Updated April 23rd, 2026 -
binaryFormat
424 views Updated April 23rd, 2026 -
includeOutputConnectorProperties
356 views Updated April 23rd, 2026