INVOKE: Example 2

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.