1
Download Pervasive.SQL User's Guide Server Edition
Transcript
Table B-1 Summary of Description File Elements continued Element Keyword and Format Range Comments Data Compression* compress=<y|n> N/A Not applicable to keyonly files. Key Count key=nnn 0–119 Specify 0 to create a data-only file. Page Size page=nnnn 512– 4,096 Must be a multiple of 512. Page Preallocation* allocation=nnnnn 1– 65,535 None. Replace Existing File*# replace=<y|n> N/A None. Include Data* data=<y|n> N/A Specify n to create a key-only file. Cannot create a key-only file that both allows duplicates and uses a systemdefined key. Free Space Threshold* fthreshold=<5|10|20|30> N/A Applicable only for files that have variable-length records. The default is 5. Variable-Tail Allocation Tables (VATs) huge=<y|n> # vats=<y|n> N/A Applicable only for files that have variable-length records. Balanced Index* balance=<y|n> N/A None. Use Key Number * usekeynum=<y|n> N/A Used with the Key Number element. Pervasive.SQL User’s Guide 393 Description Files
