The EXTFNAPIV4_DESCRIBE_PARM_TABLE_NUM_ROWS attribute indicates the number of rows in the table. Used in a describe_parameter_get scenario.
Data Type
a_v4_extfn_estimate
Description
The estimated number of rows in the table. Only valid for argument 0 and table arguments.
Usage
Returns the estimated number of rows in the specified table argument or result set with a confidence of 100%.
Returns
On success, returns the size of a_v4_extfn_estimate.
On failure, returns one of the generic describe_parameter errors or:
- EXTFNAPIV4_DESCRIBE_BUFFER_SIZE_MISMATCH
– get error returned if the describe_buffer is not the size of a_v4_extfn_estimate.
- EXTFNAPIV4_DESCRIBE_INVALID_STATE – get error returned if the
query processing phase is not greater than Initial.
- EXTFNAPIV4_DESCRIBE_NON_TABLE_PARAMETER – get
error returned if the parameter is not a TABLE parameter.
Query Processing Phases
Valid in:
- Annotation phase
- Query Optimization phase
- Plan Building phase
- Execution phase