|
| Command | | (Required) When this is an attribute of Procedure.SP, provide the name of a Stored Procedure that returns a single or no values. Use this element for procedures that execute UPDATEs, INSERTs, and other database actions.
When this is an attribute of DataLayer.SP, provide the name of a Stored Procedure that returns a result set of some number of data rows.
If working with Oracle Packages, provide the Package name, then a period, then the Procedure name. For example, "myPackage.myProcedure".
|
| ConnectionID | | Specifies a connection to a data source that is defined in the Settings.
For elements connecting to relational databases, default is the first Connection element in _settings.lgx. |
| ExceptionDataID | | Defines an ETL ID value that can be used to address the exception data that was removed by the filter.
The value of this attribute may be referenced by a DataLayer.ETL, LoadDbTable, SaveData, or any other element that supports the EtlElementID attribute. |
| ExecuteType | | Method used to call the stored procedure.
(default) Standard method is used for record sets.
Scalar returns a single value, which is one row with one column. |
| ID | | (Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition. |
| MaxRows | | The maximum number of rows to retrieve from the data source. |