Add a New Database Lookup

Add a Database Lookup to use the result set in the lookup.

To add a Database Lookup

1. In the Enterprise Console, click the Menu button, click Settings, and then click Lookup Settings. The Lookup Settings page appears.

2. Click New, and then click Database. The New Database Lookup dialog box appears.

3. In the Title box, type a name for the database lookup, and in the Description box, type a description for the database lookup.

4. Do one of the following:

   Task	Action
   Design the database lookup using a query.	In the Command Type list, click Query, and then click Continue. The New Database Lookup dialog box appears with additional options. Follow the steps for Add a New Database Lookup Using Query.
   Design the database lookup using a stored procedure.	In the Command Type list, click Stored Procedure, and then click Continue. The New Database Lookup dialog box appears with additional options. Follow the steps for Add a New Database Lookup Using Stored Procedure.

Note: Lookup title cannot have special characters and blank space. The only allowed special character is _ (underscore). Also, the Title starting with _SYS_ is not allowed.