Advantage Database Server

system.dictionary

Advantage SQL Engine

system.dictionary

Advantage SQL Engine

Previous topic Next topic  

system.dictionary

Advantage SQL Engine

Previous topic Next topic  

Contains a single row for all dictionary properties.

Field Name

Field Type

Field Size

Description

Version_Major

Short

2

Major version number of the dictionary.

Version_Minor

Short

2

Minor version number of the dictionary.

Default_Table_Path

Character

260

Default table path for the dictionary.

Temp_Table_Path

Character

260

Temporary table path for the dictionary.

Log_In_Required

Logical

1

Determines if a username and password is required for a database connection.

Verify_Access_Rights

Logical

1

Determines if the user’s access rights when opening a database table, view, or executing a stored procedure are enforced.

Encrypt_Table_Password

Charcter

20

Password used for encrypting tables. This value is only returned for administrative data dictionary connections.

Encrypt_New_Table

Logical

1

Determines if a new table added to or created in the data dictionary will be encrypted.

Enable_Internet

Logical

1

Determines if Internet access is allowed to this data dictionary.

Internet_Security_Level

Short

2

The security level for communications over the Internet.

Max_Failed_Attempts

Short

2

The maximum number of failed connection attempts allowed before Internet access is shut off.

Logins_Disabled

Logical

1

Determines if logins are currently disabled. See Disabling Database Logins for more details.

Logins_Disabled_msg

Memo

variable

Specifies the custom error string that will be returned to users attempting to connect to the database when logins are disabled.

Comment

Memo

variable

Description of the dictionary.

User_Defined_Prop

Binary

variable

The user defined property.

FTS_Delimiters

Memo

variable

FTS delimiter characters.

FTS_Noise_Words

Memo

variable

FTS noise words.

FTS_DropChars

Memo

variable

FTS drop characters.

FTS_Conditional_Chars

Memo

variable

FTS conditional drop characters.

Dictionary_Encrypted

Logical

1

Determines if the data dictionary file is encrypted.

Encrypt_Indexes

Logical

1

Determines if indexes are encrypted.

Encrypt_Communication

Logical

1

Determines if communication between the client and server is encrypted.

Data_Encryption_Type

Integer

4

Specifies the type of encryption that is used for newly encrypted tables. This property is set when the dictionary is created. Possible values include ADS_ENCRYPTION_RC4 (3), ADS_ENCRYPTION_AES128 (5), and ADS_ENCRYPTION_AES256 (6). It is possible to change the encryption type with the system procedure sp_SetDDEncryptionType.

Query_Via_Root

Integer

4

This property specifies whether passthrough queries are allowed through the root dictionary. Valid values are a combination (bitmask) of ADS_DD_QVR_OPT_QUERY (0x01) and ADS_DD_QVR_OPT_PROCEDURE (0x02). The first value indicates that passthrough queries are allowed. The second value indicates that passthrough procedure calls are allowed. This property is checked by the Advantage Web Platform when queries and procedure calls are made "through" the root dictionary to another dictionary. If the value is not set, then the request is denied. This property was introduced primarily for use by the Web Administrator Utility.