Daniel Taylor
dan.taylor@faircom.com
Articles by Daniel
-
-
Users, schemas, and roles
276 views Updated May 15th, 2026 -
DB Function Descriptions A
442 views Updated July 15th, 2026 -
forwardToExternalBrokers
402 views Updated August 24th, 2026 -
C API Functions G
244 views Updated September 3rd, 2026 -
ctGetNullKeyValue
165 views Updated May 12th, 2026 -
The RTG configuration file
490 views Updated August 17th, 2026 -
ctfcpCopyFile
173 views Updated May 12th, 2026 -
C API Functions F
154 views Updated August 25th, 2026 -
Other RTG utilities
605 views Updated July 16th, 2026 -
C API Functions M
115 views Updated August 26th, 2026 -
DB SQL utilities list
435 views Updated May 18th, 2026 -
C API Functions T
185 views Updated August 26th, 2026 -
DB Function Descriptions R
495 views Updated July 24th, 2026 -
DB Function Descriptions P
456 views Updated July 22nd, 2026 -
ctfiltercb_rowl
184 views Updated May 12th, 2026 -
cpybuf
188 views Updated May 12th, 2026 -
Commit
191 views Updated August 13th, 2026 -
DB SQL Features
This chapter explains the important features provided by FairCom DB SQL.
477 views Updated May 18th, 2026 -
DB Function Descriptions F
384 views Updated July 21st, 2026 -
LDAP
28 views Updated August 11th, 2026 -
ctGetIsamFileNbr
167 views Updated May 12th, 2026 -
C API Functions O
137 views Updated August 26th, 2026 -
DB Function Descriptions U
407 views Updated July 24th, 2026 -
ctfiltercbRemoveFilter
169 views Updated May 12th, 2026 -
C API Functions P
112 views Updated August 24th, 2026 -
DB releases and breaking changes
Explore FairCom DB releases, featuring enhancements and new capabilities.
674 views Updated July 22nd, 2026 -
CreateISAM
189 views Updated May 12th, 2026 -
Begin
206 views Updated August 13th, 2026 -
RTG troubleshooting
This section provides some useful troubleshooting tips.
340 views Updated August 17th, 2026 -
DB Function Descriptions S
654 views Updated September 16th, 2026 -
DB Function Descriptions V
327 views Updated July 24th, 2026 -
DB Function Descriptions T
387 views Updated July 24th, 2026 -
ctFILMTX
177 views Updated May 12th, 2026 -
DB SnapShot Function
50 views Updated August 28th, 2026 -
DB Function Descriptions I
378 views Updated July 21st, 2026 -
DB Function Descriptions B
379 views Updated July 15th, 2026 -
DB Function Descriptions E
332 views Updated July 20th, 2026 -
C API Functions I
164 views Updated August 26th, 2026 -
C API Functions N
135 views Updated August 26th, 2026 -
C API Functions U
150 views Updated August 27th, 2026 -
DB Function Descriptions Q
245 views Updated July 22nd, 2026 -
Basic JDBC driver operations
315 views Updated May 19th, 2026 -
clearTranError
184 views Updated May 12th, 2026 -
C API Functions B
155 views Updated August 25th, 2026 -
C API Functions W
128 views Updated August 25th, 2026 -
C API Functions H
122 views Updated August 24th, 2026 -
C API Functions J
123 views Updated August 24th, 2026 -
ISAM settings elements
580 views Updated August 13th, 2026 -
MQ releases
Explore FairCom MQ releases, featuring enhancements and new capabilities.
335 views Updated July 22nd, 2026 -
DB Function Descriptions C
1176 views Updated September 24th, 2026 -
ctFILBLK
187 views Updated May 12th, 2026 -
File Security and Encryption
466 views Updated September 21st, 2026 -
Application data setup (standalone SQL)
351 views Updated August 24th, 2026 -
C API Functions V
131 views Updated August 25th, 2026 -
Migration, Troubleshooting, and Glossary for FairCom ODBC
265 views Updated August 24th, 2026 -
DB Function Descriptions D
493 views Updated July 20th, 2026 -
C API Functions C
176 views Updated August 25th, 2026 -
C API Functions E
119 views Updated August 25th, 2026 -
ctGetAccountExpirationTime
173 views Updated May 12th, 2026 -
AddCtResource
171 views Updated July 30th, 2026 -
C API Functions R
162 views Updated August 26th, 2026 -
DB Function Descriptions G
635 views Updated July 21st, 2026 -
ISAM server setup
474 views Updated March 26th, 2026 -
DB Function Descriptions K
329 views Updated July 21st, 2026 -
ISQL Statement Descriptions
410 views Updated August 13th, 2026 -
C API Functions L
120 views Updated August 26th, 2026 -
DB Function Descriptions L
425 views Updated August 21st, 2026 -
DB Function Descriptions O
360 views Updated July 22nd, 2026 -
DB Function Descriptions N
397 views Updated July 22nd, 2026 -
DB Function Descriptions W
375 views Updated August 21st, 2026 -
C API Functions Alphabetical List
26 views Updated August 10th, 2026 -
Logical functions
403 views Updated May 15th, 2026 -
Combining FairCom DB SQL with ISAM
512 views Updated May 18th, 2026 -
DB SQL identifiers
423 views Updated May 15th, 2026 -
RTG performance tuning
481 views Updated August 12th, 2026 -
FairCom Terms Glossary
Definitions of technical terms used by FairCom products
723 views Updated August 14th, 2026 -
RTG server setup
585 views Updated August 12th, 2026 -
ODBC driver errors
FairCom ODBC Driver error codes are returned by FairCom's ODBC driver
329 views Updated February 9th, 2026 -
ISAM configuration
530 views Updated July 16th, 2026 -
JDBC glossary
270 views Updated May 14th, 2026 -
RTG structure elements
507 views Updated August 12th, 2026 -
Field conversion example
268 views Updated May 14th, 2026 -
Standalone SQL encryption
280 views Updated August 24th, 2026 -
ISAM quick start
477 views Updated August 12th, 2026 -
Direct Link FairCom DB SQL ODBC Driver
492 views Updated May 14th, 2026 -
ISAM cttrnmod (change transaction mode utility)
440 views Updated January 30th, 2026 -
Configuring FairCom DB SQL Data Sources
645 views Updated May 14th, 2026 -
JDBC Introductory tutorial
465 views Updated August 21st, 2026 -
RTG tutorials
477 views Updated August 12th, 2026 -
Conversion functions
395 views Updated May 15th, 2026 -
ISAM overview
FairCom ISAM documentation home
361 views Updated August 17th, 2026 -
DB SQL functions overview
267 views Updated May 14th, 2026 -
normalLowerLimit
375 views Updated August 24th, 2026 -
Aggregate functions
261 views Updated May 15th, 2026 -
RTG SQL access
816 views Updated May 12th, 2026 -
Clustering concepts
507 views Updated January 16th, 2026 -
RTG XDD schema structure
658 views Updated March 24th, 2026 -
ODBC quick tour
338 views Updated August 14th, 2026 -
RTG runtime drivers
543 views Updated August 12th, 2026 -
deadbandLowerLimit
401 views Updated August 24th, 2026 -
ISAM ctmigra (conversion utility)
289 views Updated March 27th, 2026 -
RTG utilities overview
302 views Updated August 14th, 2026 -
ISAM structure elements
559 views Updated June 30th, 2026 -
Migrating to FairCom DB SQL
321 views Updated May 18th, 2026 -
ODBC Conformance Notes
This chapter details the ODBC functionality that FairCom DB SQL supports through the ODBC Driver.
313 views Updated May 14th, 2026 -
RTG settings elements
648 views Updated August 20th, 2026 -
newTagName
384 views Updated August 24th, 2026 -
RTG ctutil
659 views Updated August 12th, 2026 -
Data replication errors
FairCom Data Replication error codes are returned by the Data Replication APIs and Replication Manager application
299 views Updated February 9th, 2026 -
String functions
314 views Updated May 15th, 2026 -
DB SQL built-in stored procedures
437 views Updated May 14th, 2026 -
ISAM setup
485 views Updated January 29th, 2026 -
Configurable Log Output
285 views Updated February 11th, 2026 -
atEnd
414 views Updated August 24th, 2026 -
Modbus: convert collected integers to floating point numbers
259 views Updated April 15th, 2026 -
ISAM ctutil
553 views Updated August 12th, 2026 -
DB SQL joins
393 views Updated May 14th, 2026 -
length
394 views Updated August 24th, 2026 -
Configure modbus to output data to a device
233 views Updated January 9th, 2026 -
ISAM ctfileid (update file IDs)
441 views Updated March 27th, 2026 -
Search Conditions
362 views Updated May 15th, 2026 -
Math functions
274 views Updated May 14th, 2026 -
RTG data conversion
752 views Updated March 2nd, 2026 -
RTG/ISAM errors
Errors specific to RTG and ISAM
515 views Updated January 16th, 2026 -
Relationships tutorial
How to build table/file relationships using the FairCom DB SQL ODBC Interface
270 views Updated May 14th, 2026 -
RTG directories
484 views Updated January 28th, 2026 -
ISAM SQL access
550 views Updated August 12th, 2026 -
DB SQL query expressions
451 views Updated August 14th, 2026 -
ISAM releases and breaking changes
469 views Updated July 22nd, 2026 -
DB SQL expressions
426 views Updated May 15th, 2026 -
Replication, Clusters, High Availability, and Disaster Recovery
469 views Updated February 27th, 2026 -
RTG setup and installation overview
320 views Updated January 28th, 2026 -
Partitioned files with RTG
478 views Updated July 7th, 2026 -
DB SQL types SDK sverview
251 views Updated May 14th, 2026 -
Transaction processing tutorial
263 views Updated May 14th, 2026 -
Record/row locking tutorial
273 views Updated May 14th, 2026 -
ISAM data conversion
522 views Updated August 12th, 2026 -
Ranking functions
405 views Updated August 14th, 2026 -
DB SQL statements
This chapter provides detailed reference material on each SQL statement.
730 views Updated September 17th, 2026 -
Replicating RTG file operations
306 views Updated February 10th, 2026 -
ThingWorx Troubleshooting
Troubleshoot ThingWorx errors
481 views Updated August 20th, 2026 -
DBQL with Callbacks
363 views Updated May 18th, 2026 -
UTF-8 data stored in RTG
277 views Updated February 10th, 2026 -
jsonActionApiDefaults
380 views Updated August 24th, 2026 -
RTG driver errors
494 views Updated March 2nd, 2026 -
FairCom DB SQL Reserved Words
255 views Updated May 14th, 2026 -
JDBC relationships tutorial
262 views Updated May 14th, 2026 -
includeInputConnectorProperties
380 views Updated August 24th, 2026 -
DBL Java configuration
FairCom DB SQL Java Configuration for Stored Procedures, Triggers and User Defined Functions
393 views Updated May 14th, 2026 -
mqttPayloadType
399 views Updated August 24th, 2026 -
Listing connections with a particular file open
266 views Updated March 2nd, 2026 -
DB SQL reserved words and error messages
266 views Updated May 15th, 2026 -
ISAM substitution specifiers
440 views Updated January 29th, 2026 -
List of variant types
Explore supported types of variants, understanding of their significance and use cases.
321 views Updated September 11th, 2026 -
DB SQL data types
419 views Updated May 15th, 2026 -
RTG transaction support
480 views Updated August 12th, 2026 -
Install Standalone SQL
284 views Updated May 18th, 2026 -
More information on Standalone SQL
263 views Updated August 24th, 2026 -
ctsqlimp - DB SQL Import Utility
457 views Updated May 18th, 2026 -
Upgrade files to RTG 5 attribute resource format (Unified Data Types)
648 views Updated July 16th, 2026 -
ISAM utilities overview
301 views Updated August 12th, 2026 -
JDBC record/row locking tutorial
253 views Updated May 14th, 2026 -
RTG Overview
FairCom RTG documentation home
316 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.
261 views Updated May 19th, 2026 -
Date-Time format strings
380 views Updated May 14th, 2026 -
includeThingProperties
369 views Updated August 24th, 2026 -
JDBC transaction processing tutorial
263 views Updated May 14th, 2026 -
xddgen
515 views Updated September 9th, 2026 -
Copying server-controlled files
494 views Updated March 2nd, 2026 -
ISAM configuration file elements overview
501 views Updated March 27th, 2026 -
RTG configuration overview
548 views Updated August 17th, 2026 -
Install DB SQL
372 views Updated May 18th, 2026 -
autoValue
540 views Updated August 24th, 2026 -
Advanced ISAM techniques
506 views Updated January 30th, 2026 -
Secure topics and integration tables
Secure your topics and integration tables by managing roles
516 views Updated August 13th, 2026 -
SQL language elements overview
402 views Updated May 14th, 2026 -
Btrieve compatibility
551 views Updated February 4th, 2026 -
RTG hot alter table
457 views Updated February 27th, 2026 -
System and metadata functions
419 views Updated May 14th, 2026 -
RTG quick start
497 views Updated July 22nd, 2026 -
DB SQL options
FairCom DB SQL supports a variety of options that allows you to address your needs.
508 views Updated June 10th, 2026 -
FairCom DB SQL configuration keywords
540 views Updated August 19th, 2026 -
Importing tables into FairCom DB SQL
282 views Updated May 18th, 2026 -
FairCom Edge APIs
FairCom Edge's API documentation for software developers, equipment manufacturers, and automation engineers
379 views Updated August 10th, 2026 -
SQL access to your standalone database (Overview)
285 views Updated May 18th, 2026 -
Date and Time functions
313 views Updated May 15th, 2026 -
C API Functions D
221 views Updated August 25th, 2026 -
ISAM logging, error codes, and troubleshooting
578 views Updated March 27th, 2026 -
Partitioned Files (ISAM for C)
195 views Updated July 14th, 2026 -
RTG releases and breaking changes
428 views Updated July 22nd, 2026 -
C API Functions A
214 views Updated August 25th, 2026 -
Which functions are safe?
238 views Updated May 14th, 2026 -
DB SQL system catalog tables
285 views Updated May 14th, 2026 -
More ISAM utilities
463 views Updated March 27th, 2026 -
ISAM XDD schema structure
669 views Updated March 27th, 2026 -
ISAM driver installation
432 views Updated February 11th, 2026 -
RTG substitution specifiers
481 views Updated February 10th, 2026 -
DeadbandUpperLimit
401 views Updated August 24th, 2026 -
File maintenance with RTG
300 views Updated February 27th, 2026 -
A-B Ethernet/IP connector errors
Allen-Bradley Ethernet/IP IoT connector error codes
302 views Updated January 16th, 2026 -
includeTopicProperties
372 views Updated August 24th, 2026 -
fixedLengthCharFormat
451 views Updated August 24th, 2026 -
binaryFormat
446 views Updated August 24th, 2026 -
includeOutputConnectorProperties
377 views Updated August 24th, 2026