How To
Summary
You can now set the default JDBC Run Option globally for the SQL Editor configuration through the config.ini file.
Objective
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.
Steps
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 | Selected Option |
| Execution_Preference=1 | Open a new connection each time a script is run |
| Execution_Preference=2 | Open a new connection and reuse it to run scripts |
| Execution_Preference=3 | Use the existing connection to run scripts |
Was this topic helpful?
Document Information
Modified date:
12 July 2018
UID
ibm10716259