Programmer's Reference Guide

 
Copyright Notice
FairCom Typographical Conventions
Introduction
Prerequisites - C Language Concepts
Data Type Conventions
Strings
Sections of this Manual
ISAM Quick Tour
Introductory Tutorial
Init
Define
Manage
Done
Additional Resources
Operational Models
c-treeACE Operational Models
Standard Client/Server Model
Standalone Single-User Model
Standalone Multi-User Model
LOCLIB Model
Multi-Threaded Stand Alone Model
CTUSER Server Model
Bound Server Model
Custom Server Model
Operational Model Issues
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
FPUTFGET Lock Protocol Modification Prevent Spurious Corruption Errors
c-treeACE Concepts
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 Feature Support
Huge File Support
Xtd8 File Creation Functions
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
Extended File Creation Block Structure
Extended File Modes (x8mode)
Special Cache Value Parameter (splval)
Extended File Properties
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
Deferred Indexing
Queuing an Index Load
Counting the Number of Deferred Operations
Selected Deferred Index features extended to non-deferred indices
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
Improved Deleted Space Management
File Recovery
Advanced Space Reclamation
Transaction Processing Overview
Default Temporary File Path in Standalone and LOCLIB Models
Error Handling
Low-Level Functions
c-tree Constraints
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
Incremental ISAM and Resources
Current ISAM Record
ISAM Error Handling
ISAM Function Overview
Incremental ISAM System Functions
ISAM Parameter File System Functions
Data File and Index Functions
Set Functions
ISAM Examples
A Simple Application
Application Outline
ISAM Parameters
The Application
Initialize c-tree and open files
Add a record
Find a record
Delete a record
Close the system
Record Schemas and DODA Resources
Record Schema
Schema Map
Schema Name Details
Record Structure
Field Types
Create the Record Schema with PutDODA
Key Segments
c-treeACE Features
Variable-Length Records
Resources
Resources and Files
Resource Identification
Disabling Resources
Resource Functions
Resource Example
FairCom Defined Resources
IFIL information
DODA and Record Schema
File Security
Padding and Delimiter Values
Alternate Collating Sequence
Resource Locks
Superfiles
Creating/Opening Superfiles and Members/Host
Superfile Members/Host
Closing Superfiles and Members
Restrictions/Considerations
Nested Superfiles
Physical Order
Node Size
Detect if Superfile Member Names are too Long
Temporary Files
Rebuild
Single System File Descriptor
Risks
Batched Operations
Batch Parameters
Partial Key Request Structure
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
Using Blocking Record Reads
Data Filters
Conditional Index Support
c-treeACE Expression Parser and Grammar
Constants
Variables
Parentheses
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
Multi-Threaded API
Introduction to Threads
Some Thread Fundamentals
FairCom Thread Experience
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
Multiple ISAM Contexts (Positions)
Rebuild/Compress Utility Callback Feature
Portable Data Through UNIFRMAT Support
Modes
Automatic Mode
Manual Mode
UNIFRMAT Server
Limitations
Data Alignment
Multiple Instance Support
ctNOGLOBALS Concepts
ctNOGLOBAL Basics
Automatic Windows 3.1 Instance Support
Pre-Function Capability
Performance Optimization
PAGE_SIZE (sect) optimization
Index cache size
Data cache size
Rebuild and Compact Optimization
Single-user Standalone Index Cache
Sort Files
NO_IDXENT
Disable Key Buffer Support for Faster ISAM Access
Disable key buffer support
Enable key buffer support
Considerations
Enhanced Precision for International Languages
Client/Server Support
Standalone Support
c-treeDB Multi-Record “Virtual” Tables
Helpful Internal Functions
File System First/Next
Internal Disk Space Available function
Internal wildcard matching logic
Date routine added to ctsadm
Data Integrity
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
Begin
Commit
Aborting a Transaction
Changes in V11.5
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
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
c-treeACE Server enhanced locking control for files opened multiple times in the same connection
Table Lock Support
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
ctexmg - ISAM parameter file database sample
ctixmg - Incremental ISAM / Resource sample
ctlxmg - LOCLIB sample program
ctmark - Simulated data generation 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
ctvxmg - Variable record length ISAM parameter file example
lowlevel, isam, isam1, isam2, isam3
ioperf
selomt
trnhis
CGI
Java
c-treeACE Utility Programs
ctclntrn Utility - Clean Transaction Mark
ctcmpc - File compaction
ctcmpcif - IFIL-based Compact Utility
Updates in handling of security attributes
Preventing Possible Data Loss with Compact & Rebuild Operations
ctcv43 - Convert V4.3 Data File to c-treeACE 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 c-treeACE file from a flat file
ctflvrfy - Index Verify Utility
cthghtrn - Displays the high-water mark for transactions
ctidmp - Examine Dump Files
ctin43 - Create flat key file from V4.3 index file
ctindx - Create index file from flat key file
ctinfo - ISAM File Info
ctitop - Create OTP and Parameter Files
ctmtlk - Lock operation test utility
ctmove - Moving Files without Stopping the c-treeACE Server
ctotoi - Add IFIL and DODA Resources
ctpathmigr - Change Internal Path Separators
ctpkey - Print key utility
ctpotp - Parameter to OTP conversion
ctptoi - Parameter to IFIL conversion
ctquiet - Quiesce c-treeACE Utility
ctrbld - Parameter file rebuild utility
ctrbldif - IFIL-based Rebuild Utility
Option to set index's automatic segment attributes
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 Example
Tivoli-System Report Example
Admin-File Report Example
Tivoli-File Report Example
Admin-User Report Example
Function Timing Report Example
Text Report Example
I/O Time Statistics Example
I/O Statistics per File Example
Existing Connections Userinfo Example
ISAM Statistics Example
Enable Function Call Times by File
Function Call Times by File Example
Memory File Usage Example
Memory Allocation Example (Windows)
Transaction Statistics Example
File and User Lock Example
Memory Use and Allocation Call Stacks Example
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
c-treeACE Database Engine
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 c-treeACE Servers
Multiple Server Support per Client
Local Library Support
Server Utilities
c-treeACE 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 a Dynamic Dump
ctrdmp - Dynamic Dump Recovery or System Rollback
Rollback to New Restore Points with ctrdmp
ctfdmp - Forward Dump 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
c-treeACE Server Cache Sub-System
Allocating Memory for Data/Index Caches
Cached Data - Writing to Disk
Advanced Cache Settings
Priming Cache
Scanner Cache
Dedicated File 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
c-treeACE Server enhanced locking control for files opened multiple times in the same connection
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 Script
Server System Event Log
Retrieving System Event Log Entries
Adding System Event Log Entries
System Event Log evclass and event Codes
Multi-CPU Performance
Create a List of Arbitrary Names in Server Configuration File
Application Name List Usage
Application Name List Restrictions
Application Name List Example
Server Internals
c-treeACE Server Threads
c-treeACE Trapped Unix Signals
Client/Server ctntio Communications Errors (Formerly VDP Errors)
Diagnostic Tools
cttrap - TRAP_COMM 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
Server 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
Memory Files Overview
Using Memory Files
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-Based Queues
Server-Based Queues Overview
Using Server-Based Queues
Creating or Opening a System Queue
Writing to a System Queue
Reading from a System Queue
Retrieving the Size of the Next Message in a System Queue
Retrieving the Number of Messages in a System Queue
Closing a System 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
Open Files for Which Notification is Requested
Open a System Queue
Establish Notification for the 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
Advanced - Maximum Partitions
Rules
User-Defined Partitioned File Conditional Expressions
User-Defined Conditional Expressions for Easy Partitioned File Creation
Conditional Expressions and Partition Rules
Partitioned Files in c-treeACE SQL
c-treeDB Partition File API Support
c-treeACE ISAM Usage
Managing Partitions
Operation
Raw Partition Numbers
Unique Keys
Serial Segments (SRLSEG)
Transaction Processing
Encryption
Partitioned File Security - File password support
Partition Administration Function
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
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
ctcpvf - Master Password Verification File Utility
ctencrypt - Utility to Change Master Password
c-tree Client Implementation
Transport Layer Security Secures Data in Transit between Network c-treeACE Clients and Servers
Testing with default c-treeACE 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 c-treeACE client applications
TLS/SSL tutorials
Data Camouflage
TCP/IP Camouflage (Deprecated)
Unicode Support
Unicode Concepts
Unicode default charset for SQL CHAR and VARCHAR changed from US-ASCII to ISO-8859-1
Preparation
Storing Unicode Data
Storing UTF16 Data
Storing UTF8 Data
Unicode Key Segments
Unicode Libraries Required for c-treeACE
ICU - International Components for Unicode
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
PutXtdKeySegmentDef
GetXtdKeySegmentDef
TransformXtdSegment
API Example
Error Codes
Server Configuration Keywords for Unicode Segment Default
Unicode File Names
Mirrored File Names
c-treeACE Server SDK Overview
Server-Side Models
Making Your Own Server
STEP 1: Install the c-treeACE source code to your machine.
STEP 2: Build the makefile with the FairCom mtmake utility.
STEP 3: Execute the makefile to build your Server.
Make Summary
CTUSER Function
Default Implementation
Simple Example
Create Your Own Engine - Bound Server Model
Quick Start
Install
Make
Test
Working with Your Mainline
Initialize Threading at Startup
Set Configuration at Threading Initialization
Initialize Mutexes and Blocks
Use FairCom Threading API
Each Thread is a Separate Instance of c-treeACE
Release threading at shutdown
Bound Server and Custom Server
Customize Core Server Functionality
Create a c-treeACE Server - FairCom Custom Server
User-Defined Callback Functions for File Create, Open, and Close Operations
printf() and exit() Overrides
User-defined SIGNAL_READY and SIGNAL_DOWN Functions
Engineering Control
Low-Level API
Simple Application
Application Outline
The Application
Initialize c-treeACE
Add a record
Find a record
Delete a record
Close the system
Low Level API Example
Introductory Tutorial
Init
Define
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
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
c-treeACE Function Descriptions
Abort
AbortXtd
AddCtResource
addIDfield
IDfields - Extended support
AddKey
AddRecord
AddVRecord
AllocateBatch
AllocateRange
AllocateSet
AvailableFileNbr
Begin
BuildKey
BlockingISAMRead
ChangeBatch
ChangeHistory
ChangeISAMContext
ChangeSet
CleanIndexXtd
ClearSavePoint
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
ctCallback
ctCloseSequence
ctCopyFile
ctCreateSequence
ctDeferredIndexControl
ctDeleteSequence
ctfcpCopyFile
ctfcpFreeHandle
ctfcpAddFileCopyOperation
ctfcpAllocateHandle
ctfcpRemoveFileCopyOperation
ctfcpSetErrorBuffer
ctfcpGetErrorBuffer
ctfcpSetCallback
ctfcpSetCopyOptions
ctfcpSetCopyFilenames
ctfcpSetCopyFilePassword
ctfcpSetServerParameters
ctFILELIST
ctFILBLK
ctFileCloseCallback
ctFileCreateCallback
ctFileOpenCallback
ctFILMTX
ctfiltercb_rowl
ctfiltercbAddFilter
ctfiltercbRemoveFilter
ctGetCurrentSequenceValue
ctGetFileLocks
ctGetFileUsers
ctGETHGH
ctGetNextSequenceValue
ctGetOpenFiles
ctGetSequenceAttrs
ctImpersonateTask
ctLOKDYN
ctLOKTIMOUT
ctMBprefix
ctNotify
ctparsedoda
CtreeAsynchronous
CtreeCheckPoint
CtreeFlushFile
CtreeFlushFileXtd
CtreeUserOperation
CTUSERX
ctOpenSequence
ctRecordUpdateCallbackControl
ctSetCurrentSequenceValue
ctSetCompress
User Defined Compression Dynamic Shared Library
ctSETHGH
ctSetOWNER
ctSetSequenceAttrs
ctSQLImportTable
ctSQLImportTable options
ctStatusLogWrite
ctSysQueueClose
ctSysQueueCount
ctSysQueueLIFOWrite
ctSysQueueMlen
ctSysQueueOpen
ctSysQueueRead
ctSysQueueWrite
ctThrdAttach
ctThrdBlockCls
ctThrdBlockGet
ctThrdBlockInit
ctThrdBlockRel
ctThrdBlockWait
ctThrdCreate
ctThrdData
ctThrdDataSet
ctThrdDetach
ctThrdExit
ctThrdHandle
ctThrdInit
ctThrdLIFOWrite
ctThrdMutexCls
ctThrdMutexGet
ctThrdMutexInit
ctThrdMutexRel
ctThrdMutexTry
ctThrdQueueClose
ctThrdQueueCount
ctThrdQueueMlen
ctThrdQueueOpen
ctThrdQueueRead
ctThrdQueueReadDirect
ctThrdQueueWrite
ctThrdQueueWriteDirect
ctThrdSemapCls
ctThrdSemapGet
ctThrdSemapInit
ctThrdSemapRel
ctThrdSemapTry
ctThrdSleep
ctThrdTerm
ctTransferFile
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
EnableCtResource
EstimateKeySpan
EstimateRange
EvaluateFilter
FindFileByName
FirstInRange
FirstInVRange
FirstInSet
FirstInVSet
FirstKey
FirstRecord
FirstVRecord
FreeBatch
FreeBatchNbr
FreeHistory
FreeHistoryNbr
FreeRange
FreeSet
FreeSetNbr
GetAltSequence
getcndxmem
GetConditionalIndex
GetCtFileInfo
GetCtreePointer
GetCtResource
GetCtTempFileName
GetDODA
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
LastInVRange
LastInSet
LastInVSet
LastKey
LastRecord
LastVRecord
LoadFilter
LoadKey
LockCtData
LockDump
LockISAM
LockList
NbrOfKeyEntries
NbrOfKeysInRange
NbrOfRecords
NewData
NewVData
NextCtree
NextInRange
NextInVRange
NextInSet
NextInVSet
NextKey
NextRecord
NextVRecord
OpenCtFile
OpenCtFileXtd
OpenFileWithResource
OpenFileWithResourceXtd
OpenIFile
OpenIFileXtd
OpenISAM
OpenISAMContext
OpenISAMXtd
PartitionAdmin
Perform
PermIIndex
PermIIndex8
PositionSet
PositionVSet
PreviousInRange
PreviousInVRange
PreviousInSet
PreviousInVSet
PreviousKey
PreviousRecord
PreviousVRecord
putcndxmem
PutDODA
PutIFile
PutIFileXtd
PutIFileXtd8
PutXtdKeySegmentDef
QuietCtree
ReadData
ReadIsamData
ReadIsamVData
ReadVData
RebuildIFile
RebuildIFileXtd
RebuildIFileXtd8
RebuildIIndex
RegisterCtree
ReleaseData
ReleaseVData
RenameFile
RenameIFile
RenameIFileXtd
ReplaceSavePoint
ReReadRecord
ReReadVRecord
resetIDfield
ResetRecord
RestoreSavePoint
ReWriteRecord
ReWritePartialRecord
ReWriteVRecord
SA_ERRMSG
SA_FILES
SA_GROUP
SA_LOGOF
SA_LOGON
SA_USERS
SA_WILDCARD
Security (function)
SetAlternateSequence
SetCallbackOnRebuild
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
UpdateConditionalIndex
UpdateCtResource
UpdateFileMode
UpdateHeader
UserLogEntry
uTFRMKEY
VDataLength
VRecordLength
vtclose
wchIDfield
WhichCtree
WriteData
WriteVData
c-treeACE Error Codes
c-tree Error Code Reference
471-497 Sort Error Codes
941-942, 960-967 Logon Error Codes
Index