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

GUI Tab

Advanced tab