Query

Restriction: This topic applies to Windows environments only.

A query is a SELECT command that generates a result table or an intermediate result table. A query may be a subcomponent of another type of SQL statement, such as an INSERT or CREATE VIEW command. A nested query may also be part of a search condition. There are three forms of a query: subselect, fullselect and select-statement. For more information on these three query forms (as well as the SELECT INTO statement), see the SELECT command in SQL Commands. See also SELECT Clause, FROM Clause, and WHERE Clause. Queries are not named data objects, however XDB Server provides special facilities for saving and recalling queries as though they were named objects. Also, when writing programs containing embedded SQL, queries are usually associated with a cursor, which can be equated with a query name in the scope of the program.