Inbound protocol read success/read failure action

If the type of read success action is SQL Statement, then clicking Configure on the 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.

The behaviors of Select and Configure are the same as the ones on the Inbound (Outbound) SQL Statement Configurator dialog box for inbound protocol read action.

  • If Insert is selected, then the ColumnValue fields are available.
  • If Update is selected, then Value and Condition are available.

    Clicking Select beside Value opens the Column List dialog box.

  • If Delete is selected, then Condition is available.
  • Clicking OK composes the SQL statement according to the current setting.
  • If the type is Insert, then a standard insert SQL is composed:
    insert  into Schema Name (text_Column)  values(text_Value)
  • If the type is Update, then a standard update SQL is composed:
    update  Schema Name  set text_Value where text_Condition
  • If the type is Delete, then a standard delete SQL is composed:
    delete from  Schema Name  where text_Condition
  • If the type is Select, 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.

Configure on the Read Failure Action tab has the same behavior as that of Configure on the Read Success Action tab.