Statement execution output
- Last UpdatedJan 13, 2023
- 1 minute read
- PI System
- PI Server
Output lines are of the form:
Execute[HandleNum]>[ErrorCode][ElapsedTime] Parameters: NParams Columns: Ncols Rows: Nrows
If the number of run-time parameters is non-zero, this message is followed by one line for every provided parameter:
Pnn [DataType Length] parameter_value
where nn is the run-time parameter number, starting with 0.
For example, the Execution message following the above Prepare message might read:
Execute[1]>[0][0.041s] Parameters: 1 Columns: 4 Rows: 16
P00 [time32] 21-Jul-97 00:00:00
The query in this example returned 16 rows of 4 columns. The query was provided with one run-time parameter: a time stamp.