invantive documentation
Invantive Support ForumsLog In / Sign Up

EZ-Base Attributes

Other

analysis-enforce-row-uniqueness

Use for analysis only! Enforce rows to be unique.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

bulk-delete-page-size-rows

Number of rows to delete per batch when bulk deleting.

  • Default: 10000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

bulk-insert-page-size-bytes

Approximate maximum size in bytes of batch when bulk inserting.

  • Default: 10000000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

bulk-insert-page-size-rows

Number of rows to insert per batch when bulk inserting.

  • Default: 10000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

force-case-sensitive-identifiers

Consider identifiers as case-sensitive independent of the platform capabilities.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

forced-casing-identifiers

Forced casing of identifiers. Choose from: Unset, Lower, Upper and Mixed.

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

invantive-sql-compress-sparse-arrays

Whether to compress sparse arrays in result sets during compression.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-correct-invalid-date

Whether to correct dates considered invalid since they are before 01-01-1753. When nullable, they are removed. Otherwise they are replaced by 01-01-1753.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-forward-filters-to-data-containers

Whether to forward filters to data containers.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-share-byte-arrays

Whether to share the memory used by identical byte arrays in result sets during compression.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-share-strings

Whether to share the memory used by identical strings in result sets during compression.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-sql-shuffle-fetch-results-data-containers

Whether to shuffle results fetched from data containers.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

invantive-use-cache

Whether to cache the results of a query.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: SQL Engine V1

log-native-calls-to-disk-max-events

Maximum number of call events to register from last activation.

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

log-native-calls-to-disk-max-seconds

Maximum number of seconds to register calls from last activation.

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

log-native-calls-to-disk-on-error

Registers native calls to data container backend as disk files when the call raised an error.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

log-native-calls-to-disk-on-success

Registers native calls to data container backend as disk files when the call raised no error.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

log-native-calls-to-trace

Log native calls to data container backend on the trace.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

max-url-length-accepted

The maximum accepted URL length before raising an error.

  • Default: 8000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

max-url-length-desired

The maximum desired URL length.

  • Default: 8000
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

maximum-length-identifiers

Non-default maximum length in characters of identifier names.

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

minimum-length-text

Extend all text columns to this length to allow processing of XML that uses longer text values than the XSD specifies.

  • Set from: connection string, log on
  • Defined by: XML

partition-slot-based-rate-limit-length-ms

Total length in milliseconds across all slots of a partition-based rate limit.

  • Default: 60000
  • Set from: connection string, provider file
  • Defined by: Shared

partition-slot-based-rate-limit-slots

Number of slots per partition-based rate limit. Null means no slot-based rate limit.

  • Set from: connection string, provider file
  • Defined by: Shared

pre-request-delay-ms

Pre-request delay in milliseconds per request.

  • Default: 0
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

requested-page-size

Preferred number of rows to exchange per round trip; only effective on limited platforms such as AFAS Online.

  • Set from: connection string, set statement, provider file
  • Defined by: Shared

requests-parallel-max

Maximum number of parallel data requests from individual partitions on the data container.

  • Default: 32
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

result-set-memory-cache

Action: provide 'empty' to empty.

  • Set from: set statement
  • Defined by: XML

slot-based-rate-limit-length-ms

Total length in milliseconds across all slots of a slot-based rate limit.

  • Default: 60000
  • Set from: connection string, provider file
  • Defined by: Shared

slot-based-rate-limit-slots

Number of slots of a slot-based rate limit. Null means no slot-based rate limit.

  • Set from: connection string, provider file
  • Defined by: Shared

standardize-identifiers

Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

standardize-identifiers-casing

Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: Shared

use-metadata-memory-cache

Whether to use the metadata in memory calculated previouslyHas only practical use during development on a XML provider.

  • Default: True
  • Set from: connection string, set statement, provider file
  • Defined by: XML

use-result-memory-cache

Whether to use result sets cached in memory from previous queries that can answer the current query.

  • Default: False
  • Set from: connection string, set statement, provider file
  • Defined by: XML

xml-directories

Comma-separated list of directories with XML files

  • Set from: connection string, set statement, provider file, log on

xml-extension

Search pattern for XML files, including support for * and ?

  • Default: *.xml
  • Set from: connection string, set statement, provider file, log on

xml-namespaces

Comma-separated list of namespace prefixes and their URI

  • Set from: connection string, set statement, provider file