ExecutionProperties (Teiid 12.1.0 API)

```
public interface ExecutionProperties
```
These execution properties can be set via the TeiidStatement.setExecutionProperty(String, String) method. They affect the subsequent execution of all commands on that Statement instance. They can also be set using a SET statement via JDBC and take effect for the duration of the session.

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`ANSI_QUOTED_IDENTIFIERS` Overrides the handling of double quoted identifiers to allow them to be strings.
`static String`	`DISABLE_LOCAL_TRANSACTIONS` If true, will ignore autocommit for local transactions.
`static String`	`JDBC4COLUMNNAMEANDLABELSEMANTICS` TEIID-1651 A change was made in JDBC4 so that when an 'Alias' is used it will now be returned as the label.
`static String`	`NEWINSTANCE`
`static String`	`NOEXEC` Can be one of ON\|OFF
`static String`	`PROP_FETCH_SIZE` Default fetch size to use on Statements if the fetch size is not explicitly set.
`static String`	`PROP_PARTIAL_RESULTS_MODE` Execution property name for partial results mode
`static String`	`PROP_TXN_AUTO_WRAP` Execution property name for transaction auto wrap mode
`static String`	`PROP_XML_FORMAT` Execution property name for XML format
`static String`	`PROP_XML_VALIDATION` Execution property name for XML validation
`static String`	`QUERYTIMEOUT`
`static String`	`RESULT_SET_CACHE_MODE` Whether to use result set cache if it is available
`static String`	`SQL_OPTION_SHOWPLAN` Can be one of ON\|OFF\|DEBUG
`static String`	`TXN_WRAP_DETECT` Transaction auto wrap constant - checks if a command requires a transaction and will be automatically wrap it.
`static String`	`TXN_WRAP_OFF` Transaction auto wrap constant - never wrap a command execution in a transaction
`static String`	`TXN_WRAP_ON` Transaction auto wrap constant - always wrap commands in a transaction.
`static String`	`XML_COMPACT_FORMAT` XML results format: XML results displayed in compact form
`static String`	`XML_TREE_FORMAT` XML results format: XML results displayed as a formatted tree

- Field Detail
  - PROP_XML_FORMAT
```
static final String PROP_XML_FORMAT
```
    Execution property name for XML format
    
    See Also:
    
    Constant Field Values
  - PROP_XML_VALIDATION
```
static final String PROP_XML_VALIDATION
```
    Execution property name for XML validation
    
    See Also:
    
    Constant Field Values
  - PROP_TXN_AUTO_WRAP
```
static final String PROP_TXN_AUTO_WRAP
```
    Execution property name for transaction auto wrap mode
    
    See Also:
    
    Constant Field Values
  - PROP_PARTIAL_RESULTS_MODE
```
static final String PROP_PARTIAL_RESULTS_MODE
```
    Execution property name for partial results mode
    
    See Also:
    
    Constant Field Values
  - XML_TREE_FORMAT
```
static final String XML_TREE_FORMAT
```
    XML results format: XML results displayed as a formatted tree
    
    See Also:
    
    Constant Field Values
  - XML_COMPACT_FORMAT
```
static final String XML_COMPACT_FORMAT
```
    XML results format: XML results displayed in compact form
    
    See Also:
    
    Constant Field Values
  - TXN_WRAP_OFF
```
static final String TXN_WRAP_OFF
```
    Transaction auto wrap constant - never wrap a command execution in a transaction
    
    See Also:
    
    Constant Field Values
  - TXN_WRAP_ON
```
static final String TXN_WRAP_ON
```
    Transaction auto wrap constant - always wrap commands in a transaction.
    
    See Also:
    
    Constant Field Values
  - TXN_WRAP_DETECT
```
static final String TXN_WRAP_DETECT
```
    Transaction auto wrap constant - checks if a command requires a transaction and will be automatically wrap it.
    
    See Also:
    
    Constant Field Values
  - RESULT_SET_CACHE_MODE
```
static final String RESULT_SET_CACHE_MODE
```
    Whether to use result set cache if it is available
    
    Since:
    
    4.2
    
    See Also:
    
    Constant Field Values
  - PROP_FETCH_SIZE
```
static final String PROP_FETCH_SIZE
```
    Default fetch size to use on Statements if the fetch size is not explicitly set. The default is 500.
    
    Since:
    
    4.2
    
    See Also:
    
    Constant Field Values
  - DISABLE_LOCAL_TRANSACTIONS
```
static final String DISABLE_LOCAL_TRANSACTIONS
```
    If true, will ignore autocommit for local transactions.
    
    Since:
    
    5.5.2
    
    See Also:
    
    Constant Field Values
  - ANSI_QUOTED_IDENTIFIERS
```
static final String ANSI_QUOTED_IDENTIFIERS
```
    Overrides the handling of double quoted identifiers to allow them to be strings.
    
    Since:
    
    4.3
    
    See Also:
    
    Constant Field Values
  - SQL_OPTION_SHOWPLAN
```
static final String SQL_OPTION_SHOWPLAN
```
    Can be one of ON|OFF|DEBUG
    
    See Also:
    
    Constant Field Values
  - NOEXEC
```
static final String NOEXEC
```
    Can be one of ON|OFF
    
    See Also:
    
    Constant Field Values
  - NEWINSTANCE
```
static final String NEWINSTANCE
```
    See Also:
    
    Constant Field Values
  - QUERYTIMEOUT
```
static final String QUERYTIMEOUT
```
    See Also:
    
    Constant Field Values
  - JDBC4COLUMNNAMEANDLABELSEMANTICS
```
static final String JDBC4COLUMNNAMEANDLABELSEMANTICS
```
    TEIID-1651 A change was made in JDBC4 so that when an 'Alias' is used it will now be returned as the label. Prior to this, it was returned as the name. Setting this property to false will enable backwards compatibility when JDBC3 and older support is still required. Default is true
    
    Since:
    
    7.4.1
    
    See Also:
    
    Constant Field Values

Interface ExecutionProperties

Field Summary

Field Detail

PROP_XML_FORMAT

PROP_XML_VALIDATION

PROP_TXN_AUTO_WRAP

PROP_PARTIAL_RESULTS_MODE

XML_TREE_FORMAT

XML_COMPACT_FORMAT

TXN_WRAP_OFF

TXN_WRAP_ON

TXN_WRAP_DETECT

RESULT_SET_CACHE_MODE

PROP_FETCH_SIZE

DISABLE_LOCAL_TRANSACTIONS

ANSI_QUOTED_IDENTIFIERS

SQL_OPTION_SHOWPLAN

NOEXEC

NEWINSTANCE

QUERYTIMEOUT

JDBC4COLUMNNAMEANDLABELSEMANTICS