Contents

Copyright Notice Documentation Overview FairCom Typographical Conventions Highlights of c-treeACE V9.0 c-treeACE Tools c-treeACE SQL Enhancements New Features for c-treeACE ISAM Server Extensive Interface Support Additional c-treeDB and c-treeDB.NET Features and Improvements Advanced Functions for the c-treeACE SDK New mtPro Build Utility Easier Navigation in c-treeACE The Most Up to Date Information Compatibility Notes 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 c-treeACE SQL Backward Compatibility Changes with c-treeSQL Databases LOG_WRITETHRU support for Unix New Unix Default File Permissions Mode Record Based c-treeDB Filters Addressing the issue c-treeACE Tools c-treeACE SQL Explorer c-treeACE SQL Query Builder c-treeACE ISAM Explorer c-treeACE Security Administrator c-treeACE Configuration Manager c-treeACE Performance Monitor c-treeACE Monitor c-treeACE Gauges c-treeACE Status Log Analyzer c-treeACE Load Test c-treeACE SQL Enhancements Improved Query Optimizer Performance Stored Procedures, Triggers, and User Defined Functions Now Standard Features Advanced Encryption for c-treeACE 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 c-treeACE 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 c-treeACE SQL Java Configuration Reserved Keywords With Microsoft Excel and ODBC Additional ORDER BY Clause Usage Copy a Database with the c-treeACE SQL Maintenance Utility PREIMAGE Tables in c-treeACE SQL FairCom Security Handshake Now Available in all c-treeACE SQL Products Updated c-treeACE SQL Reserved Words New Features for c-treeACE ISAM Server Temporarily Suspend c-treeACE Operations Enhanced Dynamic Dump c-treeACE CPU Configuration Options Administrators Can Now Define the c-treeACE 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 c-treeACE 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 c-treeACE Server SDK File Callback Options Assignment of Default File Permissions to User Groups c-treeACE Stack Dumps for Windows and AIX File Permission Mode for Files Created by c-tree on Unix Systems Retry Options Additional c-treeACE SQL Interfaces c-treeACE SQL ADO .NET Data Provider c-treeACE SQL PHP c-treeACE SQL dbExpress c-treeACE 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 c-treeACE 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 c-treeACE 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 c-treeACE File-based Global Mutexes Programmatically Import Tables into c-treeACE SQL Access a c-treeACE 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 c-treeACE Utilities Enhanced c-treeACE Statistics Utility Features Additional c-treeACE SQL Table Import Utility Options Enhanced Security Administrator Usage and Options c-tree Information Utility Enhancements Index