FairCom ISAM for C

 
FairCom ISAM API for C - Developers Guide
Prerequisites - C Language Concepts
JSON Data Type Support
Using JSON Data Types in Your ISAM Applications
ISAM Quick Tour
Plug-Ins and Callbacks Extend the FairCom Database Engine
Plug-ins
Configuring the Application Server
c-tree Server Can Load Plug-In On-Demand after Server Has Started
Operational Models
Standard Client/Server Model
Standalone Single-User Model
Standalone Multi-User Model
LOCLIB Model
Multi-Threaded Standalone Model
CTUSER Server Model
Bound Server Model
Custom Server Model
Operational Model Considerations
Migrating Data Between Platforms and Operational Models
Single-User Standalone
Multi-User Standalone
Client/Server
File Migration
Migrating Your Application Between Operational Models
Single-User to Multi-User Standalone or Client/Server
Multi-user Standalone to Client/Server
Adding Transaction Processing
Single-Threaded to Multi-Threaded
Lock Protocol Modification Prevents Spurious FPUTFGET Corruption Errors
Data Management
Data Record Positions
Data and Index Definitions
Data and Index File Numbering
File Modes
filmod Values
File Mode Relationships
Virtual File Open
Fixed versus Variable-length Records
Multi-User File Mode
I/O Management
More About File Modes
Extended File Creation Block Structure
Extended File Modes (x8mode)
Special Cache Value Parameter (splval)
Extended File Properties
Extended Feature Support
Xtd8 File Creation Functions
Huge File Support
Huge File Creation Example
Record Offsets Under Huge File Support
Segmented File Support
Automatic Segments
SEGMDEF Structure
SetFileSegments Function
File Segment Example
Partitioned File Support
Data File Extension
c-tree Keys
ISAM Keys
Duplicate Keys
Sequence Numbers
Alternative Key Types
Fixed Length Keys
Leading Character Compression Keys
Padding Compression Keys
Combined Compression Keys
KTYP_NOISMKEYUPD mode prevents ISAM record update from changing index key value
Variable-Length Key Compression
Deferred Indexing
Queuing an Index Load
Counting the Number of Deferred Operations
Selected Deferred Index features extended to non-deferred indexes
Up to 4X Faster Indexes with Smaller Indexes Using Variable-Length Compressed Key Storage
c-treeDB API Compression
ISAM API Compression
Utilities to Confirm Index Compression Modes
Option to Automatically Enable c-tree Key Compression When Creating an Index
Key Segment Modes
Key Value Assembly
TransformKey
CurrentISAMKey
Sequence Number Segments
Descending Key Segment Values
Alternative Collating Sequence
END of Key Segment
RECBYT Segment Mode
File Recovery
Advanced Space Reclamation
Online Compact
Transaction Processing Overview
Default Temporary File Path in Standalone and LOCLIB Models
Error Handling
ISAM and Low-Level Functions
c-tree Constraints
File-Related Limits
File ID Overflow
Serial Number Segments
Transaction High-Water Marks
Transaction Log Numbering
File Size and Operating System Limits
Record Size
Enforce Maximum Disk Read/Write Sizes on Windows
ISAM Database Technology
ISAM Concepts
ISAM File Relationships
Incremental ISAM Structures
IFIL Structure
IIDX Structure
ISEG Structure
Incremental ISAM Example
Improved IFIL Path Handling
Configuration Option to Disable IFIL Path Improvements
Programming Option to Disable IFIL Path Improvements
Incremental ISAM and Resources
Current ISAM Record
ISAM Error Handling
Better Error Reporting when Exceeding the Maximum Length of VARCHAR Fields
ISAM Function Overview
Incremental ISAM System Functions
ISAM Parameter File System Functions
Data File and Index Functions
Set Functions
ISAM Examples
A Simple Application
Beginning Your Application
Initialize c-tree and open files
Add a record
Find a record
Delete a record
Close the system
Record Schemas and DODA Resources
Field Types
Create the Record Schema with PutDODA
Key Segments
Record Schema Internals
Data and Index Files
Variable-Length Records
Resources
Resources and Files
Resource Identification
Disabling Resources
Resource Functions
Resource Example
FairCom Defined Resources
Resource Locks
Superfiles
Superfile Members/Host
Restrictions/Considerations
Batched Operations
Batch Parameters
First Call
Verify Option
Result Option
Lock Option
Completion Option
Automatic Batch Close Mode
Continuation Calls
Complete or Cancel Call
Batch Read Operations
Batch Insert Operations
Batch Update Operations
BAT_UPD and BAT_UPD_KEY
Batch Update Operations: BAT_UPD and BAT_UPD_KEY
Heterogeneous Support for BAT_INS and BAT_UPD
Record Locking - BAT_LOK_BLK, BAT_LOK_KEEP and BAT_LOK_ONE
Performance Enhancement
Example Use of DoBatchXtd()
Index Ranges
Using Index Ranges from the c-tree ISAM API
Allocating an Index Range
Reading Records Using an Index Range
Freeing an Index Range
Index Range Support for Virtual Segment Groups
Blocking Record Reads
Data Filters
Conditional Indexes
FairCom DB Expression Parser and Grammar
Constants
Variables
Parentheses
Examples
Exact string matches
Exact string match
Exact string non-match
Less-than string match
Less-than-equal string match
Greater-than string match
Greater-than-equal string match
Case insensitive matches
Case insensitive string match
Case insensitive string non-match
Case insensitive less-than string match
Case insensitive less-than-equal string match
Case insensitive greater-than string match
Case insensitive greater-than-equal string match
Partial matches
Partial string match
Partial string non-match
Partial less-than string match
Partial less-than-equal string match
Partial greater-than string match
Partial greater-than-equal string match
Case insensitive partial matches
Case insensitive partial string match
Case insensitive partial string non-match
Case insensitive partial less-than string match
Case insensitive partial less-than-equal string match
Case insensitive partial greater-than string match
Case insensitive partial greater-than-equal string match
Contains Matches
Contains string
Does not contain string
Contains string after the Nth character
Contains beginning-string
Does not contain beginning-string
Contains end-string
Does not contain end-string
Contains mid-string
Does not contains mid-string
Wildcard Matches
Wildcard string match
Wildcard string non-match
Wildcard end-string match
Wildcard end-string non-match
Wildcard mid-string match
Wildcard mid-string non-match
Case insensitive wildcard Matches
Case insensitive wildcard string match
Case insensitive wildcard string non-match
Case insensitive wildcard end-string match
Case insensitive wildcard end-string non-match
Case insensitive wildcard mid-string match
Case insensitive wildcard mid-string non-match
Compare string fields in the same record
Predefined Functions
C Language Equivalents
String and Text Functions
Date and Time Functions
Mathematical Functions
Type Casting
Automatic Type Promotion
Operators
Custom Application Expressions
Parsing Expressions
Evaluating Expressions
Variable-length Records with Conditional Expressions
Conditional Expression Callback Function
Multiple ISAM Contexts (Positions)
Rebuild/Compact Utility Callback Feature
Portable Data Through UNIFRMAT Support
Modes
Automatic Mode
Manual Mode
UNIFRMAT Server
Limitations
Data Alignment
Multiple Instance Support
Automatic Windows 3.1 Instance Support
Pre-Function Capability
Millions of Open Files
Performance Optimization
PAGE_SIZE (sect) optimization
Index cache size
Data cache size
Rebuild and Compact Optimization
NO_IDXENT
Disable Key Buffer Support for Faster ISAM Access
Disable key buffer support
Enable key buffer support
Considerations
Process All Files Forward and Backward
Enhanced Precision for International Languages
Client/Server Support
Standalone Support
c-treeDB Multi-Record "Virtual" Tables
Helpful Internal Functions
Multi-Threaded API
Introduction to Threads
Some Thread Fundamentals
Thread API Summary
ctThrd Function Overview
Thread Management Functions
Thread Communication
Thread Synchronization
Thread API Details
Examples
ctmtap.c and wtmtap.c - Multi-threaded testing programs
ctmtex.c - Multi-threaded testing program
Transaction Processing
Transaction Processing Concepts
Why Do We Need Transaction Processing?
Atomicity
Journaling
Automatic Recovery
Transaction Grouping
Basic Transaction Processing
Transaction File Modes
Create Files
Begin Transactions - Begin()
End Transaction - Commit()
Record Locking
Aborting a Transaction
Savepoints
Errors in Transactions
File Operations During Transactions
Closing Files During Transaction Processing
Optional Defer of Close Until Transaction Commit/Abort
Defer File Delete
Transaction Dependent Creates and Deletes
Transaction Processing Logs
Automatic Log Adjustments
Automatic Log Size Adjustment
Automatic Increase of Active Transaction Logs
SystemConfiguration Log Space Reporting
SystemConfiguration Log Reporting Enhancements
Flush Directory Metadata to Disk for Transaction-Dependent File Creates, Deletes and Renames
Automatic Recovery
Transaction High-Water Marks
Transaction Processing On/Off
Two-Phase Transactions
User Defined Transaction Log Entries
Immediate Independent Commit Transaction (IICT)
Single-User Transaction Processing
Single User Transaction Processing Control
Clear Transaction Logs
Log Paths
Additional Single-User Transaction capabilities
Single-user Transaction processing hard coded file zero conflict
Transaction History
TransactionHistory Basic Operation
TransactionHistory Output
TransactionHistory Advanced Operation
Optional Record Header
Multiple History Sets
Delayed Durability Transaction Processing
Detailed Description of Behavior
Original Transaction Log Flush/Sync Behavior
Modified Log Sync Strategy
Delayed Durability Behavior
Performance Gains
SNAPSHOT
Monitoring Delayed Durability Data Cache Writes
Guarantee Transaction Log Sync by Time Interval
Automatic Recovery Considerations
Time limit on flushing updated data and index cache pages for TRNLOG files
Restore Points
Restore Point Overview
Creating Restore Points
Automatic restore point logging
Restore Point Files
Rolling Back to a Restore Point
Rollback to New Restore Points with ctrdmp
Restore Points as an Incremental Roll Forward Strategy
SYSLOG Logging of Restore Point
Temporary Event File
Using ctalog SYSLOG Utility to Read Restore Point Data
Configuration Entries for Restore Points
Improved Auto Restore Point performance with checkpoints
Mirroring
Recovery Capabilities
Miscellaneous Points
MIRROR_DIRECTORY Server Keyword
Error Returns
Limitation
Multi-User Concepts
Multi-User Updates
Multi-User Interference
Multi-User File Mode
Record Locking
Optimistic Locking
Checklock
ISAM Level Data Record Locks
Using LockCtData with LockISAM
LockISAM and Resources
Recursive Locking Support
ctThrdSharedCritical API for Scalable Read Locks
Diagnosing Lock Issues
Low-Level Data Record Locks
FairCom Server enhanced locking control for files opened multiple times in the same connection
Table Lock Support
Table Lock Mode for LOKREC
Standalone Multi-User
Node Locks
Data Record Lock Implementations
Extended Lock Strategy
Complications with Superfiles in Standalone Multi-user Models
Complications with ctLOCK_TOP
Dummy Lock File
Exclusive File Opens
EXCLUSIVE File Caching
Multi-User Non-Server Mode Rebuild
Sample Programs
Simple Applications
Simple File Maintenance
Initialize the system
Error Handling
Adding Data
Delete a key
Close the system
Same Application with ISAM Functions
ISAM Parameter File
Error Handling
Adding Data
Delete Record
Close the System
Using Incremental ISAM Structures
Incremental ISAM structure
Initialize the system
File Searches and Sets
Listing a file
Sets
Scanning, Updating, Deleting
Start the scan
Scanning the file
Update the record
Delete a record
Windows-Specific Samples
wtixmg - A Windows version of the ctixmg sample
wtlxmg - A Windows version of the ctlxmg sample
wtmtap - Windows Multi-threaded Sample Application
Sample Programs
ctcnfg - System Configuration Example
ctcompare - Database Comparison Tool
ctixmg - Incremental ISAM / Resource sample
ctlxmg - LOCLIB sample program
ctmtap - Multi-threaded API sample and performance tester
ctmtex - Multi-threaded Incremental ISAM / Resource sample
ctstap - Single-Threaded Version of Multi-Threaded Test
ctstress - Perform Record Operations on Files
ctsxmg - Incremental ISAM / Record Schema example
cttpca - TPC A Test
ct_tpc - TPC A Test
lowlevel, isam, isam1, isam2, isam3
ioperf
selomt
trnhis
CGI
Java
FairCom DB Utility Programs
ctclntrn Utility - Clean Transaction Mark
ctclosefile - Close Files on KEEPOPEN List
ctcmpcif - IFIL-based Compact Utility
-oldsec - Updates in handling of security attributes
Preventing Possible Data Loss with Compact & Rebuild Operations
ctcv43 - Convert V4.3 Data File to FairCom DB Format
ctcv67 - Extended File Conversion Utility
ctdidx - Create flat key file
ctdmpidx - Index Dump Utility
ctexmc - File creation utility / example
ctfchk - File Checksum Utility
ctfilblkif - File Block Utility
ctflush - File Flush Utility
ctfileid - Update File IDs
ctflat - Create FairCom DB file from a flat file
ctflvrfy - Index Verify Utility
cthghtrn - Displays the high-water mark for transactions
ctidmp - Examine Dump Files
ctindx - Create index file from flat key file
ctinfo - ISAM File Info
ctinfo Sample Output
ctmtlk - Lock operation test utility
ctmove - Moving Files without Stopping the FairCom Server
ctotoi - Add IFIL and DODA Resources
ctpartadmin - Partitioned File Administration Utility
ctpathmigr - Change Internal Path Separators
ctquiet - Quiesce FairCom DB Utility
ctrbldif - IFIL-based Rebuild Utility
Option to set index's automatic segment attributes
-oldsec - Updates in handling of security attributes
ctredirect - IFIL Update Utility for Redirected Filenames
ctsbld - Superfile rebuild pre-pass
ctsbldm - Rebuild Superfile Index Members
ctscmp - Superfile Compact Utility
ctsfex - Superfile Data Export Utility
ctsfil - Superfile contents
ctstat - Statistics Utility
Admin-System Report -vas
Tivoli-System Report -vts
Admin-File Report -vaf
Tivoli-File Report -vtf
Admin-User Report -vau
Function Timing Report -func
Text Report -text
I/O Time Statistics -iotime
I/O Statistics per File -file
Connection Information -userinfo and -userinfox
ISAM Statistics -isam
Enable Function Call Times by File -wrktime
Function Call Times by File -funcfile
Memory File Usage -m
Transaction Statistics -vat
File and User Lock -filelocks
List files on Internal Server Lists
Memory Use and Allocation Call Stacks -ml -mt
Memory Allocation (Windows) -mf -ma -mr -ms
cttctx Performance Test Utility
cttctx locking options for record read
cttrap - Communications Trap Playback utility
cttrnmod - Change Transaction Mode Utility
cttpca - TPC A Test
ct_tpc - TPC A Test
ctunf1 - File Reformatting Utility
ctunf2 - UNIFRMAT file reformatting utility
ctupdpad - Update the c-treeDB Pad Resource Utility
ctvlqa - Variable-length quality assurance utility
ctvfyidx - Index Verify Utility
ctvfyfil - File Verify Utility
dfkctl - Deferred Index Maintenance Utility
FairCom DB Database Engine
Client/Server Advantages
Server-Application Relationship
FairCom Client/Server Communication
Logging On and Off the Server
Calculating Memory Usage
Controlling Server Memory
Calculating File Storage Space
Copying Server-Controlled Files
Copy Files Between FairCom DB Servers
Multiple Server Support per Client
Local Library Support
Server Utilities
ctadmn - Server Administrator Utility
Server Administration API
ctstop - Server Stop Utility
sa_admin - Command-line security administration utility
Administrator Options
User Options
Group Options
File Options
ctdump - Schedule Backup Utility
ctrdmp - Backup Restore or System Rollback
Rollback to New Restore Points with ctrdmp
ctfdmp - Forward Roll Utility
ctldmp - Transaction Log Dump
ctldmp option to create transaction start files from checkpoints in transaction log files
Performance
I/O caching
SetOperationState
Batch Operations
ISAM Functions
ctDUPCHANEL File Mode
Fastest Server
Communication Protocol
Optimizing Transaction Processing - ADVANCED
Transaction Control Background
Transaction Options
Transaction Log Flush Delay
Resource Records Detected
FairCom Server Cache Subsystem
Allocating Memory for Data/Index Caches
Cached Data - Writing to Disk
Advanced Cache Settings
Priming Cache
Scanner Cache
Disabling File Cache
Limiting Special Cache Space
Avoiding File Flush at Server Shutdown
Multi-Page Cache
Buffer Run Length
Other Notes
SystemConfiguration Cache/Buffer Statistics
File Modes
Record Locking Mode
I/O Management
Deployment Options
Tamper-Proof Server Configuration File
Encryption of FAIRCOM.FCS
Disk Full Detection
File-by-file Disk Full Checks
Volume Disk Full Checks
DISK_FULL_ACTION (SUBSYSTEM)
Multi-CPU Performance
Server System Event Log
Retrieving System Event Log Entries
Adding System Event Log Entries
System Event Log evclass and event Codes
Create a List of Arbitrary Names in Server Configuration File
Application Name List Usage
Application Name List Restrictions
Application Name List Example
Server Internals
FairCom Server Threads
FairCom DB Trapped Unix Signals
Client/Server ctntio Communications Errors (Formerly VDP Errors)
Diagnostic Tools
cttrap - Communications Trap Playback utility
DIAGNOSTICS LOWL_FILE_IO Keyword
Diagnostic Dump of Server File-lock Table
DIAGNOSTICS USER_FUNCTIONS keyword added
Dynamic CRC Check support for SPX and TCP/IP
Client-Side Operation
Introduction
Data Compatibility
Client-Side Specifics
Max Files (Parameter Files Only)
Modifying ctoptn.h
Moving Data Files
Server/Host Naming Convention
Unix Communications Notes
Client TCP/IP Connect and Communication Timeout Options
IPv6 Support
Server Name Broadcast Feature
Performance Monitoring
Performance Monitoring Overview
Performance Monitoring Using the ctstat Utility
Performance Monitoring Using Server Keywords
Automatically Logging Performance Snapshots
Automatic Logging to the Server System Event Log
Automatic Logging to SNAPSHOT.FCS
Performance Monitoring Using the SnapShot API
SnapShot API Function Usage
Automatic Snapshot Support
Function Timing Support
System Snapshot Support
User Snapshot Support
File Snapshot Support
Transaction Statistics Support
Replication State Snapshot Support
Combined Snapshot Support
Snapshot Contents
System Snapshot Structure
User Snapshot Structure
File Snapshot Structure
SQL Snapshot Structure
Function Timing
Transaction Statistics
Replication State Statistics
Hot Alter Table
Support for dynamically altering a table's schema on-the-fly
Adding Hot Alter Table support to existing files
Rebuilding data files with Hot Alter Table support
Memory Files
HUGE File Support
Creating Memory Files Using Server Configuration Keyword
Creating Memory Files Programmatically
Sharing Memory Files Created Programmatically
Collecting Memory File Statistics
Memory File Limitations
Tip: Faster Server Shutdown with Memory Files
Server-Side Queues
Creating or Opening a Server-Side Queue
Writing to a Server-Side Queue
Reading from a Server-Side Queue
Retrieving the Size of the Next Message in a Server-Side Queue
Retrieving the Number of Messages in a Server-Side Queue
Closing a Server-Side Queue
File Notification
Synchronous File Notification
Asynchronous Record Update Notifications
Update Callback Specifications
Option to specify external library name in platform-independent format
Using File Notification
Enabling Notification for Actions on a File
Receiving Notifications for Actions on a File
Notification Queue Message Format
Fixed Portion of Notification Queue Message
Optional Key Values
Optional Actor Node Name
Optional Full Record Image
Reading Notification Messages
Disabling Notification for Actions on a File
Notification Callbacks
Partitioned Files
Overview
Implementation
Partition Naming
Maximum Partition Number vs File Size
Rules
User-Defined Partitioned File Conditional Expressions
User-Defined Conditional Expressions for Easy Partitioned File Creation
Conditional Expressions and Partition Rules
Partitioned Files in FairCom DB SQL
c-treeDB Partition File API Support
FairCom DB ISAM Usage
Operation
Raw Partition Numbers
Unique Keys
Serial Segments (SRLSEG)
Transaction Processing
Set maximum active partitions for auto-purge feature
Encryption
Partitioned File Security - File password support
Partition Administration Function
Managing Partitions
File Security and Encryption
Accessing File Security
Forms of System Security
Users, Groups, and Passwords
File Permissions
File Passwords
User Profile
Automatic TransformKey
Save Current ISAM Record
Allow ADMIN Access When Max User Limit Hit
Logon Control Options
Automatically Enforce Password Strength
Logon Strike-Out Options
Suspend Server - Block User Logins
Suspend the Server
Server Keyword: STARTUP_BLOCK_LOGONS
Advanced File Encryption
File-Specific Encryption Control
Using Advanced Encryption
Advanced Encryption Configuration
Master Password Verification Options
ctencrypt - Utility to Change Master Password
c-tree Client Implementation
Transport Layer Security Secures Data in Transit between Network FairCom DB Clients and Servers
Testing with Default FairCom DB Certificates
ADO.NET Support for TLS
ODBC Support for SSL
JDBC Support for TLS
Allow ISAM Client to Use SSL without Client Having Server Certificate
OpenSSL Headers for Linking FairCom DB Client Applications
OpenSSL Now Provides Default Faster AES Encryption
TLS/SSL Tutorials
AWS Security
Support for Using AWS Secrets Manager as External Encryption key Store
Support added for changing FairCom Server master encryption key in AWS Secrets Manager
DLL for FairCom Server to Access AWS Secrets Manager
Visual Prompt Utility for AWS Credentials
Ensure recoverability if server terminates while changing master encryption key
Encrypted Data Master Key Library
Data Camouflage
TCP/IP Camouflage (Deprecated)
Unicode
Unicode Concepts
Unicode default charset for SQL CHAR and VARCHAR changed from US-ASCII to ISO-8859-1
Preparation
Storing Unicode Data
Storing UTF-16 Data
Storing UTF-8 Data
Unicode Key Segments
Unicode Libraries Required for FairCom DB
How to Specify an ICU Unicode Key Segment
Extended Key Segment Definition
ICU Collation Option Overview
Extended Key Segment Definition Example
Extended Key Segment Default Hierarchy
Extended Key Segment API
GetXtdKeySegmentDef
PutXtdKeySegmentDef
TransformXtdSegment
API Example
Error Codes
Server Configuration Keywords for Unicode Segment Default
Unicode File Names
Mirrored File Names
Using the Low-Level API
Simple Application
Application Outline
The Application
Initialize FairCom DB
Add a record
Find a record
Delete a record
Close the system
Low Level API Example
Introductory Tutorial
Init
Create
Manage
Done
Additional Resources
Low-Level Function Overview
System Functions
File Manipulation Functions
Data Record Manipulation
Key Manipulation
Transaction Processing Functions
Resource Functions
Data Integrity Verification Function
Function Name Cross Reference
Four Byte File Numbering TypeDef Change
Full Names
Abbreviated (short) Names
Function API Listing
Initialization API
ctThrd API
Instance Control API
ISAM Initialization API
Low-Level Initialization API
Data Definition API
ISAM Data Definition API
Low-Level Data Definition API
Data Manipulation API
ISAM Data Manipulation API
Batch API
Context API
Sets API
Low-Level Data Manipulation API
Utility Functions
Data Integrity Verification
Server Administration API
Transaction Processing API
File Copy Functions
API Functions Sorted by Type - ISAM Functions
FairCom DB Function Descriptions
Abort
AbortXtd
AddAutoSysTimeFields
AddCtResource
addIDfield
IDfields - Extended support
AddKey
AddRecord
AddVRecord
AllocateBatch
AllocateRange
AllocateSet
AvailableFileNbr
Begin
BlockingISAMRead
BuildKey
ChangeBatch
ChangeHistory
ChangeISAMContext
ChangeSet
CleanIndexXtd
ClearSavePoint
ClearTranError
CloseConnection
CloseCtFile
CloseCtFileByName
CloseIFile
CloseISAM
CloseISAMContext
CloseRFile
cndxeval
cndxfree
cndxparse
cndxrun
Commit
CompactIFile
CompactIFileXtd
CompactIFileXtd8
cpybuf
CreateDataFile
CreateDataFileXtd
CreateDataFileXtd8
CreateIFile
CreateIFileXtd
CreateIFileXtd8
CreateIndexFile
CreateIndexFileXtd
CreateIndexFileXtd8
CreateIndexMember
CreateISAM
CreateISAMXtd
ctAlterSchema
ctCallback
ctCloseSequence
ctCopyFile
ctCreateSequence
ctDeferredIndexControl
ctDeleteSequence
ctfcpAddFileCopyOperation
ctfcpAllocateHandle
ctfcpCopyFile
ctfcpFreeHandle
ctfcpGetErrorBuffer
ctfcpRemoveFileCopyOperation
ctfcpSetCallback
ctfcpSetCopyFilenames
ctfcpSetCopyFilePassword
ctfcpSetCopyOptions
ctfcpSetErrorBuffer
ctfcpSetServerParameters
ctFILBLK
ctFILELIST
ctFILMTX
ctfiltercb_rowl
ctfiltercbAddFilter
ctfiltercbRemoveFilter
ctGetAccountExpirationTime
ctGetConnectionInfo
ctGetCurrentSequenceValue
ctGetFailOverState
ctGetFileLocks
ctGetFileUsers
ctGETHGH
ctGetIsamErrorCode
ctGetIsamFileNbr
ctGetNextSequenceValue
ctGetNullBit
ctGetNullKeyValue
ctGetOpenFiles
ctGetOpenFilesXtd
ctGetSequenceAttrs
ctGetSystemErrorCode
ctGetUserErrorCode
ctImpersonateTask
ctLOKDYN
ctLOKTIMOUT
ctMBprefix
ctNotify
ctOpenSequence
ctparsedoda
ctPlugin_describe
ctPlugin_init
ctPlugin_term
ctRecordUpdateCallbackControl
CtreeAsynchronous
CtreeCheckPoint
CtreeFlushFile
CtreeFlushFileXtd
ctResetFailOverState
ctSetClientLibraryOption
ctSetCommProtocolOption
ctSetCompress
User Defined Compression Dynamic Shared Library
ctSetConfigurationOptions
ctSetCurrentSequenceValue
ctSETHGH
ctSetLicenseFile
ctSetLicenseOptions
ctSetLocalDirectory
ctSetNullBit
ctSetNullKeyValue
ctSetOWNER
ctSetSequenceAttrs
ctSQLImportTable
CTSQLIMPOPTS structure prior to V11.2.3
ctStatusLogWrite
ctSysQueueClose
ctSysQueueCount
ctSysQueueLIFOWrite
ctSysQueueMlen
ctSysQueueOpen
ctSysQueueRead
ctSysQueueWrite
ctThrdAttach
ctThrdBlockCls
ctThrdBlockGet
ctThrdBlockInit
ctThrdBlockRel
ctThrdBlockWait
ctThrdCreate
ctThrdData
ctThrdDataSet
ctThrdDetach
ctThrdExit
ctThrdHandle
ctThrdInit
ctThrdLIFOWrite
ctThrdLIFOWriteDirect
ctThrdMutexCls
ctThrdMutexGet
ctThrdMutexInit
ctThrdMutexRel
ctThrdMutexTry
ctThrdQueueClose
ctThrdQueueCount
ctThrdQueueMlen
ctThrdQueueOnClose
ctThrdQueueOpen
ctThrdQueueRead
ctThrdQueueReadDirect
ctThrdQueueWrite
ctThrdQueueWriteDirect
ctThrdSemapCls
ctThrdSemapGet
ctThrdSemapInit
ctThrdSemapRel
ctThrdSemapTry
ctThrdSleep
ctThrdTerm
ctTransferFile
ctTruncateFile
ctu16TOu8
ctu8TOu16
ctUPDICU
ctVerifyFile
ctVERIFYidx
CurrentFileOffset
CurrentISAMKey
CurrentLowLevelKey
DeleteCtFile
DeleteCtResource
DeleteIFile
DeleteKey
DeleteKeyBlind
DeleteRecord
DeleteRFile
DeleteVRecord
delIDfield
DoBatch
Treat fixed-length compressed data files consistently across batch record returns, inserts, and updates
DoBatchXtd
DropIndex
dyndmp and dyndumpsetopt
EnableCtResource
EstimateKeySpan
EstimateRange
EvaluateFilter
FindFileByName
FirstInRange
FirstInSet
FirstInVRange
FirstInVSet
FirstKey
FirstRecord
FirstVRecord
FreeBatch
FreeBatchNbr
FreeHistory
FreeHistoryNbr
FreeRange
FreeSet
FreeSetNbr
GetAltSequence
getcndxmem
GetConditionalIndex
GetCtFileInfo
GetCtreePointer
GetCtResource
GetCtTempFileName
GetDODA
GetFileRegions
GetFilterVersion
GetGTEKey
GetGTERecord
GetGTEVRecord
GetGTKey
GetGTRecord
GetGTVRecord
getIDfield
GetIFile
GetKey
GetLTEKey
GetLTERecord
GetLTEVRecord
GetLTKey
GetLTRecord
GetLTVRecord
GetORDKey
GetRecord
GetSerialNbr
GetServerInfo
GetServerInfoXtd
GetSuperFileNames
GetSymbolicNames
GetVRecord
GetXtdCreateBlock
GetXtdKeySegmentDef
InitCTree
InitCTreeXtd
InitISAM
InitISAMXtd
IOPERFORMANCE
IOPERFORMANCEX
KeyAtPercentile
LastInRange
LastInSet
LastInVRange
LastInVSet
LastKey
LastRecord
LastVRecord
LoadFilter
LoadKey
LockCtData
LockDump
LockISAM
LockList
NbrOfKeyEntries
NbrOfKeysInRange
NbrOfRecords
NewData
NewVData
NextCtree
NextInRange
NextInSet
NextInVRange
NextInVSet
NextKey
NextRecord
NextVRecord
OpenCtFile
OpenCtFileXtd
OpenFileWithResource
OpenFileWithResourceXtd
OpenIFile
OpenIFileXtd
OpenISAM
OpenISAMContext
OpenISAMXtd
PartitionAdmin
Perform
PermIIndex
PermIIndex8
PositionSet
PositionVSet
PreviousInRange
PreviousInSet
PreviousInVRange
PreviousInVSet
PreviousKey
PreviousRecord
PreviousVRecord
putcndxmem
PutDODA
PutIFile
PutIFileXtd
PutIFileXtd8
PutXtdKeySegmentDef
QuietCtree
ReadData
ReadIsamData
ReadIsamVData
ReadVData
RebuildIFile
RebuildIFileXtd
RebuildIFileXtd8
RebuildIIndex
RegisterCtree
ReleaseData
ReleaseVData
RemoveAutoSysTimeFields
RenameFile
RenameIFile
RenameIFileXtd
ReplaceSavePoint
ReReadRecord
ReReadVRecord
resetIDfield
ResetRecord
RestoreSavePoint
ReWritePartialRecord
ReWriteRecord
ReWriteVRecord
SA_ERRMSG
SA_FILES
SA_GROUP
SA_LOGOF
SA_LOGON
SA_USERS
SA_WILDCARD
SECURITY (function)
Ability to Validate against Advanced Encryption Master Password
SetAlternateSequence
SetCallbackOnRebuild
GETCBRBLST
SetDataFilter
SetEncryption
ctSETENCRYPT - Passing a NULL to disable encryption
SetFileSegments
SETFLTRN
SETLOGPATH
SetNodeName
SetOperationState
SetRecord
SetSavePoint
SetSystemConfigurationOption
SetVariableBytes
SetXtdFileOpenMode
SnapShot
StopServer
StopServerXtd
StopUser
StopUserAsync
SuperfilePrepassXtd
SwitchCtree
SystemConfiguration
SystemLog
SystemMonitor
TempIIndexXtd
TempIIndexXtd8
TestFileNbr
TestHugeFile
TRANRDY
TransactionHistory
TransformKey
TransformSegment
TransformXtdSegment
UnloadFilter
UnRegisterCtree
UpdateAutoSysTimeFields
UpdateConditionalIndex
UpdateCtResource
UpdateFileMode
UpdateHeader
UpdateRecordOffsetForKey
USERINFOX
USERLIST
UserLogEntry
uTFRMKEY
VDataLength
VRecordLength
vtclose
wchIDfield
WhichAutoSysTimeFields
WhichCtree
WriteData
WriteVData
FairCom DB Error Codes
FairCom Typographical Conventions
Copyright Notice
Index