QDB parses this object to set up a database
For every loaded database, the /pps/qnx/qdb/config directory contains a PPS object with the same name as the database (e.g., /pps/qnx/qdb/config/bluetoothdb).
Parameter | Description |
---|---|
AutoAttach | Specifies other databases to attach to the current one (using the SQL ATTACH DATABASE statement). |
BackupAttached | Sets this operation as the default for attached databases when a command is issued to the main database. |
BackupDir | Specifies the directories for storing database backups. |
BackupVia | Specifies an interim directory to copy a database as part of the backup. |
ClientSchemaFile | Names the client schema file (with an absolute path) that contains the SQL commands to run whenever a client calls qdb_connect(). |
Collation | Installs user-provided collation (sorting) routines. |
Compression <option> | Specifies the compression algorithm to apply to backups. Options:
|
CompressionVia true|false | Used with BackupVia and any Compression setting specified. Default is false. Set this to true if you want BackupVia to use compression during its first step. |
DataSchemaFile | If SchemaFile is set, names the file (with an absolute path) that contains the SQL commands to populate a database when it's created. |
Filename | Sets the name of the database (raw SQLite) file. This must be an absolute path. |
Function | Installs user scalar/aggregate functions. |
SchemaFile | Names the file (with an absolute path) that contains the SQL commands to create the initial schema of tables, indexes, and views of a new database. |
SizeAttached | Sets this operation as the default for attached databases when a command is issued to the main database. |
VacuumAttached | Sets this operation as the default for attached databases when a command is issued to the main database. |