INVOKE: Example 2

Previous Next

See Also

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

UPDATE    <table>

SET    colX =

(INVOKE <component>.<method>)

WHERE    <condition Y>

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