x64base

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.