QUERY-LANGUAGE menu options
The QUERY-LANGUAGE menu options for the dbaccess command represent short cut keys for the QUERY-LANGUAGE menu.
- -qc
- Chooses the Choose option on the SQL menu.
- -qd
- Chooses the Drop option on the SQL menu.
- -qi
- Chooses the Info option on the SQL menu. With this option, you
can add another letter as shown in the following list (and specify
a table) to go to the next menu level and view:
- -qic
- Columns in the table
- -qif
- Information about fragmentation strategy for the table
- -qig
- Information about triggers in the table
- -qii
- Indexes on the table
- -qio
- Table constraints
- -qip
- Access privileges on the table
- -qir
- Table-level references privilege on the table
- -qis
- Table status information
If you do not include a table name with the -qi option, you must choose one from the INFO FOR TABLE screen.
- -qm
- Chooses the Modify option on the SQL menu.
- -qn
- Chooses the New option on the SQL menu.
- -qs
- Chooses the Save option on the SQL menu.
- -qu
- Chooses the Use-editor option on the SQL menu.
If you do not include a database name before a -q option, you must choose a current database from the SELECT DATABASE screen.
When you select the Modify option on the QUERY-LANGUAGE menu, you
must first select a command file to modify from the CHOOSE menu. The
MODIFY screen is then displayed and shows the text.
Restriction: You cannot go directly to the Run or Output option
on the SQL menu. Trying to do so results in an error message.