SIGNON

(Required.) Specifies the user ID and password (if any).

Both

OPTION DDBASE=

Names the database ID of the Datadictionary database if different from the default.

Both

OPTION QUERYLANG=

Specifies language to use if user is authorized for both. Otherwise the last online mode at signoff will be used.

Both

OPTION AUTHID=

Specifies the authorization ID to be used in the query.

SQL

OPTION DIAGNOSTICS=

With option CBS, tells CA Dataquery to produce Compound Boolean Selection diagnostic reports. If option RQT is used, this statement should follow FIND or EXECUTE.

DQL

OPTION PLANOPTS,MSG=

Tells CA Datacom/DB whether to produce detail or summary messages about preparation and execution time.

SQL

OPTION PLANOPTS,DISPLAY=

Tells CA Datacom/DB whether to print preparation and execution time messages during execution.

SQL

OPTION PLANOPTS,OPT=

Tells CA Datacom/DB whether to use user-specified join order or SQL-chosen join order.

SQL

OPTION STATISTICS=ON

Provides statistical information on execution.

Both

OPTION WINDOWING=NO

Specifies WRAP (NO) or NOWRAP (YES) selections for reports.

Both

OPTION QUERYTEXT=YES

Prints text of query.

Both

OPTION PAGESTOGETHER=YES

Print report pages together (YES) or print front pages and then back pages (NO).

Both

SELECT, UPDATE, DELETE, and INSERT

SQL query keywords. Each must be on a separate line.

SQL

FIND and COUNT

DQL query keywords.

DQL

EXECUTE

(Required.) Executes the query or dialog named in the statement.

Both

EXPORT

Exports data found by the query to a sequential file.

Both

STORE

Creates a new Personal Database Facility table containing query or dialog output.

Both