Holds the information needed to create a database using the DBTools library.
typedef struct a_create_db
Member name | Type | Description |
---|---|---|
accent_sensitivity |
char |
One of 'y', 'n', or 'f' (yes, no, French). Generates one of the ACCENT RESPECT, ACCENT IGNORE or ACCENT FRENCH clauses. |
avoid_view_collisions |
a_bit_field |
Set TRUE to omit the generation of Watcom SQL compatibility views SYS.SYSCOLUMNS and SYS.SYSINDEXES. Set TRUE by dbinit -k option. |
blank_pad |
a_bit_field |
Must be one of NO_BLANK_PADDING or BLANK_PADDING. Treat blanks as significant in string comparisons and hold index information to reflect this. See Blank padding enumeration. Equivalent to dbinit -b option. |
case_sensitivity_use_default |
a_bit_field |
Set TRUE to use the default case sensitivity for the locale. This only affects UCA. If set TRUE then we do not add the CASE RESPECT clause to the CREATE DATABASE statement. |
checksum |
a_bit_field |
Set to TRUE for ON or FALSE for OFF. Generates one of CHECKSUM ON or CHECKSUM OFF clauses. Set TRUE by dbinit -s option. |
data_store_type |
const char * |
Reserved. Use NULL. |
db_size |
unsigned int |
When not 0, generates the DATABASE SIZE clause. Equivalent to dbinit -dbs option. |
db_size_unit |
int |
Used with db_size, must be one of DBSP_UNIT_NONE, DBSP_UNIT_PAGES, DBSP_UNIT_BYTES, DBSP_UNIT_KILOBYTES, DBSP_UNIT_MEGABYTES, DBSP_UNIT_GIGABYTES, or DBSP_UNIT_TERABYTES. When not DBSP_UNIT_NONE, it generates the corresponding keyword (for example, DATABASE SIZE 10 MB is generated when db_size is 10 and db_size_unit is DBSP_UNIT_MEGABYTES). See Database size unit enumeration. |
dba_pwd |
char * |
When not NULL, generates the DBA PASSWORD xxx clause. Equivalent to dbinit -dba option. |
dba_uid |
char * |
When not NULL, generates the DBA USER xxx clause. Equivalent to dbinit -dba option. |
dbname |
const char * |
Database file name. |
default_collation |
const char * |
The collation for the database. Equivalent to dbinit -z option. |
encoding |
const char * |
The character set encoding. Equivalent to dbinit -ze option. |
encrypt |
a_bit_field |
Set TRUE to generate the ENCRYPTED ON clause or, when encrypted_tables is also set, the ENCRYPTED TABLES ON clause. Set TRUE by dbinit -e? options. |
encrypted_tables |
a_bit_field |
Set TRUE to encrypt tables. Used with encrypt, it generates the ENCRYPTED TABLE ON clause instead of the ENCRYPTED ON clause. Set TRUE by dbinit -et option. |
encryption_algorithm |
const char * |
The encryption algorithm (AES, AES256, AES_FIPS, or AES256_FIPS). Used with encrypt and encryption_key, it generates the ALGORITHM clause. Equivalent to dbinit -ea option. |
encryption_key |
const char * |
The encryption key for the database file. Used with encrypt, it generates the KEY clause. Equivalent to dbinit -ek option. |
errorrtn |
MSG_CALLBACK |
Address of an error message callback routine or NULL. |
iq_params |
void * |
Reserved. Use NULL. |
jconnect |
a_bit_field |
Set TRUE to include system procedures needed for jConnect. Set FALSE by dbinit -i option. |
logname |
const char * |
New transaction log name. Equivalent to dbinit -t option. |
mirrorname |
const char * |
Transaction log mirror name. Equivalent to dbinit -m option. |
msgrtn |
MSG_CALLBACK |
Address of an information message callback routine or NULL. |
nchar_collation |
const char * |
The NCHAR COLLATION for the database when not NULL. Equivalent to dbinit -zn option. |
page_size |
unsigned short |
The page size of the database. Equivalent to dbinit -p option. |
respect_case |
a_bit_field |
Make string comparisons case sensitive and hold index information to reflect this. Set TRUE by dbinit -c option. |
startline |
const char * |
The command line used to start the database server. For example: "c:\SQLAny12\bin32\dbeng12.exe". If NULL, the default START parameter is "dbeng12 -gp <page_size> -c 10M" where page_size is specified below. Note that "-c 10M" is appended if page_size >= 2048. |
verbose |
char |
See Verbosity enumeration (VB_QUIET, VB_NORMAL, VB_VERBOSE). |
version |
unsigned short |
DBTools version number (DB_TOOLS_VERSION_NUMBER). |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |