Initialization String
- Last Updated: October 3, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
Initialization String
Attribute
InitializationString (IS)
Purpose
A SQL command that is issued immediately after connecting to the database to manage session settings.
Valid Values
SQL_command
where:
- SQL_command
- is a valid SQL command that is supported by the database.
Example
To set the date format on every connection, specify:
Set DateStyle='ISO, MDY'
Notes
- If the statement fails to execute, the connection fails and the driver reports the error returned from the server.
Default
None