|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.|