The Integrator Setparm output object allows parameters to be set for later tasks in the Integrator script. The Setparm output object expects a single row containing values for the DI object language parameters to be set. If the Setparm encounters multiple rows, an error will occur. It is similar to the Iterate output object, except that it sets the parameters once and makes them available to subsequent tasks in the Integrator script as opposed to running another task. The parameters need to be declared in the "parms" PARM object.
The Setparm output object is useful for Tunnel scripts where the parameters to be set need to be calculated based on values passed into the tunnel. The first task of the Tunnel can be a task that has the Setparm output object, setting parameters that can be used in subsequent tasks.
Setparm Attributes
| Attribute | Type | Description |
|---|---|---|
| output_type (required) |
String | Identifies the object as a Setparm output object. The value of the string is "setparm". |
| input (required) |
String | Defines the object from which the data flow is arriving. |
| parameters (required) |
Array of Strings | Defines the columns that will be used to set parameter values for the remaining tasks. The column names must match the parameter names defined in the "parms" PARM object. |
| trace_before | Sub-object | Traces data flows entering the specified object. This is equivalent to adding the Trace process object immediately before the current output object. See Embedded Trace Object. |