skip to main content
DataDirect Connect Drivers : DB2 Driver : Connection Properties : InitializationString
  
InitializationString
Purpose
Specifies one or multiple SQL commands to be executed by the driver after it has established the connection to the database and has performed all initialization for the connection. If the execution of a SQL command fails, the connection attempt also fails and the driver throws an exception indicating which SQL command or commands failed.
Valid Values
command [[; command ]...]
where:
command
is a SQL command.
Notes
*Multiple commands must be separated by semicolons. In addition, if this property is specified in a connection URL, the entire value must be enclosed in parentheses when multiple commands are specified.
Example
The following connection URL adds USER2 to the CURRENT PATH special register and sets the CURRENT PRECISION special register to DEC31.
jdbc:datadirect:db2://server1:50000;InitializationString=
(SET CURRENT PATH=current_path, USER2;SET CURRENT PRECISION='DEC31')
Setting the CURRENT PRECISION special register is only valid for DB2 for z/OS.
Default
None
Data Type
String