In the workbench, you can use database connections in two
ways:
- When you develop your programs. For example, you need this connection
when you use the EGL SQL retrieve feature; for more information, see Setting preferences for SQL retrieve.
- When you run or debug your programs.
To create a new connection by using the New Connection wizard,
see Creating an SQL database connection, or complete
the following steps to set up or edit the connections:
- Click .
- When a list of preferences is displayed, expand EGL and
click SQL Database Connections.
- The currently selected connection in the Connection list
is the default database for EGL in the workbench. In this window,
you can switch between database connections, edit or delete the connections,
and test the connections.
- To create a new connection, click New.
For an explanation of the preference fields, see Fields in the New Connection wizard.
- If you are using IBM® DB2®, you might need to set the Secondary
Authentication ID field.For more information, see "Secondary
Authentication ID" in this topic.
You can clear or apply preference settings:
- To restore default values, click Restore Defaults.
- To apply preference settings without exiting the Preferences window,
click Apply.
- If you are finished setting preferences, click OK.