© 2005 Elevate Software All Rights Reserved
elev~te software
dbisam
DBISAM Version 4 Manual
DBISAM Version 4 Manual
© 2005 Elevate Software All Rights Reserved
This PDF document was generated using the Elevate Software automated document generation
system
Table of Contents
Table of Contents
Chapter 1 - Before You Begin 1
1.1 Changes From Version 3.x 1
1.2 New Features in Version 4.x 7
Chapter 2 - Using DBISAM 15
2.1 DBISAM Architecture 15
2.2 Data Types and NULL Support 21
2.3 Exception Handling and Errors 26
2.4 Cross Platform Considerations 29
2.5 Enabling Large File Support 30
2.6 Configuring and Starting the Server 31
2.7 Server Administration 38
2.8 Customizing the Engine 43
2.9 Starting Sessions 52
2.10 Calling Server-Side Procedures 56
2.11 Opening Databases 57
2.12 Transactions 58
2.13 Backing Up and Restoring Databases 62
2.14 In-Memory Tables 65
2.15 Creating and Altering Tables 65
2.16 Upgrading Tables 71
2.17 Deleting Tables 72
2.18 Renaming Tables 73
2.19 Adding and Deleting Indexes from a Table 74
DBISAM Version 4 Manual - Table of Contents
Table of Contents
2.20 Emptying Tables 76
2.21 Copying Tables 77
2.22 Optimizing Tables 78
2.23 Verifying and Repairing Tables 79
2.24 Opening Tables 81
2.25 Closing Tables 85
2.26 Executing SQL Queries 85
2.27 Live Queries and Canned Queries 92
2.28 Parameterized Queries 93
2.29 Navigating Tables and Query Result Sets 95
2.30 Updating Tables and Query Result Sets 97
2.31 Searching and Sorting Tables and Query Result Sets 104
2.32 Setting Ranges on Tables 108
2.33 Setting Master-Detail Links on Tables 110
2.34 Setting Filters on Tables and Query Result Sets 112
2.35 Loading and Saving Streams with Tables and Query Result Sets 114
2.36 Importing and Exporting Tables and Query Result Sets 115
2.37 Cached Updates 119
Chapter 3 - Advanced Topics 123
3.1 Locking and Concurrency 123
3.2 Buffering and Caching 127
3.3 Change Detection 128
3.4 Index Compression 129
3.5 Filter Optimization 130
3.6 Multi-Threaded Applications 134
Table of Contents - DBISAM Version 4 Manual
Table of Contents
3.7 Full Text Indexing 136
3.8 Compression 139
3.9 Encryption 140
3.10 Recompiling the DBISAM Source Code 141
3.11 Replacement Memory Manager 142
Chapter 4 - SQL Reference 145
4.1 Overview 145
4.2 Naming Conventions 146
4.3 Unsupported SQL 154
4.4 Optimizations 155
4.5 Operators 163
4.6 Functions 171
4.7 SELECT Statement 193
4.8 INSERT Statement 204
4.9 UPDATE Statement 206
4.10 DELETE Statement 209
4.11 CREATE TABLE Statement 211
4.12 CREATE INDEX Statement 216
4.13 ALTER TABLE Statement 218
4.14 EMPTY TABLE Statement 220
4.15 OPTIMIZE TABLE Statement 220
4.16 EXPORT TABLE Statement 221
4.17 IMPORT TABLE Statement 222
4.18 VERIFY TABLE Statement 223
4.19 REPAIR TABLE Statement 223
DBISAM Version 4 Manual - Table of Contents
评论6