Advanced tab
- Last Updated: May 20, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Greenplum 8.0
- Documentation
The Advanced tab allows you to specify additional data source settings. The fields are optional unless otherwise noted. On this tab, provide values for the options in the following table; then, click Apply.
| Connection Options: Advanced | Default |
|---|---|
| Application Using Threads | Enabled |
| Enable SQLDescribeParam | Enabled |
| Fetch TSWTZ as Timestamp | Disabled |
| Fetch TWFS as Time | Disabled |
| TCP Keep Alive | Disabled |
| Fetch RefCursors | Enabled |
| Batch Mechanism | 3-Copy |
| Extended Column MetaData | Disabled |
| Enable Keyset Cursors | Disabled |
| Keyset Cursor Options | 0-RowID Columns |
| Transaction Error Behavior | 1-Rollback |
| XML Describe Type | -10 |
| Initialization String | No default value |
| Report Codepage Conversion Errors | 0-Ignore Errors |
| Unbounded Numeric Precision | -1 |
| Unbounded Numeric Scale | -1 |
| Login Timeout | 15 |
| Query Timeout | 0 |
| Max Char Size | No default value |
| Max Varchar Size | No default value |
| Max Long Varchar Size | No default value |
| Extended Options | No default value |