SAP Adaptive Server Enterprise

To create a PDM with support for features specific to the SAP® Adaptive Server® Enterprise DBMS family, select the appropriate version in the DBMS field of the New Model dialog. To view these extensions to the PowerDesigner metamodel in the Resource Editor, select Start of the navigation path Database Next navigation step Edit Current DBMS End of the navigation path and expand the Profile node.

Note The DBMS definition files for AS Enterprise v12.5.3 and v15.0 are deprecated.

The following sections list the extensions provided for ASE.

Note We do not provide documentation for the properties on the Physical Options and certain other tabs, though minimal information is available for them in the Resource Editor. For information about these properties, consult your DBMS reference documentation.

Tables

The following extensions are available on the Partitions tab (v15.0 and higher):

Name	Description
Partition	Indicates how records are distributed on table partitions. You must choose between: `Range` - partitioned according to specified ranges of values in the partitioning column or columns (Scripting name: PartitionByRange). `Hash` - partitioned by a system-supplied hash function (Scripting name: `PartitionByHash`). `List` - partitioned according to literal values specified in the named column (Scripting name: `PartitionByList`). `Round robin` - partitioned in a sequential manner (Scripting name: `PartitionByRoundrobin`). Each of the partitioning methods enables a list of partitions for you to complete, except round robin by partition number, which requires only that you specify the number of available partitions on a particular storage. Scripting name: `Partition`
Columns	[`Range` and `Hash`] Specifies an ordered list of columns used to determine into which partition a row belongs. Scripting name: `PartitionByRangeColumnListColumn, PartitionByHashColumnListColumn`
Column	[`List`] Specifies the column used to determine into which partition a row belongs. Scripting name: `PartitionByListColumnColumnName`
List	[`Round robin`] Specifies the table partitions Scripting name: `PartitionByRoundrobinSegmentEnumOnAbsence`
Partition number	[`Round robin`] Specifies the number of partitions for the table. Scripting name: `PartitionByRoundrobinSegmentEnumOnPresence`
Quantity	[`Round robin` by partition number] Number of partitions for the table Scripting name: `PartitionByRoundrobinSegmentEnumPartitionNum`
Storage (segment)	[`Round robin` by partition number] Specifies the name of the segment on which to place the table partition. Scripting name: `PartitionByRoundrobinSegmentEnumOnSegmentName`
[list of partitions]	[all but `Round robin` by partition number] Specifies the list of partitions to be used Scripting name: `PartitionByRangePartitionListPartitionDefinition, PartitionByHashPartitionListPartitionDefinition, PartitionByListPartitionListPartitionDefinition,PartitionByRoundrobinPartitionListPartitionDefinition`

Columns

The following extensions are available on the AS Enterprise/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	[v15.0 and higher] 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 (ASE)). 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`
Compressed	[v15.7 and higher] Specifies that the data in the column is compressed. Scripting name: `Compressed`
Compression Level	[v15.7 and higher] Specifies the level of column data compression. Scripting name: `CompressionLevel`

Databases

The following extensions are available on the General tab:

Name	Description
Encryption key	[v16 and higher] Specifies the key used to encrypt the whole database. Scripting name: `EncryptionKey`
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

Encryption key

[v16 and higher] Specifies the key used to encrypt the whole database.

Scripting name: EncryptionKey

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 extensions are available on the AS Enterprise/Sybase tab:

Name	Description
Key index is descending	[v12.0 and higher] 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

[v12.0 and higher] Specifies if the index created for a constraint is to be created in descending order for each column.

Scripting name: DescKey

Model

The following extensions 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 extensions are available on the AS Enterprise/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 extensions are available on the AS Enterprise/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