V9 Update 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
I
ITIM_ERR
Symbols & Numeric
127
128
160
530
745
808
809
827
A
Access a FairCom DB Connection Created by Another Thread
Additional c-treeDB and c-treeDB .NET Features and Improvements
Additional FairCom DB SQL Interfaces
Additional FairCom DB SQL Table Import Utility Options
Additional ORDER BY Clause Usage
Additional Scalar Functions Available
Additional Search Options for FairCom DB SQL LONG Field Types
Additional Security Administrator Functions
Additional SETOPS Modes
Additional SNAPSHOT Options
Addressing the issue
Administrators Can Now Define the FairCom DB Port Number
Advanced Cache Alternative for Scanning Data Files
Advanced Commit Delay Options
Advanced Encryption for FairCom DB SQL Tables
Advanced Functions for the FairCom DB SDK
Advanced Functions for the FairCom DB SDK
Advanced Functions for the FairCom DB SDK
Advanced Searching with CONTAINS Clause and LVARCHAR Fields
AIX
ARQS_ERR
ARSP_ERR
Assignment of Default File Permissions to User Groups
Attach and Detach Existing Sessions
Attach and Detach Existing Sessions to c-treeDB
Attach and Detach Open Tables to c-treeDB
Attach and Detach Tables
Automatic Shared Memory Protocol for Local Connections on Windows
Automatic Transaction Processing for non-TRANPROC files
B
backups
Backward Compatibility Changes with c-treeSQL Databases
batches
Batches for c-treeDB
Batches for c-treeDB
Batches for c-treeDB
Block Access to Files
block files
Blocking Lock Timeout
Blocking Lock Timeouts
C
Cache
Advanced Cache Alternative for Scanning Data Files
Prime Cache By Key
Callback Support in c-treeDB
callbacks
Callback Support in c-treeDB
FairCom DB Server SDK File Callback Options
Rebuild Callback Support in Client/Server Mode
Row-Level Permanent Callback Filters
Change Configuration Options at Run Time
commit delay
Commit Read Locks
Commit Read Locks for Guaranteed Data Reads
Commit Read Locks for Guaranteed Data Reads
New Commit Read Lock Support Requires Record Locks for Update
compact
Compact Function Now Supports Duplicate Key Purge and Update IFIL Options
compatibility issues
Backward Compatibility Changes with c-treeSQL Databases
Easier Navigation in FairCom DB
Ensure Matching Client and Server Versions for 100% Comptibility
HUGE Files are now Default with FairCom DB SQL
LOG_WRITETHRU support for Unix
New Unix Default File Permissions Mode
Record Based c-treeDB Filters
Transaction Log Format
Compatibility Notes
Complete RIGHT OUTER JOIN Syntax
Configuration Keywords
AUTO_PREIMG
AUTO_TRNLOG
BLOCKING_LOCK_TIMEOUT_SEC
COMM_PROTOCOL DISABLE
COMMIT_DELAY_BASE
COMMIT_DELAY_SCALE
COMPATIBILITY COMMIT_READ_LOCK
COMPATIBILITY LOG_WRITETHRU
COMPATIBILITY REVERT_TO_V6HDR
COMPATIBILITY SYNC_LOG
CPU_AFFINITY
DIAGNOSTICS SNAPSHOT_IOTIME
DIAGNOSTICS SNAPSHOT_WRKTIME
FILE_CREATE_MODE
FILE_PERMISSIONS
LOG_WRITETHRU
PAGE_SIZE
Additional Scalar Functions Available
Increased Page Size Now Available
PRIME_CACHE_BY_KEY
SERVER_NAME
SERVER_PORT
SNAPSHOT_LOCKWAIT_USEC
SNAPSHOT_TRANTIME_USEC
SQL_OPTION
TMPNAME_PATH
TRAN_TIMEOUT
Copy a Database with the FairCom DB SQL Maintenance Utility
Copyright Notice
CPU_AFFINITY
ctFILBLK
ctoption
ctQUIET
Block Access to Files
Temporarily Suspend FairCom DB Operations
c-tree Information Utility Enhancements
c-treeACE API
CompactIFile
ctFILBLK
ctFileCloseCallback
ctFileCreateCallback
ctFileOpenCallback
ctFILMTX
ctfiltercb_rowl
ctFILWCD
ctLOKDMP
ctLOKTIMOUT
ctQUIET
ctSetOWNER
ctSNAPSHOT
ctSQLImportTable
ctUpdateICUversion
ctUPDICU
CurrentISAMKey
ESTKEY
FindFileByName
GetCtFileInfo
GETFIL
LKISAM
LockList
LOKREC
NbrOfKeyEntries
NXTREC
NXTVREC
PUTHDR
RebuildIFile
ReWritePartialRecord
SA_ERRMSG
SA_WILDCARD
SetCallbackOnRebuild
SetDataFilter
SETOPS
SetSystemConfigurationOption
TRANBEG
TRANEND
c-treeDB
ctdbEstimateSpan
ctdbNumberOfKeyEntries
Record Based c-treeDB Filters
Row-Level Permanent Callback Filters
c-treeDB Functions to Start and Stop the c-tree Server Engine
c-treeDB Transaction Begin Modes
c-treeSQL and c-treeDB BINARY and VARBINARY Compatibility Issues
D
DEFAULT Clause with ALTER TABLE
Default Extended Headers for Enhanced Feature Support
Default HUGE Files for Tables
Default Index for Physical Data File Traversal
Default Temporary File Path in Standalone and LOCLIB Models
default values
Default Values for Alter Table Operations
Delphi .NET Compatibility when using Create()
Determine if c-treeDB Records Sets are Active
diagnostics
Disable Communications
Disable the FairCom DB Communication SubSystem
Documentation Overview
Dynamic Dump
E
Easier Navigation in FairCom DB
encryption
Enforce Maximum Disk Read/Write Sizes on Windows
Enhanced Dynamic Dump
Enhanced FairCom DB Statistics Utility Features
Enhanced Security Administrator Usage and Options
Ensure Matching Client and Server Versions for 100% Comptibility
Errors
ITIM_ERR
ARQS_ERR
ARSP_ERR
LMTC_ERR
R6BT_ERR
SETENV
TRQS_ERR
TRSP_ERR
UTIM_OUT
Exclusive Sessions and Databases
Exclusive Sessions and Databases in c-treeDB
Extended Connection Information in a Lock Dump
Extended Version of Compact Function Added
Extensive Interface Support
F
FairCom DB Configuration Manager
FairCom DB Configuration Manager
FairCom DB Tools
FairCom DB CPU Configuration Options
FairCom DB Direct SQL
FairCom DB Gauges
FairCom DB Gauges
FairCom DB Tools
FairCom DB ISAM Explorer
FairCom DB ISAM Explorer
FairCom DB Tools
FairCom DB Load Test
FairCom DB Load Test
FairCom DB Tools
FairCom DB Monitor
FairCom DB Monitor
FairCom DB Tools
FairCom DB Performance Monitor
FairCom DB Performance Monitor
FairCom DB Tools
FairCom DB Security Administrator
FairCom DB Security Administrator
FairCom DB Tools
FairCom DB Server SDK File Callback Options
FairCom DB SQL ADO .NET Data Provider
FairCom DB SQL dbExpress
FairCom DB SQL Enhancements
FairCom DB SQL Enhancements
FairCom DB SQL Enhancements
FairCom DB SQL Explorer
FairCom DB SQL Explorer
FairCom DB Tools
FairCom DB SQL PHP
FairCom DB SQL Query Builder
FairCom DB SQL Query Builder
FairCom DB Tools
FairCom DB Stack Dumps for Windows and UNIX
FairCom DB Status Log Analyzer
FairCom DB Status Log Analyzer
FairCom DB Tools
FairCom DB Tools
FairCom DB Tools
FairCom DB Tools
FairCom Security Handshake Now Available in all FairCom DB SQL Products
FairCom Typographical Conventions
file ID
file mutex
File Permission Mode for Files Created by c-tree on Unix Systems
file permissions
Assignment of Default File Permissions to User Groups
Enhanced Security Administrator Usage and Options
File Permission Mode for Files Created by c-tree on Unix Systems
New Unix Default File Permissions Mode
File-based Global Mutexes
filenames
filters
Record Based c-treeDB Filters
Row-Level Permanent Callback Filters
Filters are Now Record Based, Rather Than Table Based
G
Get and Set c-treeDB Table Owner Information
Get Table Status information From c-treeDB
H
handshake
Highlights of FairCom DB V9.0
histogram
HUGE files
c-tree Information Utility Enhancements
Default HUGE Files for Tables
HUGE Files are now Default with FairCom DB SQL
HUGE Files are now Default with FairCom DB SQL
Identifying Duplicate Key Index Errors
import tables
Additional FairCom DB SQL Table Import Utility Options
Programmatically Import Tables into FairCom DB SQL
Improved c-treeDB .NET
Improved FairCom DB SQL Java Configuration
Improved Query Optimizer Performance
Increased Page Size Now Available
J
java
JDBC
joins
K
Key Counting Functions
L
List Users Owning or Waiting for Record Locks
LMTC_ERR
Locks
Additional SETOPS Modes
Blocking Lock Timeouts
Commit Read Locks for Guaranteed Data Reads
List Users Owning or Waiting for Record Locks
Recursive Locking Support
LOG_WRITETHRU support for Unix
LONGVARBINARY
Additional Search Options for FairCom DB SQL LONG Field Types
Maximum Field Lengths for Non LONGVAR Fields Raised to 8K
LONGVARCHAR
Additional Search Options for FairCom DB SQL LONG Field Types
Maximum Field Lengths for Non LONGVAR Fields Raised to 8K
LVARCHAR
Additional Search Options for FairCom DB SQL LONG Field Types
Advanced Searching with CONTAINS Clause and LVARCHAR Fields
M
Many Additional c-treeDB Features
Many New Method Additions
Maximum Field Lengths for Non LONGVAR Fields Raised to 8K
microsoft excel
More c-treeVCL Functionality
More Options with FairCom DB Utilities
Move Segments in an Index Definition
Move Segments in an Index Definition with c-treeDB
mtmake
mtPro Build Utility
mutexes
N
New Commit Read Lock Support Requires Record Locks for Update
New c-treeVCL Features
New Delphi .NET Support
New Features for FairCom DB ISAM Server
New Features for FairCom DB ISAM Server
New Features for FairCom DB ISAM Server
New Mode for Table Rebuilds with Missing Index Files
New Mode for Table Rebuilds with Missing Index Files
New Mode for Table Rebuilds with Missing Index Files
New Unix Default File Permissions Mode
NULL Handling in Filter Expressions
O
ODBC
ODBC and JDBC Driver Socket SEND/RECV Timeout
ODBC Driver Login Timeout
Reserved Keywords With Microsoft Excel and ODBC
ODBC and JDBC Driver Socket SEND/RECV Timeout
ODBC Driver Login Timeout
operating systems
Options to Retrieve a File's Unique ID
Other New Functions Available
P
Partial Record Rewrites
performance
Improved Query Optimizer Performance
PREIMAGE Tables in FairCom DB SQL
preimage
Automatic Transaction Processing for non-TRANPROC files
PREIMAGE Tables in FairCom DB SQL
PREIMAGE Tables in FairCom DB SQL
Prime Cache By Key
Programmatically Import Tables into FairCom DB SQL
Q
queries
Additional ORDER BY Clause Usage
Blocking Lock Timeouts
ODBC and JDBC Driver Socket SEND/RECV Timeout
ODBC Driver Login Timeout
Query Timeout Options
TCP/IP Client Connect and Communication Timeout Options
Query Timeout Options
Quickly TRUNCATE Tables
quiese
Temporarily Suspend FairCom DB Operations
Transaction Log Format
R
Rebuild Callback Support in Client/Server Mode
Rebuild Tables with c-treeDB
rebuilds
Compact Function Now Supports Duplicate Key Purge and Update IFIL Options
Rebuild Callback Support in Client/Server Mode
Record Based c-treeDB Filters
Recursive Locking Support
recursive locks
Reserved Keywords With Microsoft Excel and ODBC
resources
New c-treeVCL Features
Resources for c-treeDB
Resources for c-treeDB
Retain Locks After Commit
Retrieve a Field that Partially Matches a Key Segment
Retrieve a List of File names from FairCom DB
Retrieve c-tree Configuration with c-treeDB
Retrieve c-treeDB Field and Segment Change Status
Retrieve Field, Index, and Segment Status
Retrieve the FairCom DB Configuration
Retry Options
ReWritePartialRecord
rewriting records
Row Level Permanent Filters
Row-Level Permanent Callback Filters
S
Scaling Factors for Configuration Keyword Values
security
FairCom Security Handshake Now Available in all FairCom DB SQL Products
Row-Level Permanent Callback Filters
security administrator
Additional Security Administrator Functions
Enhanced Security Administrator Usage and Options
server SDK
Set Integer Values with c-treeDB CTMoney Class
Set Operations State in c-treeDB
shared memory
SNAPSHOT
Additional SNAPSHOT Options
Enhanced FairCom DB Statistics Utility Features
SNAPSHOT Histogram Support
SNAPSHOT Histogram Support
Solaris
SQL keywords
Additional Search Options for FairCom DB SQL LONG Field Types
ALTER TABLE
CONTAINS
CREATE TABLE
DEFAULT
FOR UPDATE
LIKE
Maximum Field Lengths for Non LONGVAR Fields Raised to 8K
ORDER BY
Reserved Keywords With Microsoft Excel and ODBC
RIGHT OUTER JOIN
STORAGE_ATTRIBUTES
Default HUGE Files for Tables
PREIMAGE Tables in FairCom DB SQL
TRUNCATE TABLE
Updated FairCom DB SQL Reserved Words
SQL_ATTR_CONNECTION_TIMEOUT
SQL_ATTR_LOGIN_TIMEOUT
SQLSetConnectAttr
stack trace
stored procedures
Stored Procedures, Triggers, and User Defined Functions Now Standard Features
Support for Resources
Support for SQL Transaction Isolation Levels 1 and 2
T
TCP/IP
Administrators Can Now Define the FairCom DB Port Number
Automatic Shared Memory Protocol for Local Connections on Windows
TCP/IP Client Connect and Communication Timeout Options
TCP/IP Client Connect and Communication Timeout Options
Temporarily Suspend FairCom DB Operations
The Most Up to Date Information
threads
timeouts
Blocking Lock Timeouts
ODBC and JDBC Driver Socket SEND/RECV Timeout
ODBC Driver Login Timeout
Query Timeout Options
TCP/IP Client Connect and Communication Timeout Options
tools
FairCom DB Gauges
FairCom DB ISAM Explorer
FairCom DB Load Test
FairCom DB Monitor
FairCom DB Performance Monitor
FairCom DB Security Administrator
FairCom DB SQL Explorer
FairCom DB SQL Query Builder
FairCom DB Status Log Analyzer
transaction isolation levels
Transaction Log Format
transaction logs
Transaction Processing
Advanced Commit Delay Options
Automatic Transaction Processing for non-TRANPROC files
Support for SQL Transaction Isolation Levels 1 and 2
Transaction Log Format
Transaction Timeout
Transaction Timeout
triggers
TRQS_ERR
TRSP_ERR
U
UNICODE
Unicode Support for c-treeDB
Update Unicode Version
Unicode Support for c-treeDB
unix
File Permission Mode for Files Created by c-tree on Unix Systems
LOG_WRITETHRU support for Unix
New Unix Default File Permissions Mode
Update Unicode Version
Updated FairCom DB SQL Reserved Words
user defined functions
utilities
ctadmn
Temporarily Suspend FairCom DB Operations
Transaction Log Format
ctinfo
ctsqlcdb
ctsqlimp
ctstat
Additional SNAPSHOT Options
Enhanced FairCom DB Statistics Utility Features
ctstop
sa_admin
Additional Security Administrator Functions
Enhanced Security Administrator Usage and Options
UTIM_OUT
V
VCL
New c-treeVCL Features
Resources for c-treeDB
W
windows
X
XCREblk