In multiple-developer environments where several programmers are developing ESL applications, duplicate naming of ESL objects and action routines often occurs.

To reduce the likelihood of generating duplicate action routine names from DB/Assist, do the following:

•Use descriptive SQL statement names.

•Check the Add SQL Access Module name to action routine names check box in the Code Generation Options dialog box.

DB/Assist uses the SQL statement name as part of the action routine name. For example, an INSERT statement named InsertStaff generates an action routine named EXECUTE_InsertStaff. Therefore, assigning meaningful statement names can ensure that the resulting action routine names are unique.

If you check the Add SQL Access Module name to action routine names check box in the Code Generation Options dialog box, DB/Assist adds the SAM name to all generated action routines in that SAM This helps ensure unique action routine names throughout your application.

For example, if the InsertStaff statement is part of a SAM named ADMIN, checking this option generates an action routine named EXECUTE_InsertStaff_ADMIN.