Configuring a condition

To compose condition clauses, click Configure on the Options panel of the Inbound (Outbound) SQL Statement Configurator dialog box.

The Inbound (Outbound) SQL Statement Configurator dialog box can access all tables and views in the current database connection. All tables in the database are supported for select, insert, delete, and update statements.

Note:  The table schema you require might not be in the Inbound (Outbound) SQL Statement Configurator table schema list. If this happens, then you can insert/delete/update table schema from any connection and any table from the connection to meet your requirements.

The Table/View panel displays all the column names in the selected table/view. This is defined in the Inbound (Outbound) SQL Statement Configurator dialog box. Double-clicking an item appends the item name to the cursor location in the Condition panel.

The Outbound Staging Message Fields panel displays all field addresses in the currently selected outbound staging message format. This format is defined in the Database Outbound Protocol Properties dialog box.

Double-clicking an item appends the item name to the cursor location in the Condition panel. The name is enclosed in angle brackets.

The Column/Value panel displays the available columns and values for the selected table/view:

  • The Column displays the full column name in the format [table/view_name].[column_name].
  • Value can be edited. The default value is the corresponding value of Column in angle brackets. For example,<table1.column1>.

When you select an item from the Table/View Schema list, all related column items are automatically appended in the table.

Double-clicking a table row places the column's full name in the SQL text area.

The configured condition is displayed in the Condition field.