To create a PDM with support for features specific to the Sybase ASE 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 Profile node. and expand the
The DBMSs for Sybase AS Enterprise v11.0 and v11.5-11.9 are deprecated.
The following sections list the extensions provided for ASE.
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:
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 |
The following extensions 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 |
[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). 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 |
The following extensions 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:
Scripting name: DatabaseType |
The following extensions 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 |