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 Profile node. and expand the
The following sections list the extensions provided for IQ.
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 |
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)).
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 |
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 |
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:
Scripting name: JDBCConnectionString/ODBCConnectionString |
User/group |
Specifies the user or group name with which to log into the external database. Scripting name: ExternalLogin |
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 |
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 |
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 |