Working with Database Operations > Using the Database Operation File Editor > Database Operation Tab
	Database Operation Tab

For a query or insert operation on a table, you may need to adjust the columns that are affected by the operation without using the New Database Operation wizard to re-create the operation. For the Select operation, you can add another table to do a join, or to just add other columns from the same table. For the Insert operation, it makes sense to only add other columns from the same table as defined in the operation.

Use the following buttons below the table as follows:

• Add button - Upon clicking, a dialog window comes up with a list of data objects that you can select from, which comes from the same data source defined in the operation.

• Remove button - Upon clicking, whatever column selected in the table display is deleted.

Use the Database Operation tab of the Database Operation File Editor to:

• View basic information about the database operation file. See Viewing Basic Information.

• Remap variables to columns. See Remapping Variables to Columns.

• Determine the order in which return values are to be returned and sorted (Query operations only). See Determining Order for Return Results.

©2009, Avaya Inc. All rights reserved.