| Symbols & Numeric |
| .NET |
| .NET types |
| Altering the SP, UDF, or Trigger |
| debugging |
| deploying |
| errors |
| ExecuteSP |
| Accessing Old and New Rows in Triggers |
| Returning a Result Set from a Stored Procedure |
| Returning a UDF Result |
| Writing the Code |
| installation, .NET plugin |
| namespace |
| null handling |
| resultset |
| Altering the SP, UDF, or Trigger |
| Returning a Result Set from a Stored Procedure |
| Writing a New SP, UDF, or Trigger |
| templates |
| testing |
| triggers, old and new rows |
| UDF result |
| writing |
| Preparing to Write a .NET SP, UDF, or Trigger |
| Writing a New SP, UDF, or Trigger |
| .NET types |
| A |
| “Add Unique Keys First” Feature Applied to ctADD2END Files |
| A c-treeACE SQL Explorer for Your Web Browser |
| Accessing Old and New Rows in Triggers |
| Added Conditional Expression Support for Partitioned Files |
| Added Restrictions on Advanced Encryption Master Key Configuration Options |
| Additional File Management Options |
| Advanced Data Integrity Controls |
| Advanced encryption master key store encrypted at system level on Windows |
| Advanced Full-Text Search Indexing |
| Allow a Single Byte or SByte to be passed as a BINARY Value in ADO.NET |
| Allow DOUBLE as an alias for DOUBLE PRECISION data type |
| Altering the SP, UDF, or Trigger |
| And More Tools... |
| AssemblyInfo.cs |
| Associate Replication to Specific Server Nodes |
| Asynchronous Record Update Notifications |
| Automatic c-treeDB Batch Buffer Resize |
| Automatic Directory Creation for New Files |
| Automatic Directory Creation for New Files |
| New Xtd8 File Mode to Automatically Create Directories |
| Automatic Recovery Considerations |
| Auto-Numbering Replication Defaults Changed |
| Avoid FairCom Server Termination with Internal Error 8987 When Using UNBUFFERED_IO Configuration Option |
| B |
| Browser Based c-treeACE SQL Explorer |
| Browser Based c-treeACE SQL Explorer |
| Latest in Tools Development |
| Browser-Based Administration Tools |
| C |
| CloseConnection API Function to Cleanly Shut Down a Forked Connection |
| Command-Line Tools for Administrators |
| Command-Line Utility Updates |
| And More Tools... |
| Command-Line Utility Updates |
| Latest in Tools Development |
| COMMIT_DELAY Configuration Now Defaults to 1 ms on Linux Systems |
| Common Table Expressions (CTE) and Recursive Queries |
| Common Table Expressions (CTE) and Recursive Queries |
| Latest c-treeACE SQL Features |
| Conditional Expressions and Partition Rules |
| Configurable Timeout for Replication Agent Network Calls |
| Configuration Options for c-treeACE SQL LATTE Subsystem |
| connection string |
| Controls for Performance AND Safety of Non-Transaction Updates |
| Controls for Performance AND Safety of Non-Transaction Updates |
| Great Performance News for OLTP Applications |
| Coordinate Application Recovery with Transaction Restore Points |
| Coordinate Application Recovery with Transaction Restore Points |
| Coordinate Application Recovery with Transaction Restore Points |
| Copy Files Between c-treeACE Servers |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpAddFileCopyOperation |
| ctfcpAllocateHandle |
| ctfcpFreeHandle |
| ctfcpGetErrorBuffer |
| ctfcpRemoveFileCopyOperation |
| ctfcpSetCallback |
| ctfcpSetCopyFilenames |
| ctfcpSetCopyFilePassword |
| ctfcpSetCopyOptions |
| ctfcpSetErrorBuffer |
| ctfcpSetServerParameters |
| Copyright Notice |
| Correct Error Messages Now Returned by fc_create_user Procedure |
| Corrected Errors When Changing a Temporary Index Condition |
| Corrected Prime Cache Thread Unhandled Exception When Opening File Pending Delete |
| Corrected Read and Write Errors after Connection Termination |
| Corrected Unexpected FairCom Server Internal Error 7495 Crash |
| Corrected Unhandled Exception When File Password Included in Open File Call |
| Correctly Terminate Orphaned Replication Agent Source and Target Server Connections |
| Counting the Number of Deferred Operations |
| Creating Restore Points |
| Critical Production Updates |
| CSSqlSpTemplate |
| ctcompare - Database Comparison Tool |
| ctCopyFile |
| ctDeferredIndexControl |
| ctDeferredIndexControl |
| Deferred Indexing |
| ctfcpAddFileCopyOperation |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpAddFileCopyOperation |
| File Copy Wrapper API Functions |
| ctfcpAllocateHandle |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpAllocateHandle |
| File Copy Wrapper API Functions |
| ctfcpCopyFile |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpCopyFile |
| File Copy Wrapper API Functions |
| ctfcpFreeHandle |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpFreeHandle |
| File Copy Wrapper API Functions |
| ctfcpGetErrorBuffer |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpGetErrorBuffer |
| File Copy Wrapper API Functions |
| ctfcpRemoveFileCopyOperation |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpRemoveFileCopyOperation |
| File Copy Wrapper API Functions |
| ctfcpSetCallback |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpSetCallback |
| File Copy Wrapper API Functions |
| ctfcpSetCopyFilenames |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpSetCopyFilenames |
| File Copy Wrapper API Functions |
| ctfcpSetCopyFilePassword |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpSetCopyFilePassword |
| File Copy Wrapper API Functions |
| ctfcpSetCopyOptions |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpSetCopyOptions |
| File Copy Wrapper API Functions |
| ctfcpSetErrorBuffer |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpSetErrorBuffer |
| File Copy Wrapper API Functions |
| ctfcpSetServerParameters |
| Copy Files Between c-treeACE Servers |
| ctCopyFile |
| ctfcpSetServerParameters |
| File Copy Wrapper API Functions |
| ctRecordUpdateCallbackControl |
| c-tree Properties |
| c-treeACE Explorer |
| c-treeACE Gauges |
| c-treeACE ISAM Explorer |
| c-treeACE ISAM Usage |
| c-treeACE Java Edition Solutions |
| c-treeACE Java Edition Solutions |
| Everything for Java |
| Java Family Expands |
| c-treeACE JDBC |
| c-treeACE JDBC |
| Everything for Java |
| Java Family Expands |
| ctreeACE JDBC for Stored Procedures |
| c-treeACE JDBC Java 1.5 Compatible Driver Availability |
| c-treeACE Memory Allocation Limit Disabled |
| c-treeACE Monitor |
| c-treeACE Monitor |
| c-treeACE Monitor |
| c-treeACE No+SQL Solutions |
| c-treeACE NoSQL ISAM APIs |
| c-treeACE Replication Monitor |
| c-treeACE Replication Solutions |
| c-treeACE Security Administrator |
| c-treeACE SQL APIs |
| c-treeACE SQL Data Arrays™ for Sub-Record Data |
| c-treeACE SQL Data Arrays™ for Sub-Record Data |
| Cutting-Edge No+SQL Features |
| No+SQL Integration Enhancements |
| c-treeACE SQL Deployment Utilities for Stored Procedures, UDF, and Triggers |
| c-treeACE SQL Direct SQL ctsqlGetNumericParameterAsString |
| c-treeACE SQL Direct SQL ctsqlGetParameterName() |
| c-treeACE SQL Direct SQL ctsqlIsParameterNull |
| c-treeACE SQL Direct SQL sqlda cursors |
| c-treeACE SQL Entity Framework 6 Support with ADO.NET |
| c-treeACE SQL Entity Framework 6 Support with ADO.NET |
| Latest c-treeACE SQL Features |
| c-treeACE SQL Explorer |
| c-treeACE SQL Features |
| c-treeACE SQL Features |
| SQL Speed-Up |
| c-treeACE SQL FILESET for Dynamic Joining of Physical Data Files |
| c-treeACE SQL FILESET for Dynamic Joining of Physical Data Files |
| Cutting-Edge No+SQL Features |
| No+SQL Integration Enhancements |
| c-treeACE SQL JDBC Now Allows Specifying User and Password in Connection URL |
| c-treeACE SQL JDBC Socket Timeout Defaults to 0 |
| c-treeACE SQL ODBC Ability to Set "Default Fetch Size" in DSN or Connection String |
| c-treeACE SQL ODBC Ability to Set Query Timeout in DSN and Connection String |
| c-treeACE SQL ODBC Unix ODBC driver for AIX and Solaris |
| c-treeACE SQL Query Builder |
| c-treeACE SQL SETENV limit raised to 8192 |
| c-treeACE SQL Stored Procedure Development in the .NET Framework |
| c-treeACE SQL Stored Procedure Server-side Debugging Options |
| c-treeDB - New key type for Deferred Index |
| c-treeDB Callback Updates for Types SDK |
| c-treeDB Default Field Types Added |
| c-treeDB for Java Now Supports MRT Tables |
| c-treeDB Java |
| c-treeDB Java |
| Everything for Java |
| Java Family Expands |
| c-treeDB Partition File API Support |
| ctrepd Replication Debug Utility |
| ctsqlapi.dll |
| ctsrvr.cfg |
| ctThrdSharedCritical API for Scalable Read Locks |
| ctTRANMODE Control Added to Transaction Control Utility cttrnmod |
| ctVerifyFile |
| Cutting-Edge No+SQL Features |
| D |
| Data Record Compression Optimization |
| Database Management Methods Added to ADO.NET Data Provider |
| Deadlock Corrected in Data Cache Retrieval Function |
| DEBUG (NetBeans) |
| Debugging the SP, UDF, or Trigger |
| Deferred File and Index Maintenance |
| Deferred Indexing |
| Delayed Durability Behavior |
| Delayed Durability Transaction Log Mode for Performance |
| Delayed Durability Transaction Log Mode for Performance |
| Great Performance News for OLTP Applications |
| Delete Node and Space Reclamation Threads no Longer Preclude File Access |
| Deploying the SP, UDF, or Trigger |
| dfkctl - Deferred Index Maintenance Utility |
| Deferred Indexing |
| dfkctl - Deferred Index Maintenance Utility |
| Directly Set a Replication Agent Start Position |
| DLLNotFoundException |
| Document History |
| Dr. c-tree |
| Dynamic Dump Stream Files No Longer Segment by Default |
| E |
| Editing Stored Procedures |
| Embarcadero (Borland) XE - Support for 64-bit VCL Drivers |
| Embedded Web Server for Browser Based Administration |
| Browser-Based Administration Tools |
| Embedded Web Server for Browser Based Administration |
| Enabling Debugging |
| Enterprise Java Beans |
| Enterprise Java Beans |
| Everything for Java |
| Java Family Expands |
| errors |
| Everything for Java |
| Execute() |
| ExecuteSP |
| Accessing Old and New Rows in Triggers |
| Returning a Result Set from a Stored Procedure |
| Returning a UDF Result |
| Writing the Code |
| Extended ALTER VIEW, ALTER TABLE, and ALTER INDEX Flexibility |
| Extended ALTER VIEW, ALTER TABLE, and ALTER INDEX Flexibility |
| Latest c-treeACE SQL Features |
| Extended c-treeACE Features |
| Extended c-treeACE SQL Stored Procedure Frameworks |
| Extended c-treeDB Default Field Value Support |
| External Notification of Replication Agent Events |
| F |
| FairCom and Current Database Technology Trends |
| FairCom Server - Change defaults for V11 release |
| FairCom Server - Configuration option to disable delete node thread |
| FairCom Typographical Conventions |
| FairCom.CtreeDb - Added ServerDateTime methods |
| Faster Open of c-treeDB Tables |
| File Copy Wrapper API Functions |
| FILESET host creation utility |
| c-treeACE SQL FILESET for Dynamic Joining of Physical Data Files |
| FILESET host creation utility |
| Flush Directory Metadata to Disk for Transaction-Dependent File Creates, Deletes and Renames |
| Flush KEEPOPEN Files to Disk With Last File Close for Enhanced Data Integrity |
| G |
| GetServerDateTime() Added to c-treeDB for Java |
| GetServerDateTime() Added to c-treeDB for Java |
| Table Lock Support |
| Great Performance News for OLTP Applications |
| H |
| Header Record Counts Output with ctinfo c-tree Information Utility |
| host |
| I |
| Import from Server |
| Improved Error Handling for Replication Agent HTRN_ERR (520) |
| Improved File Descriptor Limit Messages Logged During Server Startup |
| Improved Index Update Performance |
| Improved Performance of Failed Batch Inserts with Savepoint Restores |
| Improved Responsiveness of the c-treeACE Replication Monitor |
| Improved Unix Performance with Shorter Adaptive Defer for Index Node Retrievals |
| Inconsistent FPUTFGET Header Locking for Non-HUGE Index Files and Variable-Length Data Files |
| installation, .NET plugin |
| Installing the NetBeans Plugin |
| Interface Technology Additions |
| File Copy Wrapper API Functions |
| Interface Technology Additions |
| Introduction |
| IPv6 Support |
| J |
| Java Family Expands |
| Java Persistence API (JPA) with c-treeACE |
| Everything for Java |
| Java Family Expands |
| Java Persistence API (JPA) with c-treeACE |
| Java Stored Procedure Runtime Classes no Longer Require ctreedbs in Path |
| JDBC - Character Set Can Now Be Specified in the Connection URL |
| jdbc_ctree_6597@localhost_ctreeSQL |
| L |
| Latest c-treeACE SQL Features |
| Latest in Tools Development |
| Latest Microsoft Visual Studio 2015 Support |
| Latest News for GUI Tools |
| LDAP Authentication Controls and Group Support |
| Limit Replication Debug Utility Output to Specific Files |
| Linux Direct I/O (UNBUFFERED I/O) Performance Support |
| Linux File System Performance and Safety |
| localhost |
| LOCK TABLE Statement Added |
| Latest c-treeACE SQL Features |
| LOCK TABLE Statement Added |
| SQL Speed-Up |
| LOKREC() modes to unlock all records in all files of the specified type that are open by the caller |
| M |
| Managing Partitions |
| Many Other Requested Features |
| Maximum Index Members per File (MAXMEMB) |
| Maximum LIST_MEMORY Setting Increased to 10MB |
| Maximum Number of Indexes per Data File (MAX_DAT_KEY) Default Increased to 64 |
| Maximum Number of Open Files per User (MAX_FILES_PER_USER) Default Increased to 32767 |
| Memory Tracking with c-treeACE on Linux |
| Message Written to Standard Output When File Descriptor Limit is too Low |
| Millisecond Timestamp Resolution Support |
| Document History |
| Millisecond Timestamp Resolution Support |
| Modified Log Sync Strategy |
| Monitor c-treeACE Memory Use and Suballocator List Allocation Call Stacks |
| Monitoring Delayed Durability Performance |
| N |
| namespace |
| NetBeans |
| debugging |
| editing |
| installing |
| Installing the NetBeans Plugin |
| Setting up the Connection to the Server |
| server connection |
| NetBeans Plugin for Java Stored Procedure Development |
| New ctFeatKEEP_XFREED Lock Mode to Mark Entires in User Lock Table for Unlock Requests During a Transaction |
| New Deferred File and Index Maintenance |
| Deferred File and Index Maintenance |
| New Deferred File and Index Maintenance |
| New Extended Data Types Support |
| Millisecond Timestamp Resolution Support |
| New Extended Data Types Support |
| New file descriptor limit compatibility keyword |
| New File Descriptor Operational Parameters |
| New File Verification Utilities - ctflvrfy.exe, ctvfyfil.exe, ctvfyidx.exe |
| Document History |
| New File Verification Utilities - ctflvrfy.exe, ctvfyfil.exe, ctvfyidx.exe |
| New Stored Procedure Development Frameworks |
| Latest c-treeACE SQL Features |
| New Stored Procedure Development Frameworks |
| New Xtd8 File Mode to Automatically Create Directories |
| Automatic Directory Creation for New Files |
| New Xtd8 File Mode to Automatically Create Directories |
| NewResultSetRow |
| No+SQL Data Access |
| No+SQL Integration Enhancements |
| Notable Compatibility Changes |
| Extended c-treeACE Features |
| Notable Compatibility Changes |
| null handling |
| O |
| Overview of Current c-treeACE Interface Technology |
| P |
| Partitioned Files in c-treeACE SQL |
| Performance Gains |
| Permit ADMIN Group Member Access to Files with Corrupt Resource Chains |
| PHP - Components Now Match non-Thread-Safe Defaults for Windows IIS PHP Installations |
| Physical read of variable-length transaction controlled file skips records added by a third-party transaction not yet committed |
| port |
| Enabling Debugging |
| Setting up the Connection to the Server |
| Preparing to Write a .NET SP, UDF, or Trigger |
| Prevent c-tree Server Unhandled Exception During Update of Compressed Record |
| Prevent FairCom Server WRITE_ERR Termination with Open Transactions Aborted by Quiesce |
| Prevent ISAM Index Key Value Updates |
| Prevent Unhandled Exception When a Single Connection Opens a File More than 1024 Times |
| Program.cs |
| Proper positioning of ctdbSeekRecord with active record sets |
| Properties |
| Properties, NetBeans |
| Editing Stored Procedures |
| Setting up the Connection to the Server |
| Q |
| Queuing an Index Load |
| R |
| ReFS |
| Relaxed COMPATIBILITY FORCE_WRITETHRU Defaults |
| Replication Actions Added to Transaction Control Utility cttrnmod |
| Replication Agent - c-tree DB Engine notification |
| Replication Agent - File Notification Queue Events |
| Replication Agent - The Next Generation |
| Replication and Distributed Servers |
| Replication Debug Utility Options to Specify User Name and Password |
| Replication Debug Utility Timestamps Displayed in Local Time Format |
| Replication for Every Need |
| Replication Manager |
| Browser-Based Administration Tools |
| Replication and Distributed Servers |
| Replication Manager |
| Restore Point Files |
| Creating Restore Points |
| Restore Point Files |
| Restore Points as an Incremental Roll Forward Strategy |
| Restore Point Limitations |
| Restore Points as an Incremental Roll Forward Strategy |
| resultset |
| Altering the SP, UDF, or Trigger |
| Returning a Result Set from a Stored Procedure |
| Writing a New SP, UDF, or Trigger |
| Retrieve Current Server Date and Time |
| Returning a Result Set from a Stored Procedure |
| Returning a UDF Result |
| Rollback to New Restore Points with ctrdmp |
| Rolling Back to a Restore Point |
| S |
| Scrollable SQL Cursors |
| Latest c-treeACE SQL Features |
| Scrollable SQL Cursors |
| Security Controls |
| Server Connection |
| server connection, NetBeans |
| Server Now Fails to Start if File Descriptor Limit Can't be Increased to Required Value |
| Server process exit code more informative |
| Setting up the Connection to the Server |
| Sp.cs |
| Specify Shared Memory Keys on Unix |
| SQL - BINARY fields not padded with 0x00 |
| SQL - Binary Literals |
| SQL - Changed error message for error -20139 |
| SQL data types |
| null handling |
| SQL Group Support for User Role Management |
| Latest c-treeACE SQL Features |
| SQL Group Support for User Role Management |
| SQL Speed-Up |
| SqlSpResulsetRow |
| Support Partial Record Rewrite in Local/Master Synchronous Replication |
| SYSLOG Logging of Restore Point |
| System Group Assignment of Unix/Linux Shared Memory resources |
| T |
| Table Lock Mode for LOKREC |
| Table Lock Support |
| Table Valued Functions |
| template location |
| Temporary Event File |
| Test Procedure |
| Debugging the SP, UDF, or Trigger |
| Testing the SP, UDF, or Trigger |
| Testing the SP, UDF, or Trigger |
| testsp |
| Time limit on flushing updated data and index cache pages for TRNLOG files |
| Controls for Performance AND Safety of Non-Transaction Updates |
| Time limit on flushing updated data and index cache pages for TRNLOG files |
| Toggle Serial Segment (SRLSEG) Support for Files |
| Transaction Restore Points |
| triggers, old and new rows |
| U |
| UDF result |
| Unhandled Exception When Accessing Pruned Memory Index Node |
| Unicode default charset for SQL CHAR and VARCHAR changed from US-ASCII to ISO-8859-1 |
| Unicode Support |
| Update Callback Specifications |
| Asynchronous Record Update Notifications |
| Update Callback Specifications |
| Use of Domain Sockets for Faster Unix/Linux Shared Memory Connections |
| User-Defined Conditional Expressions for Easy Partitioned File Creation |
| User-Defined Function for Conditional Expressions |
| User-Defined Partitioned File Conditional Expressions |
| Using ctalog SYSLOG Utility to Read Restore Point Data |
| SYSLOG Logging of Restore Point |
| Using ctalog SYSLOG Utility to Read Restore Point Data |
| V |
| V11 Performance Gains |
| V11: One Database. Countless Possibilities. |
| Verify Data and Index File Integrity |
| Visual Studio |
| Preparing to Write a .NET SP, UDF, or Trigger |
| Visual Studio .NET Development |
| Visual Studio .NET Development |
| W |
| Windows Servers Now Statically Linked with ZLIB Compression Libraries |
| Writing a New SP, UDF, or Trigger |
| Writing the Code |