To create a PDM with support for features specific to the Sybase SQL Anywhere (formerly AS Anywhere) 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 Adaptive Server Anywhere v7 and v8 are deprecated.
The following sections list the extensions provided for SQL Anywhere.
The following extensions are available on the Sybase tab:
Name |
Description |
---|---|
PCTFREE |
Specifies the percentage of free space to reserve for each table page. If there is no free space in a table page, every increase in the size of a row on that page requires the row to be split across multiple table pages, causing row fragmentation and possible performance degradation. Enter an integer between 0 (no free space is to be left on each page) and 100 (high values cause each row to be inserted into a page by itself. If PCTFREE is not set, 200 bytes are reserved in each page. Scripting name: PctFree |
Dbspace (tablespace) |
Specifies the dbspace in which the table is to be created Scripting name: DbspaceIn |
Remote location |
Creates a table at the specified remote location in addition to a proxy table on the current database that maps to the remote table. Supports the semicolon (;) as a field delimiter in the location-string. If no semicolon is present, a period is the field delimiter. Scripting name: At |
Encrypted |
Encrypts the table using the encryption key and algorithm specified at database creation time. Encrypting a table may take time, depending on the size of the table. Scripting name: Encrypted |
Temporary table/Global temporary table |
Specifies either temporary table is a global or a local temporary table. Scripting name: [v10 and higher] TemporaryTable, [up to v9] ExtGlobalTemporaryTable |
Not transactional |
[temporary tables] Specifies that the temporary table is not affected by either COMMIT or ROLLBACK. This can provide performance improvements because operations on non-transactional temporary tables do not require entries in the rollback log. For example, NOT TRANSACTIONAL may be useful if procedures that use the temporary table are called repeatedly with no intervening COMMITs or ROLLBACKs. Scripting name: TemporaryTableOptionsNotTransactional |
On commit |
[temporary tables] Specifies that the rows of a temporary table are deleted on COMMIT. Scripting name: TemporaryTableOptionsOnCommit |
The following extensions are available on the Sybase tab:
Name |
Description |
---|---|
Tablespace |
[Non-text indexes] Specifies the index dbspace. Scripting name: In |
Virtual index |
[v10 and higher] The VIRTUAL keyword is primarily for use by the Index Consultant. A virtual index mimics the properties of a real physical index during the evaluation of query plans by the Index Consultant and when the PLAN function is used. You can use virtual indexes together with the PLAN function to explore the performance impact of an index, without the often time consuming and resource consuming effects of creating a real index. Scripting name: Virtual |
Notify |
[Non-text indexes v12 and higher] Gives notification messages after n records are successfully added for the index. Scripting name: Notify |
Word length |
[Non-text indexes v12 and higher] Specifies the maximum word length that is permitted. Scripting name: Limit |
Delimited by |
[Non-text indexes v12 and higher] Specifies separators to use in parsing a column string into the words to be stored in the index. Scripting name: DelimitedBy |
Text index |
[v12 and higher] Specifies whether the index is a text index or not. Scripting name: TextIndex |
Configuration |
[Text indexes v12 and higher] Specifies the text configuration (see Text Configurations) to be used to control the building of the text index. Scripting name: Configuration |
Immediate refresh |
[Text indexes v12 and higher] Specifies that the index is refreshed immediately each time data is written to the table. Scripting name: Refresh |
The following extensions are available on the General tab (v12 and higher):
Name |
Description |
---|---|
Force change |
Controls whether the user must specify a new password when they log in. This setting overrides the password_expiry_on_next_login option setting in the login policy. Scripting name: ForcePasswordChange |
Login policy |
Specifies the login policy to assign to the user (see Login Policies). Scripting name: LoginPolicy |
The following extensions are available on the Sybase tab (v9 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 |
Name prefix |
[DISH service type] Specifies a name prefix. Only SOAP services whose names begin with this prefix are handled. Scripting name: Prefix |