[dbo].[writeCurrentData] stored procedure
- Last UpdatedJun 20, 2025
- 1 minute read
The writeCurrentData and resetCurrrentDates routines allow the SCADA system to record various currentData items that were uploaded that have not been aggregated to a granularity row and sent to AVEVA Measurement Advisor.The information sent is protocol-specific.
In order to perform these routines, you will need to be assigned the Meas Data Entry permission.
|
Internal Field (Parameter) Name |
Field req'd? |
Data Type (alias, SQL data type) |
Description |
|---|---|---|---|
|
@objectId |
Y |
T_tagIDType, int |
The ID number associated with the object. |
|
@valueType |
Y |
T_nameType, nvarchar(32) |
This is the identifer of the value. For example, Temperature, Static Pressure, or Energy. |
|
@valueValue |
Y |
T_singlePrecisionType, real |
This is the value of the type. |
|
@ownSysId |
N |
T_tagIDType, int |
This is set to the CD_OWNSYSID of the system on which the procedure is run. It is recommended that you do not provide a value for this entry, and let the system set the value. |
|
@datasetId |
N |
T_tagIDType, int |
The datasetId configured for the object. The @datasetId will get set to the dataset configured for the object if it is not specified. |