Try OpenEdge Now
skip to main content
Managed Adapters Guide
Database Managed Adapter : Working with the Database Adapter : Configuring the Database Adapter : Defining variables for the Database Adapter
 
Defining variables for the Database Adapter
To define variables:
1. After assigning the DBAdapter Managed Adapter as performer of a workstep, click the workstep to open its Properties view.
2. Open the Configuration tab and click the Configure button to display the Database Adapter Configurator GUI (You can alternatively use the DBAdapter.cmd|.sh script from the OEBPS_HOME/bin folder to invoke the Database Adapter Configurator GUI). The DBAdapter Configurator dialog box is displayed as shown in the following figure.
Note: You can also open the DBAdapter Configurator using the Managed Adapter Browser dialog box (available only from Progress Developer Studio for OpenEdge) functionality from the Tools > Managed Adapters menu. In addition to configuring, you can use the Managed Adapter Browser to perform functions like creating a copy, renaming, deleting, as well as importing and exporting the configuration information. For more information, refer to the "Using the Managed Adapter Browser" section of the OpenEdge Getting Started: Developing BPM Applications with Developer Studio.
If this is a new process, the SQL Statements List table is empty. If there are existing statements present, they are listed in the order they are to be executed. You can use Move Up and Move Down buttons to change the execution order.
3. Click Variables to open the Variable Definitions dialog box.
You can Add, Modify, and Remove variable definitions from this window.
4. Click Add to open the Variable Editor dialog box. You can also select a variable from the Variable Definition dialog box and click Modify to open the same box.
a. Enter the Variable Name.
b. Select the Type and Access from the drop-down list.
*The supported Java data types are String, Integer, Long, Boolean, Date, Object, and List.
*The supported access types are Input, Output, Input/Output, and Local.
c. You can optionally provide a Default value and Description for the variable. For Date datatype, the supported default value formats are "dd/mm/yy", "mm/dd/yy", "dd/mm/yy hh:mm", and "mm/dd/yy hh:mm." For Boolean datatype, if the default value is empty, it is considered as "false." Any other value, except "true" (non case-sensitive), is also considered as "false."
d. Click OK to return to the Variables Definitions dialog box. The added variable is now displayed in the variable list.
5. Click OK to return to the DBAdapter Configurator dialog box.