FairCom RTG V3 Update Guide

SQL

Relational SQL access remains a powerful force for data reporting and analytics. FairCom RTG allows legacy data to be linked to SQL. FairCom RTG V3 makes this process automated on-the-fly. New SQL features such as multi-value sets and extended usage of parameters adds more flexibility. Extended JSON logging will greatly enhance query audit logging and diagnostics.

In This Chapter Run a SQL Query across Multiple Databases Parameter Marks Now Available in Scalar Functions and CASE Statements Assign Values to Auto-Increment Fields in INSERT Insert Multiple Value Sets Insert Statements with Scalar Values and Subqueries Now Supported Use Row Value Constructors with Comparisons in Query Easier Full-Text Search (FTS) MATCH Operator Syntax Diagnostic Logging Now in Enhanced JSON Format Extensive SQL Statement Logging for Auditing SYSLOG SQL_STATEMENTS Configuration Keyword LVARCHAR Fields Allowed in Stored Procedure Code Throw Custom Error Message on Stored Procedure or UDF Exception Dynamically Disable Triggers Dynamically "SQLize" ISAM and COBOL Files