c-treeACE SQL Operations and Utilities Guide

 
Copyright Notice
c-treeACE SQL Operations and Utilities Guide
FairCom Typographical Conventions
Installation
Up and Running with the c-treeACE Database Engine
c-treeACE SQL Operational Files
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
Built-in Stored Procedure to Switch Transaction Mode
c-treeACE SQL Options
Environment Variables
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
Memory Manager (MM) System for Temporary Storage
c-treeACE SQL Java Configuration for Stored Procedures, Triggers and User Defined Functions
Run-Time Settings for Java Stored Procedure Support
Debugging Java Stored Procedures
Advanced JVM Configuration
c-treeACE SQL Utilities
ctpath - Change Internal Database Paths
ctsqlbigint - c-treeACE SQL Big Integer Fix Utility
ctsqlcdb - c-treeACE SQL Database Maintenance Utility
ctsqlimp - c-treeACE SQL Import Utility
ctsqlimp usage
Specifying primary keys from imported indices
ctsqlimp check for max number of indices/segments
Allow linking SQL indices with rightmost segment(s) on hidden field(s)
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
Import Duplicate Filenames into c-treeACE SQL
ctsqlutl - c-treeACE SQL Table Maintenance Utility
ctsqlmdd - c-treeACE SQL Merge Database Utility
cttrnmod - Change Transaction Mode Utility
fkverify
sqlverify
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
Mapping of c-tree to c-treeACE SQL Types
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
c-treeACE SQL Configuration Keywords
MAX_SQL_ISOLATION_LEVEL
SQL_CONNECT_TIMEOUT_SEC
SQL_DATABASE
SQL_IDLE_WAKE
SQL_KEEP_OPEN_TABLES
SQL_LOGFILE
SQL_MIN_CARD
SQL_PARTOPEN_COST
SQL_PORT
SQL_TRACE_CTREE_ERROR
SETENV CLASSPATH
SETENV DEBUG_JVM
SETENV DEBUG_JVM_PORT
SETENV DH_CACHED_STATEMENTS
SETENV DH_DO_AHEAD
SETENV DH_DYN_CACHED_STATEMENTS
SETENV DH_ENABLE_POOL
SETENV DH_JVM_OPTION_STRINGS
SETENV DH_ENABLE_POOL
SETENV DH_OPT_OR_CARD
SETENV DH_POOL_SIZE
SETENV DH_REBUILD_SEL_CUTOFF
SETENV DH_THREAD_STACK_SZ_KB
SETENV DH_SVR_DA_BUFFER
SETENV JAVA_COMPILER
SETENV JVM_LIB
SETENV TPESQLDBG
SETENV TPE_DFLT_DATE
SETENV TPE_MM_CACHESIZE
SETENV TPE_MM_COMPARE_OVHD
SETENV TPE_MM_INSERT_OVHD
SETENV TPE_MM_SWAPSIZE
SQL_OPTION CHECK_HEAP
SQL_OPTION CTSTRING_VARCHAR
SQL_OPTION CREATE_WITH_ROWID
SQL_OPTION CREATE_WITH_RECBYT
SQL_OPTION CTDB_ROWID
SQL_OPTION DB_CASE_INSENSITIVE
SQL_OPTION FORCE_TEMPLATE_DB
SQL_OPTION HOT_ALTER_TABLE
SQL_OPTION HM_ACTIVE
SQL_OPTION LOAD_CALLBACK_LIB
SQL_OPTION NO_AUTO_ABORT
SQL_OPTION NO_BINARY_PAD
SQL_OPTION NO_CARDINALITY
SQL_OPTION NO_COSTS
SQL_OPTION NO_CRYPT_SYSTBL
SQL_OPTION NO_DB_CONVERSION
SQL_OPTION NO_DUP_IDXNAME
SQL_OPTION NO_HUGEFILE
SQL_OPTION NO_IPV6
SQL_OPTION NO_PUSHDOWN
SQL_OPTION NO_REVERSE_INDEX
SQL_OPTION NO_SELECTIVITY
SQL_OPTION NO_SHARED_MEMORY
SQL_OPTION NO_SYSSUPERFILE
SQL_OPTION OWNER_FILE_NAMES
SQL_OPTION PAD_WITH_NULL
SQL_OPTION PARTIAL_SEG
SQL_OPTION PRESERVE_CURSOR_FREE_LOCK
SQL_OPTION SUPPRESS_JVM_LOAD_ERR
SQL_OPTION USE_MM
SQL_DEBUG ABORT_ON_PANIC
SQL_DEBUG ERROR_INFO
SQL_DEBUG INDEX
SQL_DEBUG INDEX_SEL
SQL_DEBUG INDEX_DEF_SEL
SQL_DEBUG INDEX_INFO
SQL_DEBUG LOG_STUBS_HIGH
SQL_DEBUG LOG_STUBS_MED
SQL_DEBUG LOG_STUBS_LOW
SQL_DEBUG LOG_STMT_TIMES
SQL_DEBUG LOG_STMT_TIMES_FETCH
c-treeACE SQL Built-in Stored Procedures
fc_add_db( )
fc_check_file_tran_state( )
fc_create_db( )
fc_create_user( )
fc_get_cachestats()
fc_get_connstats()
fc_get_dblist( )
fc_get_fcproclist( )
fc_get_filestats()
fc_get_iostats()
fc_get_isamstats()
fc_get_lockstats()
fc_get_memstats()
fc_get_min_card( )
fc_get_priority( )
fc_get_partbounds()
fc_get_replstats()
fc_get_selectivity( )
fc_get_server_version( )
fc_get_sqlstats()
fc_get_sysconfig()
fc_get_taskid( )
fc_get_transtats()
fc_get_userlist( )
fc_ptadmin_num()
fc_set_blockinglock( )
fc_set_debug( )
fc_set_file_tran_state( )
fc_set_impersonation( )
fc_set_min_card( )
fc_set_nodename( )
fc_set_priority( )
fc_set_selectivity( )
fc_set_sysconfig()
c-treeACE SQL Reserved Words
c-treeACE SQL Reserved Words
Index