QUERY

Restriction: This topic applies to Windows environments only.

Used to hold an SQL SELECT statement that the export is based on. The syntax is:

QUERY = SELECT dept, dname, mgr FROM dept 
WHERE dname = "sales" AND mgr > 5;

In the syntax example above, the dept, dname, and mgr fields are selected from the DEPT table only when the dname field is equal to sales and the mgr field is greater than five. This allows specific information to be exported from the selected table.