SAP Sybase SQL Anywhere

To create a PDM with support for features specific to the SAP® 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 Database > Edit Current DBMS and expand the Profile node.

Note: The DBMS definition files for Sybase AS Anywhere/ SQL Anywhere v9 and v10 are deprecated.

The following sections list the extensions provided for SQL Anywhere.

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.

Columns

The following extensions are available on the Sybase tab (v10 and higher):

Name

Description

Column is compressed

Specifies whether this column is stored in a compressed format.

Scripting name: Compressed

Tables

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

Indexes

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 (IQ/SQL Anywhere)) 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

Users

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 (IQ/SQL Anywhere)).

Scripting name: LoginPolicy

Web Services

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

Web Operations

The following extensions are available on the Sybase tab (v9 and higher) when the service type is not dish:

Name

Description

URL

Determines whether URI paths are accepted and, if so, how they are processed.

Scripting name: Url