These use the real DotTalk++ command surface (see the
Command Catalog). They assume the sample
STUDENTS table with fields such as FNAME, LNAME, MAJOR, and GPA.
Open, inspect, and list
USE STUDENTS
STRUCT
COUNT
LIST NEXT 5 FNAME, LNAME, MAJOR, GPA
Filter and aggregate a subset
USE STUDENTS
SET FILTER TO MAJOR = "CSCI"
COUNT
AGGS ALL GPA
SET FILTER TO
AGGS ALL returns COUNT / SUM / AVG / MIN / MAX in a single scan. SET FILTER TO with no argument clears the filter.
Order, then seek
USE STUDENTS
CDX CREATE
INDEX ON LNAME TAG LNAME
BUILDLMDB
SET ORDER TO LNAME
SEEK "Quinn"
DISPLAY
SEEK on the active CDX tag uses the LMDB keyed range-seek (O(log n)); ordered
navigation (TOP, BOTTOM, SKIP) reads the index cursor directly.
Copy a filtered projection to a new table
USE STUDENTS
SET FILTER TO GPA >= 3.5
COPY TO HONORS FIELDS FNAME, LNAME, MAJOR, GPA
SET FILTER TO
USE HONORS
COUNT
Run it as a script
Save any of the above as a .dts file and run it through the DotScript runner —
the repeatable form of the command language. See the
DotScript Language Guide.