ODXSQL - Commands - SET Options

AUTOFETCH

SET AUTOFETCH <ON | OFF>

By default, OdxSQL will automatically fetch and display rows qualified in a SQL SELECT statement. This behavior can be turned on and off with the AUTOFETCH set option.

If AUTOFETCH is set to OFF, a SQL select statement must be followed by a FETCH command to actually retrieve and display the data, an EXPORT command to export the data to a file, or another command like ASSIGNVALUES.

AUTOFETCH must be set to OFF if using ASSIGNVALUES, DESCRIBE, or BIND.

Example

> set autoexplain on
> select company, contact from customers where company='systems'
----------------------------------- SUMMARY -----------------------------------
Select COMPANY, \
       CONTACT \
from   CUSTOMERS \
where  COMPANY = 'systems'

Version: 4.0 Build 8G (Compiled Jan 30 2004 12:50:07)
Optimization: MDKQUAL
----------------------------------- DETAILS -----------------------------------
Qualify (CUSTOMERS)CUSTOMERS where COMPANY = 'systems' on 1 with NOAUTORESET
Fetchkeys $ROWID 1000 at a time on 1
Retrieve CUSTOMERS using $ROWID = $ODXID
Return CUSTOMERS.COMPANY, CUSTOMERS.CONTACT
-------------------------------------------------------------------------------

Top