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.

ODXSQL Example

> set autofetch off
> select company, contact from customers where state='co'
Select statement processed
> fetch all

top