Create a Database Operation Page

Working with Database Operations > Using the Database Operation Wizard to Create a Database Operation File > Create a Database Operation Page

	Create a Database Operation Page

Configure the following settings in the Create a Database Operation page of the Database Operation Wizard.
Database Operation Wizard-Create a Database Operation Page Settings

Setting

Description
Available Projects

Select the project to which the database operation file will be applied.

Data Source name

Select the database (data source) to use for this operation.

Operation

Select the type of operation you want to perform. Options include:

Add - Takes the values of selected variables in Dialog Designer and creates a record in the database, populating the columns with the variable values.

Delete - Deletes designated records from the database.

Execute - Runs a procedure previously stored in the database.

Query - Retrieves the values of selected records in a database and assigns the values to variables in Dialog Designer.

Update - Updates the values of selected records in the database with new values from selected variables in Dialog Designer.

File name

Name identifying the database operation that describes the function of the database operation. For example, an operation to query a database for the account status for a caller might be called the QueryAcctStatus.

Note: Database operation file names must follow Java naming conventions (see Naming Java Components).
Open file for editing

To automatically open the Database Operation File Editor when you have completed creating the file within the Wizard, select this check box.

When you complete creating the database operation file with the Database Operation wizard, the database operation is not yet considered complete. You must use the Database Operation File Editor to further define and set parameters for the database operation

Database Operation Wizard-Create a Database Operation Page Settings
Setting	Description
Available Projects	Select the project to which the database operation file will be applied.
Data Source name	Select the database (data source) to use for this operation.
Operation	Select the type of operation you want to perform. Options include: Add - Takes the values of selected variables in Dialog Designer and creates a record in the database, populating the columns with the variable values. Delete - Deletes designated records from the database. Execute - Runs a procedure previously stored in the database. Query - Retrieves the values of selected records in a database and assigns the values to variables in Dialog Designer. Update - Updates the values of selected records in the database with new values from selected variables in Dialog Designer.
File name	Name identifying the database operation that describes the function of the database operation. For example, an operation to query a database for the account status for a caller might be called the QueryAcctStatus. Note: Database operation file names must follow Java naming conventions (see Naming Java Components).
Open file for editing	To automatically open the Database Operation File Editor when you have completed creating the file within the Wizard, select this check box. When you complete creating the database operation file with the Database Operation wizard, the database operation is not yet considered complete. You must use the Database Operation File Editor to further define and set parameters for the database operation

After configuring the settings, perform one of the following actions:

To select data objects for the database operation file, click Next. Dialog Designer displays the Select Data Objects Page.

To exit the Database Operation Wizard without creating the database operation file, click Cancel.