Syntax options:
SQLOPTIONS= (QUERY_ESTIMATES)
SQLOPTIONS= (NOQUERY_ESTIMATES)
Specifies whether or not SQL returns the estimated number
of rows and estimated number of disk I/O operations in
the SQLCA structure. If you specify the QUERY_ESTIMATES
keyword, SQL returns the estimated number of rows in the field
SQLCA.SQLERRD[2] and the estimated number of disk I/O operations
in the field SQLCA.SQLERRD[3]. The value of SQLCA.SQLERRD[2]
and SQLCA.SQLERRD[3] is normally 0 after you execute an OPEN
statement for a table.
The SQLOPTIONS=QUERY_ESTIMATES qualifier is the default.