How You Can Specify a Database Session
The Database Connections portlet on the Query tab lets you specify the session in which your queries run. You can open a new session or select one of the sessions of the currently executing application.
Create a New Database Connection
You can create a new database connection and session in the Database Connections portlet of the Query tab.
To creagte a new database connection
1. Click to select the Database Connections folder.
2. Right-click the Database Connections folder and select New from the pop-up menu.
The Connect to DB dialog appears.
3. Enter the name of the database and any flags, and then click OK.
The database session is added under the Database Connection folder, and the connection is made.
You can open a session with the database that the application uses or any other database. It is not necessary for an application to be running to use this operation.
Open a New Session
You can open a new session with a database in the Database Connections portlet of the Query tab.
To open a new session with a database
1. Click the plus sign (+) to open the Connection Profiles or Database Connections folder.
If you opened the Connection Profiles folder, open a connection profile to display the database to which you want to connect.
2. Right-click the database you want to connect to, and select Connect from the pop-up menu.
The database session is started.
You now can enter query statements in the Database Queries portlet.
Specify One of the Sessions of the Current Application
You can specify a session with the currently executing application in the Database Connections portlet of the Query tab.
To specify one of the sessions of the currently executing application
1. Click the plus sign (+) next to the Running Applications folder.
OpenROAD displays any applications currently running.
2. Click the plus sign (+) next to the running application whose database session you want to use.
Each database session is listed by its session identifier and the database to which that session is connected.
3. Click the active database session.
4. Click OK.