Sybase IQ

To create a PDM with support for features specific to the Sybase AS IQ 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 DBMSs for Sybase IQ v12.0-12.6 are deprecated.

The following sections list the extensions provided for IQ.

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 Sybase IQ tab (v12.4.3 and higher):

Name

Description

DBSpace

[v15.0 and higher] Specifies the dbspace in which to create the table (see Dbspaces (IQ)).

Scripting name: DBSpace

Global temporary table

[v12.4.3 to 15.2] Specifies that the table is a global temporary table.

Scripting name: ExtGlobalTemporaryTable

Scope

[v15.3 and higher] Specifies that the table is either a global or local temporary table.

Scripting name: TemporaryTableScope

On commit

[v15.0 and higher] Action on commit.

Scripting name: OnCommit

Not transactional

[v15.0 and higher] A table created using NOT TRANSACTIONAL is not affected by either COMMIT or ROLLBACK.

Scripting name: NotTransactional

Remote location

[v15.0 and higher] Used to create a table at the remote location.

Scripting name: At

Partition key

[v15.0 and higher] Specifies the partition key column.

Scripting name: PartitionKey

Columns

The following extensions are available on the Sybase tab (v12.4.3 and higher):

Name

Description

DBSpace

[v15.4 and higher] Specifies the database file (dbspace) in which to create the column (see Dbspaces (IQ)).

Scripting name: DBSpace

Number of distinct value (Iq unique)

Defines the cardinality of the column (to optimize the indexes internally).

Scripting name: ExtIqUnicity

In addition, from v15.0 and higher, the Partitions tab allows you to override the allocations of partitioned column values to different dbspaces (see Table and Column Partitions (IQ)).

Indexes

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

Name

Description

With nulls not distinct

[v15.4 and higher, when Unique] Specifies that more than one null value is permitted despite the index requiring unique values.

Scripting name: WithNullsNotDistinct

Tablespace

[Non-text indexes] Specifies the index dbspace (see Dbspaces (IQ)).

Scripting name: In

Notify

[Non-text indexes] Gives notification messages after n records are successfully added for the index.

Scripting name: Notify

Word length

[WD indexes] Specifies the maximum word length that is permitted in the WD index.

Scripting name: Limit

Delimited by

[WD indexes] Specifies separators to use in parsing a column string into the words to be stored in that column's WD index.

Scripting name: DelimitedBy

Configuration

[Text indexes] 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 v15.2 and higher] Specifies that the index is refreshed immediately each time data is written to the table.

Scripting name: Refresh

Keys and References

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

Name

Description

DBSpace

Specifies the DBSpace where the object is stored (see Dbspaces (IQ)).

Scripting name: PortNumber

Data Sources

The following extensions are available on the Data Movement (Lifecycle) tab (v15.0 and higher), and are required when the first phase of a lifecycle policy must manage data in an external database:

Name

Description

Remote server name

Specifies the name of the server where the remote database is located.

Scripting name: Server

Remote database name

Specifies the name of the remote database from which data must be loaded.

Scripting name: DatabaseName

Server class

Specifies the type of connection that must be made to the external database. Select the appropriate value from the list.

Scripting name: ServerClass

Connection string

Specifies the connection string used to connect to the external database in the format:
  • JDBC - <host>:<port>[/database name]
  • ODBC - <odbc name>

Scripting name: JDBCConnectionString/ODBCConnectionString

User/group

Specifies the user or group name with which to log into the external database.

Scripting name: ExternalLogin

Procedures

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

Name

Description

Temporary

[standard functions] Specifies that the function is visible only by the connection that created it, and that it is automatically dropped when the connection is dropped.

Scripting name: TempFunction

Return data type

Specifies the procedure return data type.

Scripting name: ReturnDttp

Routine characteristics

[standard functions] Transact-SQL-like error handling and deterministic options.

Scripting name: RoutineCharacteristics

Sql security

[standard functions] Defines whether the function is executed as the INVOKER, the user who is calling the function, or as the DEFINER, the user who owns the function.

Scripting name: SqlSecurity

URL

[web functions] Specifies the URL of the web service.

Scripting name: URL

Type

[web functions] Specifies the format used when making the web service request.

Scripting name: URLType

Header

[HTTP web functions] When creating HTTP web service client functions, use this clause to add or modify HTTP request header entries.

Scripting name: Header

Soap header

[SOAP web functions] When declaring a SOAP web service as a function, use this clause to specify one or more SOAP request header entries.

Scripting name: SoapHeader

Certificate

[web functions] To make a secure (HTTPS) request, a client must have access to the certificate used by the HTTPS server. The necessary information is specified in a string of semicolon-separated key/value pairs.

Scripting name: Certificate

Client port

[HTTP web functions] Identifies the port number on which the HTTP client procedure communicates using TCP/IP.

Scripting name: ClientPort

Namespace

[SOAP web functions] Identifies the method namespace usually required for both SOAP:RPC and SOAP:DOC requests.

Scripting name: Namespace

Proxy

[web functions] Specifies the URI of a proxy server.

Scripting name: Proxy

Users

The following extensions are available on the General tab (v15.0 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

Web Services

The following extensions are available on the Sybase tab (v12.6 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 (v12.6 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