 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
 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
 FairCom DB API 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 and Rebuild
 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
 File Names up to 4K
 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
 Multiple ISAM Contexts (Positions)
 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
 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
 FairCom DB API 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
 Tutorial for diagnosing invalid file headers for the Standalone Multi-User library
 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
 ctdbdistinct - Key Count 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
 ctsmon - Server Heartbeat Monitor
 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
 Prime Cache at Server Startup
 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
 FairCom DB API 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
 FIPS Support
 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)
 File Recycle Bin
 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
 addChangeIDfield
 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
 ctAddSerialNumberField
 ctAlterSchema
 ctCallback
 ctCloseSequence
 ctCopyFile
 ctCreateSequence
 ctDeferredIndexControl
 ctDeleteSequence
 ctfcpAddFileCopyOperation
 ctfcpAllocateHandle
 ctfcpCopyFile
 ctfcpFreeHandle
 ctfcpGetErrorBuffer
 ctfcpRemoveFileCopyOperation
 ctfcpSetCallback
 ctfcpSetCopyFilenames
 ctfcpSetCopyFilePassword
 ctfcpSetCopyOptions
 ctfcpSetErrorBuffer
 ctfcpSetServerParameters
 ctFILBLK
 ctFILBLKX
 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
 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
 delChangeIDfield
 DeleteCtFile
 DeleteCtResource
 DeleteIFile
 DeleteKey
 DeleteKeyBlind
 DeleteRecord
 DeleteRFile
 DeleteVRecord
 DELFILX
 delIDfield
 DELIFILX
 DELRFILX
 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
 getChangeIDfieldNumber
 getChangeIDheaderValue
 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
 PRMIIDX82
 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
|