SQL Operations Guide

FairCom DB SQL Operations and Utilities Guide Installation Up and Running with the FairCom DB Database Engine FairCom DB SQL Operational Files FairCom DB SQL Features Advanced Encryption for FairCom DB SQL Tables Default HUGE File Tables with FairCom DB SQL PREIMAGE Tables in FairCom DB SQL Shared Memory Connections for FairCom DB SQL Clients on Windows Server-Side Connection Pooling Supported Transaction Isolation Levels Case Insensitive Search Options for FairCom DB SQL LONG Field Types Query Timeout Option Logging FairCom DB SQL Query Times Built-in Stored Procedure to Switch Transaction Mode FairCom DB SQL Options Environment Variables Default Date Handling Case-Sensitivity Options Optimizer Configuration Options c-treeDB API ROWID Options Automatic Database Conversion Options Template Database __Master.dbs Handling SQL_DEBUG Options Advanced FairCom DB SQL Logging Memory Manager (MM) System for Temporary Storage FairCom DB SQL Java Configuration for Stored Procedures, Triggers and User Defined Functions Run-Time Settings for Java Stored Procedure Support Advanced JVM Configuration FairCom DB SQL Utilities ctpath - Change Internal (SQL) Database Paths ctsqlbigint - FairCom DB SQL Big Integer Fix Utility ctsqlcdb - FairCom DB SQL Database Maintenance Utility ctsqlimp - FairCom DB SQL Import Utility Auto Import ctsqlimp Usage Specifying Primary Keys from Imported Indexes ctsqlimp Check for Max Number of Indexes/Segments Allow Linking SQL Indexes with Rightmost Segment(s) on Hidden Field(s) Mapping Unsigned Integers with FairCom DB 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 Indexes with Segment on String Field Missing Last Byte Import Duplicate Filenames into FairCom DB SQL Auto Import Callback Auto Import: Tables that are missing on disk will now be Auto Purged ctsqlutl - FairCom DB SQL Table Maintenance Utility ctsqlmdd - FairCom DB SQL Merge Database Utility cttrnmod - Change Transaction Mode Utility fkverify sqlverify Combining FairCom DB SQL with ISAM Accessing FairCom DB SQL Files from ISAM Applications Defining a Table Using FairCom DB SQL Examining Resulting File Specifications Using Existing ISAM Data with FairCom DB SQL Mapping of c-tree to FairCom DB SQL Types Identify "Bad" Records with ctoption(badrec) FairCom DB SQL Types SDK Overview of the FairCom DB SQL Types SDK An example field conversion FairCom DB SQL with Callbacks The Server Architecture FairCom DB SQL Callback Dynamic Library FairCom DB SQL Callback Configuration File How to specify MYTIME field translation Specifying the configuration file location The File Definition Generating Utility Importing Tables Into FairCom DB SQL Import Utility Callback Architecture Import Utility Callback Configuration File Building the callback libraries Example Server Callback Makefile Example Import Utility Callback Makefile Which FairCom DB and c-treeDB API Functions are Safe? Migrating to FairCom DB SQL Migration from c-tree ODBC to FairCom DB SQL ODBC Overview of the FairCom DB SQL Migration SDK Migration Key Steps Important Observations Customization Migration Callbacks FairCom DB SQL Configuration 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 SESSION_TIMEOUT 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_LOG SQL Statement Diagnostic Logging Keyword Added to Default Server Config SETENV TPE_MM_CACHESIZE SETENV TPE_MM_COMPARE_OVHD SETENV TPE_MM_INSERT_OVHD SETENV TPE_MM_SWAPSIZE SETENV TPE_TMPDIR SQL_OPTION CHECK_HEAP SQL_OPTION BADDATES_ASNULL SQL_OPTION BADTIMES_ASNULL 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 DROP_TABLE_DICTIONARY_ONLY 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 OLD_DELFLD_LEN SQL_OPTION OWNER_FILE_NAMES SQL_OPTION PAD_WITH_NULL SQL_OPTION PARTIAL_SEG SQL_OPTION PID_IN_NODEID 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 SQL_DEBUG LOG_STMT_TIMES SQL_DEBUG LOG_STMT_TIMES_FETCH SQL_DEBUG TRACE_ON_PANIC SQL_SERVER_LOG_SIZE SQL_SESSION_TIMEOUT SUBSYSTEM SQL LATTE SYSLOG SYSLOG SQL_STATEMENTS Configuration Keyword FairCom DB 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_hosttablename() 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_purge_db() 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_rowid_visible() fc_set_selectivity( ) fc_set_sysconfig() FairCom DB SQL Reserved Words DH_QUOTE_QUAL_IDENT - Reserved Words as Delimited Identifiers FairCom Typographical Conventions Copyright Notice Index