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