You can now set the default JDBC Run Option globally for the SQL Editor configuration through the config.ini file.
Earlier, you could set the default JDBC Run Option only for a specific workspace. This was achieved by using the Set Default JDBC Run Option button in the Configuration tab of SQL Editor.
Now, a feature has been added to IBM Data Studio. By using this feature, you can set the default JDBC Run Option globally for all workspaces.
To set the default JDBC Run Option, complete the following steps:
- Go to the location ../IBM/DS4.1.3/configuration
- Open the config.ini file.
- Add Execution_Preference=<choice> at the end of the config.ini file.
Here, <choice> indicates the value of default JDBC Run Option that you want to set.
The permitted values for <choice> are 1 , 2, and 3 which signify the following options:
Input in config.ini file
Open a new connection each time a script is run
Open a new connection and reuse it to run scripts
Use the existing connection to run scripts
12 July 2018