Sybase AS Enterprise extended attributes

Chapter 15 DBMS-Specific Features

The following extended attributes are defined by default in the Sybase AS Enterprise DBMS.

The following extended attributes are available on the Sybase tab:

Name	Description
Store Java-SQL column in row	Specifies whether a Java-SQL column is stored separate from the row (set to False) or in storage allocated directly in the row (set to True). Scripting name: InRow
Computed column is materialized	Specifies that the computed column is materialized. Scripting name: Materialized
Encryption Key	Specifies an encryption key name. Scripting name: EncryptionKey

The following extended attributes are available for extended objects with a stereotype of Encryption Key, on the Detail tab (version 12.5.3a only):

Name	Description
Algorithm	Advanced Encryption Standard (AES) is the only algorithm supported. Scripting name: Algorithm
Default encryption key	Allows the System Security Officer to create a default key for use on all encrypted columns which do not have a keyname specified in create table or alter table. This is a database specific default key for use with tables in the same database. The default key is stored in the database sysencryptkeys table, the same as non-default keys. Scripting name: Default
Initialization vector	Omits the use of an initialization vector when encrypting. This makes the column suitable for supporting an index. When an initialization vector is used by the encryption algorithm, the ciphertext of two identical pieces of plaintext will be different, which would prevent the cryptanalyst from detecting patterns of data but would render the data on disk useless for indexing or matching without decryption. Scripting name: InitVector
Key length	Size in bits of the key to be created.For AES valid key lengths are 128, 192 and 256 bits. Scripting name: KeyLength
Padding of datatypes	To use padding of datatypes whose length is less than one block. Padding can be used instead of an initialization vector to randomize the ciphertext. It is only suitable for columns whose plaintext length is less than half the block length. For the default AES algorithm the block length is 16 bytes. Scripting name: Pad

The following extended attributes are available on the Sybase tab:

Name	Description
Key index is descending	Specifies if the index created for a constraint is to be created in descending order for each column. Scripting name: DescKey

The following extended attributes are available on the Encryption tab (version 12.5.3a only):

Name	Description
Encryption password	Global encryption password. Scripting name: EncryptionPassword

The following extended attributes are available on the Sybase tab:

Name	Description
Number of partitions	Specifies the number of partitions for a table. Scripting name: ExtTablePartition