SQL Operations Guide
Index
Symbols & Numeric
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X Y Z
Symbols & Numeric
4025 CTDB_INTERNAL
A
Accessing FairCom DB SQL Files from ISAM Applications
Advanced Encryption for FairCom DB SQL Tables
Advanced FairCom DB SQL Logging
Advanced FairCom DB SQL Logging
fc_set_debug( )
SETENV TPESQLDBG
Advanced JVM Configuration
Allow Linking SQL Indexes with Rightmost Segment(s) on Hidden Field(s)
An example field conversion
Auto Import
Auto Import Callback
Auto Import: Tables that are missing on disk will now be Auto Purged
Automatic Database Conversion Options
B
Building the callback libraries
Built-in Stored Procedure to Switch Transaction Mode
C
callbacks
ctcbklib.c
c-treeDB
ctsqlcbk.dll
ctsqlcbk.ini
ctsqlimp.dll
data type conversion
libctsqlcbk.so
migration utility
unsafe c-treeDB functions
Case Insensitive Search Options for FairCom DB SQL LONG Field Types
Case-Sensitivity Options
Check for Invalid Characters in Field Names
Combining FairCom DB SQL with ISAM
conversion
ctsqlcbk.def
Copyright Notice
createfilesethost - FairCom DB SQL Fileset Host Utility
ctcbklib.c
callbacks
CTDB_INTERNAL
CTDB_INTERNAL (4025)
ctpath - Change Internal (SQL) Database Paths
c-treeDB
data types SDK
unsafe callback functions
c-treeDB API ROWID Options
c-treeSQL
migration
CTDB_INTERNAL error
types
ctsqlbigint - FairCom DB SQL Big Integer Fix Utility
ctsqlcbk.def
data type conversion
ctsqlcbk.dll
data type conversion
ctsqlcbk.ini
callbacks
c-treeDB callbacks
ctsqlcdb - FairCom DB SQL Database Maintenance Utility
ctsqlimp
data type conversion
migrating data
ctsqlimp - FairCom DB SQL Import Utility
ctsqlimp Check for Max Number of Indexes/Segments
ctsqlimp Import Indexes with Segment on String Field Missing Last Byte
ctsqlimp Usage
ctsqlimp.dll
building
callbacks
makefile
ctsqlmdd - FairCom DB SQL Merge Database Utility
ctsqlutl - FairCom DB SQL Table Maintenance Utility
cttrnmod - Change Transaction Mode Utility
Customization
D
data types
conversion with c-treeDB
c-treeSQL types SDK
Default Date Handling
Default HUGE File Tables with FairCom DB SQL
Defining a Table Using FairCom DB SQL
DH_QUOTE_QUAL_IDENT - Reserved Words as Delimited Identifiers
E
Environment Variables
errors
CTDB_INTERNAL (4025)
Examining Resulting File Specifications
Example Import Utility Callback Makefile
Example Server Callback Makefile
F
FairCom DB SQL Built-in Stored Procedures
FairCom DB SQL Callback Configuration File
FairCom DB SQL Callback Configuration File
Import Utility Callback Architecture
FairCom DB SQL Callback Dynamic Library
FairCom DB SQL Callback Dynamic Library
The Server Architecture
FairCom DB SQL Configuration
FairCom DB SQL Configuration
The Server Architecture
FairCom DB SQL Features
FairCom DB SQL Java Configuration for Stored Procedures, Triggers and User Defined Functions
FairCom DB SQL Operational Files
FairCom DB SQL Operations and Utilities Guide
FairCom DB SQL Options
FairCom DB SQL Reserved Words
FairCom DB SQL Types SDK
FairCom DB SQL Utilities
FairCom DB SQL with Callbacks
FairCom Typographical Conventions
fc_add_db( )
FairCom DB SQL Built-in Stored Procedures
fc_add_db( )
fc_check_file_tran_state( )
FairCom DB SQL Built-in Stored Procedures
fc_check_file_tran_state( )
fc_create_db( )
fc_create_user( )
FairCom DB SQL Built-in Stored Procedures
fc_create_user( )
fc_get_cachestats()
FairCom DB SQL Built-in Stored Procedures
fc_get_cachestats()
fc_get_connstats()
FairCom DB SQL Built-in Stored Procedures
fc_get_connstats()
fc_get_dblist( )
FairCom DB SQL Built-in Stored Procedures
fc_get_dblist( )
fc_get_fcproclist( )
FairCom DB SQL Built-in Stored Procedures
fc_get_fcproclist( )
fc_get_filestats()
FairCom DB SQL Built-in Stored Procedures
fc_get_filestats()
fc_get_hosttablename()
FairCom DB SQL Built-in Stored Procedures
fc_get_hosttablename()
fc_get_iostats()
FairCom DB SQL Built-in Stored Procedures
fc_get_iostats()
fc_get_isamstats()
FairCom DB SQL Built-in Stored Procedures
fc_get_isamstats()
fc_get_lockstats()
FairCom DB SQL Built-in Stored Procedures
fc_get_lockstats()
fc_get_memstats()
FairCom DB SQL Built-in Stored Procedures
fc_get_memstats()
fc_get_min_card( )
FairCom DB SQL Built-in Stored Procedures
fc_get_min_card( )
fc_get_partbounds()
FairCom DB SQL Built-in Stored Procedures
fc_get_partbounds()
fc_get_priority( )
FairCom DB SQL Built-in Stored Procedures
fc_get_priority( )
fc_get_replstats()
FairCom DB SQL Built-in Stored Procedures
fc_get_replstats()
fc_get_selectivity( )
FairCom DB SQL Built-in Stored Procedures
fc_get_selectivity( )
fc_get_server_version( )
FairCom DB SQL Built-in Stored Procedures
fc_get_server_version( )
fc_get_sqlstats()
FairCom DB SQL Built-in Stored Procedures
fc_get_sqlstats()
fc_get_sysconfig()
FairCom DB SQL Built-in Stored Procedures
fc_get_sysconfig()
fc_get_taskid( )
FairCom DB SQL Built-in Stored Procedures
fc_get_taskid( )
fc_get_transtats()
FairCom DB SQL Built-in Stored Procedures
fc_get_transtats()
fc_get_userlist( )
FairCom DB SQL Built-in Stored Procedures
fc_get_userlist( )
fc_ptadmin_num()
FairCom DB SQL Built-in Stored Procedures
fc_ptadmin_num()
fc_purge_db()
fc_set_blockinglock( )
FairCom DB SQL Built-in Stored Procedures
fc_set_blockinglock( )
fc_set_debug( )
Advanced FairCom DB SQL Logging
FairCom DB SQL Built-in Stored Procedures
fc_set_debug( )
fc_set_file_tran_state( )
FairCom DB SQL Built-in Stored Procedures
fc_set_file_tran_state( )
fc_set_impersonation( )
FairCom DB SQL Built-in Stored Procedures
fc_set_impersonation( )
fc_set_min_card( )
FairCom DB SQL Built-in Stored Procedures
fc_set_min_card( )
fc_set_nodename( )
FairCom DB SQL Built-in Stored Procedures
fc_set_nodename( )
fc_set_priority( )
fc_set_rowid_visible()
fc_set_selectivity( )
FairCom DB SQL Built-in Stored Procedures
fc_set_selectivity( )
fc_set_sysconfig()
FairCom DB SQL Built-in Stored Procedures
fc_set_sysconfig()
fkverify
H
How to specify MYTIME field translation
I
Identify "Bad" Records with ctoption(badrec)
Import Duplicate Filenames into FairCom DB SQL
Import Utility Callback Architecture
Import Utility Callback Configuration File
Important Observations
Importing Tables Into FairCom DB SQL
indexes
rebuilding
during c-treeSQL migration
when migrating data
Installation
K
Key Steps
L
libctsqlcbk.so
data type conversion
Logging FairCom DB SQL Query Times
M
Mapping of c-tree to FairCom DB SQL Types
Mapping Unsigned Integers with FairCom DB SQL
MAX_SQL_ISOLATION_LEVEL
Memory Manager (MM) System for Temporary Storage
migrate.c and migration utility
Migrating to FairCom DB SQL
Migration
Migration Callbacks
Migration from c-tree ODBC to FairCom DB SQL ODBC
migration utility
callbacks
ctsqlmgr.c
migrate.c
MigrationInfo structure
migrfncs.c
N
Null Fields and Field Default Values Considerations
O
Optimizer Configuration Options
Overview of the FairCom DB SQL Migration SDK
Overview of the FairCom DB SQL Types SDK
P
PREIMAGE Tables in FairCom DB SQL
Q
Query Timeout Option
R
rebuilding indexes
migrating data
Run-Time Settings for Java Stored Procedure Support
Run-Time Settings for Java Stored Procedure Support
SETENV CLASSPATH
SETENV JAVA_COMPILER
SETENV JVM_LIB
S
Server-Side Connection Pooling
SESSION_TIMEOUT
SETENV CLASSPATH
FairCom DB SQL Configuration
SETENV CLASSPATH
SETENV JAVA_COMPILER
SETENV JVM_LIB
SETENV DEBUG_JVM
SETENV DEBUG_JVM_PORT
SETENV DH_CACHED_STATEMENTS
SETENV DH_CACHED_STATEMENTS
SETENV DH_DYN_CACHED_STATEMENTS
SETENV DH_DO_AHEAD
SETENV DH_DYN_CACHED_STATEMENTS
SETENV DH_CACHED_STATEMENTS
SETENV DH_DYN_CACHED_STATEMENTS
SETENV DH_ENABLE_POOL
SETENV DH_ENABLE_POOL
SETENV DH_ENABLE_POOL
SETENV DH_JVM_OPTION_STRINGS
SETENV DH_OPT_OR_CARD
SETENV DH_POOL_SIZE
SETENV DH_REBUILD_SEL_CUTOFF
SETENV DH_SVR_DA_BUFFER
SETENV DH_THREAD_STACK_SZ_KB
SETENV JAVA_COMPILER
FairCom DB SQL Configuration
SETENV CLASSPATH
SETENV JAVA_COMPILER
SETENV JVM_LIB
SETENV JVM_LIB
FairCom DB SQL Configuration
SETENV CLASSPATH
SETENV JAVA_COMPILER
SETENV JVM_LIB
SETENV TPE_DFLT_DATE
FairCom DB SQL Configuration
SETENV TPE_DFLT_DATE
SETENV TPE_LOG
SETENV TPE_LOG
SQL_SERVER_LOG_SIZE
SETENV TPE_MM_CACHESIZE
SETENV TPE_MM_CACHESIZE
SQL_OPTION USE_MM
SETENV TPE_MM_COMPARE_OVHD
SETENV TPE_MM_COMPARE_OVHD
SQL_OPTION USE_MM
SETENV TPE_MM_INSERT_OVHD
SETENV TPE_MM_INSERT_OVHD
SQL_OPTION USE_MM
SETENV TPE_MM_SWAPSIZE
SETENV TPE_MM_SWAPSIZE
SQL_OPTION USE_MM
SETENV TPE_TMPDIR
SETENV TPESQLDBG
Shared Memory Connections for FairCom DB SQL Clients on Windows
Specifying Primary Keys from Imported Indexes
Specifying the configuration file location
SQL_CONNECT_TIMEOUT_SEC
SQL_DATABASE
SQL_DEBUG ABORT_ON_PANIC
SQL_DEBUG ERROR_INFO
SQL_DEBUG INDEX
SQL_DEBUG INDEX
SQL_DEBUG INDEX_INFO
SQL_DEBUG INDEX_DEF_SEL
SQL_DEBUG INDEX_INFO
SQL_DEBUG INDEX
SQL_DEBUG INDEX_INFO
SQL_DEBUG INDEX_SEL
SQL_DEBUG LOG_STMT
SQL_DEBUG LOG_STMT_TIMES
SQL_DEBUG LOG_STMT_TIMES_FETCH
SQL_DEBUG LOG_STMT
SQL_DEBUG LOG_STMT_TIMES
SQL_DEBUG LOG_STMT_TIMES_FETCH
SQL_DEBUG LOG_STUBS_HIGH
SQL_DEBUG LOG_STUBS_LOW
SQL_DEBUG LOG_STUBS_MED
SQL_DEBUG Options
SQL_DEBUG TRACE_ON_PANIC
SQL_IDLE_WAKE
SQL_KEEP_OPEN_TABLES
SQL_LOGFILE
SQL_MIN_CARD
SQL_OPTION BADDATES_ASNULL
SQL_OPTION BADTIMES_ASNULL
SQL_OPTION CHECK_HEAP
SQL_OPTION CREATE_WITH_RECBYT
SQL_OPTION CREATE_WITH_ROWID
SQL_OPTION CTDB_ROWID
SQL_OPTION CTSTRING_VARCHAR
SQL_OPTION DB_CASE_INSENSITIVE
SQL_OPTION DROP_TABLE_DICTIONARY_ONLY
SQL_OPTION FORCE_TEMPLATE_DB
SQL_OPTION HM_ACTIVE
SQL_OPTION HOT_ALTER_TABLE
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
Shared Memory Connections for FairCom DB SQL Clients on Windows
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
Memory Manager (MM) System for Temporary Storage
SQL_OPTION USE_MM
SQL_PARTOPEN_COST
SQL_PORT
FairCom DB SQL Configuration
SQL_PORT
SQL_SERVER_LOG_SIZE
SQL_SESSION_TIMEOUT
SQL_TRACE_CTREE_ERROR
sqlverify
SUBSYSTEM SQL LATTE
Support for Importing Table with an Alternative Name
Supported Transaction Isolation Levels
SYSLOG
SYSLOG SQL_STATEMENTS Configuration Keyword
T
Template Database __Master.dbs Handling
The File Definition Generating Utility
The Server Architecture
U
Up and Running with the FairCom DB Database Engine
Using Existing ISAM Data with FairCom DB SQL
W
Which FairCom DB and c-treeDB API Functions are Safe?