update

The update function enables information in Sterling B2B Integrator to be updated. This function is similar to the Update standard rule, except that it provides more flexibility. Only the tables and fields available in the Update standard rule are available for the update extended rule.

The update function also enables you to update process data with a string, instead of using the messagebox function. For information about the messagebox function, see messagebox.

In the command syntax, “expression” can be a string field, string variable, or string literal. It is important to note that the table and field names for the update extended rule are slightly different than those depicted in the standard rule. For a listing of these table and field names, see Select and Update Available Options.

Note: For the Transaction Register, the updates do not go directly to the database; they are kept in memory until the eventual select, and then they are checked against the database and inserted if necessary.

Syntax

Use this syntax:


update tablename set fieldname = expression [,fieldname =expression] where key 
= expression [and key = expression];

Note: If you are updating multiple fields, each “field = expression” term should be separated by a comma.

Example

An example of this function follows:


update processdata set xpathresult="hello world" where xpath="example";

Syntax for Updating Process Data with a String

Use this syntax:


update ProcessData set XPathResult = <some string> 
where Xpath = <location in process data>;

Example Updating Process Data with a String

An example of this function follows:


update ProcessData set XPathResult = #Sender
where XPath = "SenderID";