Contents

Copyright Notice c-treeACE SQL Operations and Utilities Guide FairCom Typographical Conventions Installation Up and Running with the c-treeACE Database Engine Specific SQL Operational Files to Observe c-treeACE SQL Features Advanced Encryption for c-treeACE SQL Tables Default HUGE File Tables with c-treeACE SQL PREIMAGE Tables in c-treeACE SQL Shared Memory Connections for c-treeACE SQL Clients on Windows Server Side Connection Pooling Supported Transaction Isolation Levels Case Insensitive Search Options for c-treeACE SQL LONG Field Types Query Timeout Option Logging c-treeACE SQL Query Times c-treeACE SQL Utilities ctpath - Change Internal Database Paths ctsqlbigint - c-treeACE SQL Big Integer Fix Utility ctsqlimp - c-treeACE SQL Import Utility Usage Specifying primary keys from imported indexes Mapping unsigned integers with c-treeACE SQL Check for Invalid Characters in Field Names Support for Importing Table with an Alternative Name Null Fields and Field Default Values Considerations ctsqlimp Import Indices With Segment On String Field Missing Last Byte ctsqlutl - c-treeACE SQL Table Maintenance Utility ctsqlcdb - c-treeACE SQL Database Maintenance Utility ctsqlmdd - c-treeACE SQL Move Database Utility cttrnmod - Change Transaction Mode Utility fkverify c-treeACE SQL Configuration Options Environment Variables Memory Manager (MM) System for Temporary Storage Run-Time Settings for Java Stored Procedure Support Default Date Handling Case-Sensitivity Options Optimizer Configuration Options c-treeDB ROWID Options Automatic Database Conversion Options Template Database __Master.dbs Handling SQL_DEBUG Options Advanced c-treeACE SQL Logging Combining c-treeACE SQL with ISAM Accessing c-treeACE SQL Files from ISAM Applications Defining a Table Using c-treeACE SQL Examining Resulting File Specifications Field Definitions Considerations for ISAM applications Table and Index Definitions Using Existing ISAM Data with c-treeACE SQL Table Definition Requirements Index Definition Requirements Adding DODAs to Existing Files c-treeACE SQL Types SDK Overview of the c-treeACE SQL Types SDK An example field conversion c-treeACE SQL with Callbacks The Server Architecture c-treeACE SQL Callback Dynamic Library Windows environment Unix environment c-treeACE SQL callback configuration file How to specify MYTIME field translation Specifying the configuration file location The File Definition Generating Utility Importing Tables Into c-treeACE SQL Import Utility Callback Architecture Import Utility Callback Configuration File Building the callback libraries Example Server Callback Makefile Example Import Utility Callback Makefile Which c-treeACE and c-treeDB Functions are Safe? Migrating to c-treeACE SQL Migration From c-tree ODBC to c-treeACE SQL ODBC Overview of the c-treeACE SQL Migration SDK Migration Key Steps Important Observations Customization Migration Callbacks: c-treeACE SQL Configuration Keywords c-treeACE SQL Configuration Keywords c-treeACE SQL Built-in Stored Procedures c-treeACE SQL Standard Stored Procedures c-treeACE SQL Reserved Words c-treeACE SQL Reserved Words V9 Index