Sybase SQL Anywhere Extended Attributes

Column is compressed

Specifies whether this column is stored in a compressed format.

Scripting name: Compressed

PCTFREE

Specifies the percentage of free space you want to reserve for each table page. The free space is used if rows increase in size when the data is updated. 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.

The value percent-free-space is an integer between 0 and 100. The former specifies that no free space is to be left on each page (each page is to be fully packed). A high value causes 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

Temporary table

Specifies either temporary table is a global or a local temporary table.

Scripting name: TemporaryTable

Virtual index

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

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

URL

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

Scripting name: Url