Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Data Archive Reference

Statement execution output

  • Last UpdatedJan 13, 2023
  • 1 minute read

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.

TitleResults for “How to create a CRG?”Also Available in