V9 Update Guide

Documentation Overview Highlights of FairCom DB V9.0 FairCom DB Tools FairCom DB SQL Enhancements New Features for FairCom DB ISAM Server Extensive Interface Support Additional c-treeDB and c-treeDB .NET Features and Improvements Advanced Functions for the FairCom DB SDK mtPro Build Utility Easier Navigation in FairCom DB The Most Up to Date Information Compatibility Notes Default Extended Headers for Enhanced Feature Support Ensure Matching Client and Server Versions for 100% Comptibility New Commit Read Lock Support Requires Record Locks for Update Transaction Log Format HUGE Files are now Default with FairCom DB SQL Backward Compatibility Changes with c-treeSQL Databases LOG_WRITETHRU support for Unix New Unix Default File Permissions Mode Record Based c-treeDB Filters c-treeSQL and c-treeDB BINARY and VARBINARY Compatibility Issues Addressing the issue NULL Handling in Filter Expressions FairCom DB Tools FairCom DB SQL Explorer FairCom DB SQL Query Builder FairCom DB ISAM Explorer FairCom DB Security Administrator FairCom DB Configuration Manager FairCom DB Performance Monitor FairCom DB Monitor FairCom DB Gauges FairCom DB Status Log Analyzer FairCom DB Load Test FairCom DB SQL Enhancements Improved Query Optimizer Performance Stored Procedures, Triggers, and User Defined Functions Now Standard Features Advanced Encryption for FairCom DB SQL Tables Default HUGE Files for Tables Quickly TRUNCATE Tables Maximum Field Lengths for Non LONGVAR Fields Raised to 8K Additional Scalar Functions Available Advanced Searching with CONTAINS Clause and LVARCHAR Fields Support for SQL Transaction Isolation Levels 1 and 2 Additional Search Options for FairCom DB SQL LONG Field Types Query Timeout Options Complete RIGHT OUTER JOIN Syntax DEFAULT Clause with ALTER TABLE ODBC and JDBC Driver Socket SEND/RECV Timeout ODBC Driver Login Timeout Improved FairCom DB SQL Java Configuration Reserved Keywords With Microsoft Excel and ODBC Additional ORDER BY Clause Usage Copy a Database with the FairCom DB SQL Maintenance Utility PREIMAGE Tables in FairCom DB SQL FairCom Security Handshake Now Available in all FairCom DB SQL Products Updated FairCom DB SQL Reserved Words New Features for FairCom DB ISAM Server Temporarily Suspend FairCom DB Operations Enhanced Dynamic Dump FairCom DB CPU Configuration Options Administrators Can Now Define the FairCom DB Port Number Default Extended Headers for Enhanced Feature Support Transaction Timeout Blocking Lock Timeout Commit Read Locks for Guaranteed Data Reads Automatic Transaction Processing for non-TRANPROC files Prime Cache By Key Rebuild Callback Support in Client/Server Mode Scaling Factors for Configuration Keyword Values Disable the FairCom DB Communication SubSystem Automatic Shared Memory Protocol for Local Connections on Windows Additional SNAPSHOT Options SNAPSHOT Histogram Support Change Configuration Options at Run Time Advanced Commit Delay Options FairCom DB Server SDK File Callback Options Assignment of Default File Permissions to User Groups FairCom DB Stack Dumps for Windows and UNIX File Permission Mode for Files Created by c-tree on Unix Systems Retry Options Additional FairCom DB SQL Interfaces FairCom DB SQL ADO .NET Data Provider FairCom DB SQL PHP FairCom DB SQL dbExpress FairCom DB Direct SQL Improved c-treeDB .NET New Delphi .NET Support Delphi .NET Compatibility when using Create() Batches for c-treeDB Support for Resources Attach and Detach Existing Sessions Attach and Detach Tables Retrieve Field, Index, and Segment Status Exclusive Sessions and Databases Retrieve the FairCom DB Configuration Move Segments in an Index Definition Many New Method Additions New Mode for Table Rebuilds with Missing Index Files Default Index for Physical Data File Traversal Many Additional c-treeDB Features Batches for c-treeDB Resources for c-treeDB Unicode Support for c-treeDB Callback Support in c-treeDB Row Level Permanent Filters Key Counting Functions Retrieve a Field that Partially Matches a Key Segment Retain Locks After Commit Filters are Now Record Based, Rather Than Table Based Rebuild Tables with c-treeDB Default Values for Alter Table Operations Attach and Detach Existing Sessions to c-treeDB Attach and Detach Open Tables to c-treeDB Retrieve c-treeDB Field and Segment Change Status Move Segments in an Index Definition with c-treeDB Retrieve c-tree Configuration with c-treeDB Determine if c-treeDB Records Sets are Active Get Table Status information From c-treeDB Identifying Duplicate Key Index Errors Exclusive Sessions and Databases in c-treeDB Get and Set c-treeDB Table Owner Information Set Integer Values with c-treeDB CTMoney Class New Mode for Table Rebuilds with Missing Index Files Set Operations State in c-treeDB c-treeDB Transaction Begin Modes c-treeDB Functions to Start and Stop the c-tree Server Engine Advanced Functions for the FairCom DB SDK Block Access to Files Blocking Lock Timeouts Partial Record Rewrites Row-Level Permanent Callback Filters Advanced Cache Alternative for Scanning Data Files Recursive Locking Support Retrieve a List of File names from FairCom DB File-based Global Mutexes Programmatically Import Tables into FairCom DB SQL Access a FairCom DB Connection Created by Another Thread List Users Owning or Waiting for Record Locks Extended Connection Information in a Lock Dump TCP/IP Client Connect and Communication Timeout Options Additional Security Administrator Functions Increased Page Size Now Available Extended Version of Compact Function Added Compact Function Now Supports Duplicate Key Purge and Update IFIL Options Additional SETOPS Modes Default Temporary File Path in Standalone and LOCLIB Models Options to Retrieve a File's Unique ID Update Unicode Version Enforce Maximum Disk Read/Write Sizes on Windows Other New Functions Available More c-treeVCL Functionality New c-treeVCL Features More Options with FairCom DB Utilities Enhanced FairCom DB Statistics Utility Features Additional FairCom DB SQL Table Import Utility Options Enhanced Security Administrator Usage and Options c-tree Information Utility Enhancements FairCom Typographical Conventions Copyright Notice Index