How Parameters are Passed To and From Components
How parameters are passed to and from components depends on the sequence number and kind of parameter, and on the SQL syntax that the INVOKE clause is used in. The following example illustrates this:
SET (col1, col2) =
INVOKE MyComponent.MyMethod WITH
SELECT colX, colY, colZ
The following table shows the parameters defined for "MyMethod" and how they are used:
This example shows that the Return parameter is handled as if it were an Out parameter.
NOTE: This example shows the rules underpinning parameter use. It is usually a good idea to define In parameters before Out parameters, and Out parameters before the Return parameter.