INVOKE: Example 2

Previous Next

The following statement can be issued from SQL Command to insert into column a constant provided or calculated by an external component:

UPDATE    table
SET       column =
(
     INVOKE component.method
)
WHERE    condition

The component is invoked once for each record that satisfies condition.

 

See also

When and how many times a component is invoked