Global variable management

This topic provides information on managing global variables.

Background information

A global variable is a database variable for global management and control of a database.

On the Global Variables page of ODC, you can query and modify all database variables for the current data source.

Query global variables

Assume that you want to query database variables of the data source mysql420 in the SQL development window.

1. In the left-side navigation pane, select O&M Management > Global Variables.

   

2. Select the data source mysql420 and click OK.

   

3. On the Global Variables page, you can query all database variables of the data source mysql420.

   

Edit global variables

Assume that you want to modify the value of the database variable connect_timeout for the data source mysql420 in the SQL development window.

1. Search for the connect_timeout database in the search field.

   

2. In the Session Attributes list, click the variable name connect_timeout and then click the Edit button to change the value to 20.

   

3. In the SQL Confirmation dialog box, modify and confirm the SQL statement and click Execute.

   

4. In the Session Attributes list, you can view the new value of the connect_timeout variable.

References

• Manage sessions

• Recycle bin management