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 Value to use.
and- [table/view name].[column name] format. indicates the full column name in
- Value is editable. The default value is the corresponding value of 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
or as required, to change the table row sequence.Condition panel
Select
to compose the condition clauses in the text area.Type panel
This panel is used to select the SQL statement type. You can Insert, , , or .
- When
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>)
is enabled when the checked column list is not empty.
- When
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
is enabled when the checked column list is not empty.
is selected, the behavior of the
Table/View schema list is identical to the is selected, the Condition panel
does not display.Generate
SQL type. - When
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
is enabled when the checked table list is not empty.
is selected, the Column/Value table does not display. - When
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
is enabled when the checked column list is not empty.
is selected, column/value table label changes to Column. The Value
column does not display.
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>
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.