Home Starting Environment DBMS VisualPQL Procedures SQL Forms Host/API Index SQL Contents

1 Overview	Databases & Tabfiles Syntax Rules
2 SELECT	Output Aggregation Variable List FROM PATHS Joins Alias Keywords FORMAT Column References Column Formats GROUP BY ON ORDER BY OUTER UNION WHERE Subqueries
3 DISPLAY	EXCLUDE and INCLUDE Formatting Commands Headings and Footings Grouping and Totalling SUBTOTAL Break and Subtotal Columns TOTAL PRINT and WRITE
4 SET, SHOW and CLEAR	Parameter List
5 Control Commands	CALL CONNECT DATABASE CONNECT TABFILE CREATE ATTRIBUTE CREATE SYNONYM DISCONNECT DROP END GET Execution Statement Database Parameters Tabfile Parameters Environment Parameters
6 Menus	File Menu Connect database List of connected databases Database structure Create tabfile Connect tabfile List of connected tabfiles Tabfile structure Indexes Create index Select From What Where Order by Group by Verify tabfile Export tabfile Backup tabfile Restore tabfile
7 Data Entry and Modification	DELETE FROM ENTER INTO INSERT INTO UPDATE
8 Paths and Views	CREATE PATH CREATE VIEW
9 Tabfiles and Tables	CREATE TABFILE CREATE TABLE Column Data types Column Options CREATE INDEX Permissions GRANT REVOKE EXPORT VERIFY BACKUP TABFILE RESTORE TABFILE DISPLAY JOURNAL
10 SQL Functions	Standard Functions Aggregation functions
11 System Tables	$COL - Table Columns Schema $DBCASE - Database Case Schema $DBDOC - Database Documentation $DBSTATS - Database Statistics $INDEX - Tabfile Index Definitions $INDEXCOL - Tabfile Index Column Definitions $PASSWORD - Group User Names $REC - Database Record Schema $SECURITY - Tabfile and Table Permissions $SORTID - Sort Id Variables $TAB - Tables $TFSTATS - Tabfile Statistics $TRANGE - Tabfile Column Ranges $VALLABEL - Database Value Labels $VALUE_LABEL - Tabfile Value Labels $VALVALUE - Database Valid Values $VAR - Database Variables $VARLABEL - Database Variable Labels $SQLTYPE - Generic Data Type Information
12 Reserved Keywords
13 Pattern Matching