Documentation / Command families
Command families
One shell, grouped by the job each group of commands does.
x64base is one engine with one shell. The names below are groupings for readability, not separate products — nothing here is downloaded, versioned, or licensed on its own.
Tables and work areas
USE SELECT AREA DBAREA DBAREAS STRUCT FIELDS
Open a table into a numbered area, inspect its structure, and move between areas.
Navigation
TOP BOTTOM SKIP GOTO RECNO SEEK FIND LOCATE
Move the cursor by position, by key, or by condition.
Order and scope
SET INDEX / ORDER / FILTER / RELATION / PARALLEL / INDEXTXN
Choose which index drives the order, restrict what is visible, declare how tables relate, and set scan and transaction behavior.
Mutation
REPLACE CALC CALCWRITE MULTIREP COMMIT ROLLBACK
Change field values under buffering, then commit or discard.
Relations and rows
REL RELATIONS ERSATZ TUPLE TUPEXPORT WORKSPACE
Walk a declared relation graph, project rows, and save or restore a whole workspace.
Listing and browsing
LIST SMARTLIST BROWSE SMARTBROWSER SIMPLEBROWSER
Read records at the terminal, from a one-line dump to a full browser. SB is a shortcut for SIMPLEBROWSER.
Query
SQLSEL SQLITE DDL
SQLSEL is the SELECT/INSERT/UPDATE/DELETE statement surface; SQLITE reaches the companion carrier. SQL itself is a reserved word and runs nothing.
Import and export
IMPORT EXPORT IMPORTSQL EXPORTSQL COPY
Move data between DBF, delimited files, and SQLite.
Help and metadata
HELP CMDHELP CMDHELPCHK MAINT DDICT MANUAL BBOX
Ask the running system what it knows about itself, including a checker for help that has drifted.
Teaching
ASCII SHELLO RETRO IDX COBOL CODASYL NORMALIZE
Labs that make a layer visible instead of describing it.
Utility
EDIT TEXT IMAGE WEB SFTP ZIP PSHELL
Ordinary conveniences so a session does not have to leave the shell.
Verification
REGRESSION
Run the engine's own registered proofs -- the same specs this site cites as evidence.
The shell can also answer questions about itself at runtime: HELP and
CMDHELP describe commands, DDICT reports metadata, and
CMDHELPCHK checks help text that has drifted away from the code it documents.