 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
 createfilesethost - FairCom DB SQL Fileset Host Utility
 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
 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
|