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
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