Managing Fulfilment Actions

To manage the actions that Syntelate XA should perform against records returned by your SQL Select statement, use the Fulfilment actions section of the Fulfilment details page.

Adding a Fulfilment Action

To add a Fulfilment action, follow these steps:

  1. In the Fulfilment actions section, click Add. The Creating fulfilment action page is shown.

  2. In the Sequence box, type the sequence number of the Fulfilment action. For example, if Syntelate XA should perform this Fulfilment action first (before any other Fulfilment actions), type 1.

    Tip: You can also click Up or Down to change the sequence number. Alternatively, you can edit the sequence from the Fulfilment details page, where you can see the full list of Fulfilment actions.

    Note: If you enter a sequence number that is already used by another Fulfilment action, Syntelate Studio will automatically change the sequence number of the other Fulfilment action as well as that of any other affected Fulfilment actions.

  3. In the Action Name box, type a name for the Fulfilment action.
  4. In the Database name dropdown, select the database against which the Fulfilment action should be performed.

  5. In the SQL statement box, type your SQL statement.

    Tip: Under synTelate's SQL Functions, you can double-click a function to add it to your SQL statement. For more information, see synTelate's SQL Functions.

    To check whether your SQL is valid, click Check SQL. A dialog box appears telling you either that your SQL is valid or else reporting an error.

  6. Click Save.

Editing a Fulfilment Action

To edit a Fulfilment action, follow these steps:

  1. From the Fulfilment actions section, click Edit for the Fulfilment action that you want to edit. The Editing fulfilment action page is shown.
  2. Edit the Sequence, Action Name, Database name, and/or SQL statement as necessary.
  3. Click Save.

Tip: If you just want to edit the sequence number of a Fulfilment action, you can do this from the Fulfilment details page by clicking Up or Down for the Fulfilment action.

Deleting a Fulfilment Action

To delete a Fulfilment action, follow these steps:

  1. From the Fulfilment actions section, click Delete for the Fulfilment action that you want to delete. The Confirm Delete dialog box appears.
  2. Click Delete.