Sybase AS Enterprise extended attributes

Chapter 12 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	[v12.0 and higher] 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
Encrypted	[v12.5.3a and higher] Specifies that the column is encrypted. Scripting name: Encrypted
Encryption Key	[v12.5.3a and higher] Specifies an encryption key name. Scripting name: EncryptionKey

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 (v12.5.3a and higher):

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

The following extended attributes are available on the Sybase tab (v15.0 and higher):

Name	Description
Port number	Specifies the web service port number. Scripting name: PortNumber
Server name	Specifies the web service server name. Scripting name: ServerName
Database name	Specifies the database name used in the URL to access the web service. Scripting name: DatabaseName

The following extended attributes are available on the Sybase tab (v15.0 and higher):

Name	Description
Alias	Specifies the name of the user-defined database alias. Scripting name: Alias
Secure	Security option. clear indicates that HTTP is used to access this Web service. ssl indicates HTTPS is used to access this Web service Scripting name: Secure