The DB Read Step

Continue the database.aef script by dragging a DB Read step from the Database palette into the Design pane.

Configure the DB Read step to use SQL (Structured Query Language) commands to read the physician_locator table in the specified database.

Figure shows the configured General tab of the DB Read customizer window.

DB Read Customizer Window—Configured General Tab

Configure the General tab of the DB Read customizer window as follows:

  • DB Resource Name—getPhysicians

    This choice names the query that is used by the subsequent DB Get step to read data from the database.

  • Data Source Name—ALPINE00

    This choice specifies the database that contains the desired information.

Figure shows the configured Field Selector tab of the DB Read customizer window.

DB Read Customizer Window—Configured Field Selector Tab

Configure the Field Selector tab as follows:

  • Enter the SQL command select * from physician_locator, which tells the DB Read step to read all the data that exists in the physician_locator table.

The DB Read step has three output branches, Successful, Connection Not Available, and SQL Error.