IBM Support

Set the default JDBC Run Option globally for the SQL Editor configuration

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.

IBM Data Studio

Steps

To set the default JDBC Run Option, complete the following steps:

  1. Go to the location ../IBM/DS4.1.3/configuration
  2. Open the config.ini file.
  3. 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

config.ini file

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"4.1.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 July 2018

UID

ibm10716259