FairCom DB V12 Updates

SQL

Relational SQL access remains a powerful force for data reporting and analytics. FairCom DB allows legacy data to be linked to SQL. FairCom DB V12 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 Dynamically "SQLize" ISAM and COBOL Files FairCom DB SQL Import and FairCom RTG Sqlize No Longer Require Exclusive Access to Tables 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