Configuring a condition
To compose condition clauses, click Inbound (Outbound) SQL Statement Configurator dialog box.
on the Options panel of theThe 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.
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.