Inbound protocol read success/read failure action
If the type of read success action is SQL Statement, then clicking Read Success Action tab opens the Inbound (Outbound) SQL Statement Configurator dialog box. Based on the selected table schemas, you can configure the insert/update/delete SQL statement for the Read Success Action tab.
on theThe behaviors of Inbound (Outbound) SQL Statement Configurator dialog box for inbound protocol read action.
and are the same as the ones on the- If ColumnValue fields are available. is selected, then the
- If Value and Condition are available.
Clicking Value opens the Column List dialog box.
beside
is selected, then - If Condition is available. is selected, then
- Clicking composes the SQL statement according to the current setting.
- If the type is
insert into Schema Name (text_Column) values(text_Value)
, then a standard insert SQL
is composed:
- If the type is
update Schema Name set text_Value where text_Condition
, then a standard update SQL
is composed:
- If the type is
delete from Schema Name where text_Condition
, then a standard delete SQL
is composed:
- If the type is , then this indicates the inbound reply message format in the Database Outbound protocol.
For the update /insert/delete SQL, you can define dynamic or static values in the Values/Condition clause.
Read Failure Action tab has the same behavior as that of on the Read Success Action tab.
on the