The DB Release Step

Continue the No Data output branch of the DB Get step by dragging a DB Release step from the Database palette to the Design pane, and dropping it over the DB Write step icon under the No Data output branch of the DB Get step icon, as shown in figure database.aef script.

Then configure the DB Release step to close the SQL query and release the allocated resources.

The system returns the released DB connection to the connection pool, and no longer associates data with this connection.

Figure shows the configured DB Release customizer window.

Configured DB Release Customizer Window

In the DB Resource Name text field, specify getPhysicians as the DB Resource to be released.