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.