Target Interaction Properties

Controls how an access service interacts with the target database.

{Target Interaction}
Allocate=
DelimitSqlRequests=
DisableROLock=
IsolationLevel=
QuotedStringDelimeter=
ReturnNativeError=
SQLOdbcCursors=
SQLTransformation=
StopCondition=
TargetDBMS=
TargetDecimalSeparator=

• Allocate
  Controls when an access service allocates conversations with the target database system.
• DelimitSqlRequests
  Allows statements to be batched and executed as a single request to the target DBMS. Statements are delimited with a semicolon (;).
• DisableROLock
  (Microsoft SQL Only)Disables a lock that is created in a read-only cursor.
• IsolationLevel
  Controls the level of locking and records access to ODBC-accessible tables.
• QuotedStringDelimiter
  Specifies the character used for quoted strings.
• ReturnNativeError
  Allows a non localized native error message and a native error severity to be returned to the client.
• SQLOdbcCursors
  Controls ODBC cursor library usage.
• SQLTransformation
  Specifies the mode the access service uses for SQL transformation.
• StopCondition
  Specifies the conditions under which an access service stops processing results.
• TargetDBMS
  Specifies whether SQL transformation are applied to specific dialects of DB2 for z/OS, or DB2 for Windows and UNIX.
• TargetDecimalSeparator
  Specifies the character delimiter for the fractional part of decimal numbers passed between the access service and the target DBMS.