Sybase AS Enterprise Extended Attributes

Columns

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. Enabled only for columns with a datatype that supports encryption. Scripting name: Encrypted
Encryption key	[v12.5.3a and higher] Specifies an encryption key. Use the tools to the create or select a key (see Encryption Keys). Scripting name: EncryptionKey
Default decrypt value	[v15.5.0 and higher] Specifies the default constant value that is returned to users who do not have decrypt permissions. Scripting name: DecryptDefault

Databases

The following extended attributes are available on the General tab:

Name	Description
For cluster	[v15.5.0 and higher] Specifies that the database will support clustering. Scripting name: ForCluster
Type	[v15.5.0 and higher] Specifies the whether the database is of type: [for standard databases] `inmemory`, `temporary`, or `inmemory temporary` [for cluster databases] `temporary`, `global temporary`, or `system temporary` . Scripting name: DatabaseType

Name

Description

For cluster

[v15.5.0 and higher] Specifies that the database will support clustering.

Scripting name: ForCluster

Type

[v15.5.0 and higher] Specifies the whether the database is of type:

[for standard databases] inmemory, temporary, or inmemory temporary
[for cluster databases] temporary, global temporary, or system temporary

.

Scripting name: DatabaseType

Keys

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

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

Model

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

Name

Description

Encryption password

Global encryption password.

Scripting name: EncryptionPassword

Web Services

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

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

Web Operations

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

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