Options panel

Schemas are automatically filled when the Inbound (Outbound) SQL Statement Configurator is opened. You can configure the schemas in this dialog box or when you make a query from the configured connection.

On the Column/Value panel, you can select the Column and Value to use.

  • Column indicates the full column name in [table/view name].[column name] format.
  • Value is editable. The default value is the corresponding value of Column enclosed with angle brackets. For example, <table1.column1>.

When selecting an item on the Table/View Schema list, all related column items are automatically appended to the table and all rows are checked by default.

When an item is cleared from the Table/View Schema list, the related columns are also removed from the table.

When double-clicking a row in the table, the corresponding column's full name is appended to the SQL text area.

From the toolbar, you can Move Up or Move Down as required, to change the table row sequence.

Condition panel

Select Configure to compose the condition clauses in the text area.

Type panel

This panel is used to select the SQL statement type. You can Insert, Update, Delete, or Select.

  • When Insert

    Only table-type schemas can be selected. You cannot use multiple schema selections.

    The standard SQL statement is composed. For example:

    insert into <checked table> (<checked column list>) values (<checked value list>)

    This becomes:

    insert into table1 (table1.column1, table1.column2) values (<table1.column1>, <table1.column1>)

    Generate>delete from <checked table> where <condition string> is enabled when the checked column list is not empty.

  • When Update is selected, the behavior of the Table/View schema list is identical to the is selected, the Condition panel does not display.Generate SQLInsert type.

    The standard SQL statement is composed. For example:

    update <selected table> set < checked column/value list> where < condition string>

    The selected column/value list is composed of column [0] = value [0], column [1] = value [1]

    For example:

    update table1 set table1.column1=<table1.column1>, table1.column2=<table1.column2> 
    where table1.column1=value1 and table1.column2=value2

    Generate SQL is enabled when the checked column list is not empty.

  • When Delete is selected, the Column/Value table does not display.

    Only table-type schemas can be selected. You cannot use multiple schema selections.

    The standard SQL statement is composed. For example:

    Generate>delete from <checked table> where <condition string>

    This becomes:

    delete from table1 where table1.column1=value1 and table1.column2=value2

    Generate SQL is enabled when the checked table list is not empty.

  • When Select is selected, column/value table label changes to Column. The Value column does not display.

    The standard SQL statement is composed. For example:

    select <checked column list> from <checked tables/view list> where < condition string>

    This becomes:

    select table1.column1, table1.column2, table2.column3 from table1, table2 
    where table1.column1=value1 and table1.column2=value3

    Generate SQL is enabled when the checked column list is not empty.

Message Panel

This panel is only used for the Database Outbound protocol.

The message format tree is generated by the outbound staging option that is configured in the Database Outbound Protocol Properties dialog box. When you double-click a message format tree node, the value that is enclosed with angle brackets is set to the Value cell of the selected row in the Column/Value table. If no component is selected, then it is appended to the SQL text area.

When Whole Message is selected, the <whole_message> string is set to the Value cell of the selected row in the Column/Value table. If no component is selected, then it is appended to the SQL text area.