SAP IQ

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

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

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

DBSpace

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

Scripting name: PortNumber

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

Scripting name: JDBCConnectionString/ODBCConnectionString

User/group

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

Scripting name: ExternalLogin

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

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

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