VMS Help  —  SQLPRE72  SQLPRE Command Line, Arguments  QUERY_ESTIMATES
    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.
Close Help