select

The select function enables information to be retrieved from Sterling B2B Integrator. Only the tables and fields available in the Select standard rule are available for the select extended rule.

In the command syntax, “expression” and “receiverlist” can be a string field, string variable, or string literal. It is important to note that the table and field names for the select 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.

select fieldname into receiverlist from tablename where key =
expression [and key = expression];

string[50] var;
select xpathresult into var from processdata where xpath="example";