Reference card

Keywords

Aabs acos aj aj0 all and any asc asin asof atan attr avg avgs
Bbin binr
Cceiling cols cor cos count cov cross csv cut
Ddelete deltas desc dev differ distinct div do dsave
Eeach ej ema enlist eval except exec exit exp
Ffby fills first fkeys flip floor
Gget getenv group gtime
Hhclose hcount hdel hopen hsym
Iiasc idesc if ij ijf in insert inter inv
Kkey keys
Llast like lj ljf load log lower lsq ltime ltrim
Mmavg max maxs mcount md5 mdev med meta min mins mmax mmin mmu mod msum
Nneg next not null
Oor over
Pparse peach pj prd prds prev prior
Rrand rank ratios raze read0 read1 reciprocal reval reverse rload rotate rsave rtrim
Ssave scan scov sdev select set setenv show signum sin sqrt ss ssr string sublist sum sums sv svar system
Ttables tan til trim type
Uuj ujf ungroup union update upper upsert
Vvalue var view views vs
Wwavg where while within wj wj1 wsum
Xxasc xbar xcol xcols xdesc xexp xgroup xkey xlog xprev xrank

.Q.id (sanitize), .Q.res (reserved words)

Operators

@
.
Apply
Index
Trap
Amend
$Cond
Cast
Tok
Enumerate
Pad
mmu
!Dict
Enkey
Unkey
Enumeration
Flip Splayed
Display
internal
Update
Delete
?Find
Roll, Deal
Enum Extend
Select
Exec
Simple Exec
Vector Conditional
+Add -Subtract *Multiply %Divide
=
<>
Equals
Not Equals
<
<=
Less Than
Up To
>
>=
Greater Than
At Least
~Match
| Greater, OR & Lesser, AND
#Take
Set Attribute
_Cut
Drop
^Fill ,Join

Overloaded operator glyphs

Iterators

accumulatorsmapsmaps
/
\
Over
Scan
/:
\:
Each Right
Each Left
'
':
':
Each
Each Parallel
Each Prior
'
'
Case
Compose

Other

\\
\
\x
'
quit
abort
system cmd
Signal
:
::
assign, return
identity
generic null

global amend
set view
0
1, -1
2, -2
n, -n
console
stdout
stderr
handle
0:
1:
2:
File Text
File Binary
Dynamic Load
()
(;)
([]…)
precedence
list
table
[;]expn block
argt list
{}
;
lambda
separator
`
`:
symbol
filepath

Attributes

`s  sorted     `u  unique
`p  parted     `g  grouped

Command-line options and system commands

file
\atables\rrename
-bblocked-s \sslaves
\b \Bviews\Srandom seed
-c \cconsole size-t \ttimer ticks
-C \CHTTP size\tstime and space
\cdchange directory-T \Ttimeout
\ddirectory-u -U \uusr-pwd
-e \eerror traps-udisable syscmds
-ETLS Server Mode\vvariables
\ffunctions-w \wmemory
-g \ggarbage collection-W \Wweek offset
\lload file or directory\xexpunge
-l -Llog sync-z \zdate format
-o \oUTC offset\1 \2redirect
-p \pmultithread port\_hide q code
-P \Pdisplay precision\terminate
-qquiet mode\toggle q/k
-r \rreplicate\\quit

Command-line options, System commands, OS Commands, system

Datatypes

ncnameszliteralnullinfSQLJava.Net
0*list
1bboolean10bBooleanboolean
2gguid160NgUUIDGUID
4xbyte10x00Bytebyte
5hshort20h0Nh0WhsmallintShortint16
6iint40i0Ni0WiintIntegerint32
7jlong80j or 00Nj
or 0N
0Wj
or 0W
bigintLongint64
8ereal40e0Ne0WerealFloatsingle
9ffloat80.0 or 0f0n0wfloatDoubledouble
10cchar1" "" "Characterchar
11ssymbol.``varcharStringstring
12ptimestamp8dateDtimespan0Np0WpTimestampDateTime (RW)
13mmonth42000.01m0Nm
14ddate42000.01.010Nd0WddateDate
15zdatetime8dateTtime0Nz0wztimestampTimestampDateTime (RO)
16ntimespan800:00:00.0000000000Nn0WnTimespanTimeSpan
17uminute400:000Nu0Wu
18vsecond400:00:000Nv0Nv
19ttime400:00:00.0000Nt0WttimeTimeTimeSpan
20-76enums
77anymap
78-9677+t – mapped list of lists of type t
97nested sym enum
98table
99dictionary
100lambda
101unary primitive
102operator
103iterator
104projection
105composition
106v'
107v/
108v\
109v':
110v/:
111v\:
112dynamic load

n: short int returned by type and used for casting, e.g. 9h$3 c: character used lower-case for casting and upper-case for Load CSV sz: size in bytes inf: infinity (no math on temporal types); 0Wh is 32767h v: applicable value RO: read only; RW: read-write

Nested types are 77+t (e.g. 78 is boolean. 96 is time.)

Cast $: where char is from the c column above char$data:CHAR$string

dict:`a`b!…
table:([]x:…;y:…)
date.(year month week mm dd)
time.(minute second mm ss)
milliseconds: time mod 1000

Namespaces

.h

Markup output for HTTP

.h.brlinebreak.h.huURI escape
.h.c0web color.h.hugURI map
.h.c1web color.h.hyHTTP response
.h.cdCSV from data.h.iso8601ISO timestamp
.h.codecode after Tab.h.jxtable
.h.edExcel from data.h.logoKx logo
.h.edsnExcel from tables.h.nbrno break
.h.framframe.h.prepre
.h.haanchor.h.sastyle
.h.hbanchor target.h.sbstyle
.h.hcescape lt.h.scURI-safe
.h.heHTTP 400.h.tdTSV
.h.hnHTTP error.h.textparagraphs
.h.hpHTTP response.h.txfiletypes
.h.hrhorizontal rule.h.tyMIME types
.h.htMarqdown to HTML.h.uhURI unescape
.h.htastart tag.h.xdXML
.h.htacelement.h.xmpXMP
.h.htcelement.h.xsXML escape
.h.htmldocument.h.xtJSON
.h.httphyperlinks

.j

De/serialize as JSON

.j.jserialize.j.kdeserialize

.Q

Utilities: general, environment, IPC, datatype, database, partitioned database state, segmented database state, file I/O

.Q.alower-case alphabet .Q.j10encode binhex
.Q.Aupper-case alphabet .Q.x10decode binhex
.Q.addmonths .Q.j12encode base64
.Q.addrIP address .Q.x12decode base64
.Q.btbacktrace .Q.kversion
.Q.btoab64 encode .Q.lload
.Q.bvbuild vp .Q.Mlong infinity
.Q.chkfill HDB .Q.MAPmaps partitions
.Q.cncount partitioned table .Q.optcommand parameters
.Q.Cfcreate empty nested char file .Q.parlocate partition
.Q.Dpartitions .Q.pdmodified partition locations
.Q.ddjoin symbols .Q.pfpartition field
.Q.def .Q.pnpartition counts
.Q.dpftsave table .Q.ptpartitioned tables
.Q.dpftssave table with symtable .Q.pvmodified partition values
.Q.dsftgload process save .Q.Psegments
.Q.enenumerate varchar cols .Q.PDpartition locations
.Q.ensenumerate against domain .Q.PVpartition values
.Q.fformat .Q.qpis partitioned
.Q.fcparallel on cut .Q.qtis table
.Q.ffappend columns .Q.reskeywords
.Q.fkforeign key .Q.splain text
.Q.fmtformat .Q.sbtstring backtrace
.Q.fpsstreaming algorithm .Q.sha1SHA-1 encode
.Q.fsstreaming algorithm .Q.trpextend trap
.Q.fsnstreaming algorithm .Q.tstime and space
.Q.ftapply simple .Q.tytype
.Q.fuapply unique .Q.udate based
.Q.gcgarbage collect .Q.vvalue
.Q.hdpfsave tables .Q.Vtable to dict
.Q.hgHTTP get .Q.viewsubview
.Q.hosthostname .Q.vpmissing partitions
.Q.hpHTTP post .Q.wmemory stats
.Q.idsanitize .Q.xnon-command parameters
.Q.indpartitioned index .Q.Xfcreate file

.z

System variables, callbacks

.z.aIP address .z.piinput
.z.acHTTP auth from cookie .z.pmHTTP options
.z.bdependencies .z.poopen
.z.bmmsg validator .z.ppHTTP post
.z.ccores .z.pqqcon
.z.eTLS connection status .z.psset
.z.exfailed primitive .z.pwvalidate user
.z.exitaction on exit .z.qquiet mode
.z.eyargument to failed primitive.z.sself
.z.ffile .z.tstimer
.z.hhost .z.uuser ID
.z.iPID .z.vsvalue set
.z.Kversion .z.Whandles
.z.krelease date .z.whandle
.z.llicense .z.wcwebsocket close
.z.Nlocal timespan .z.wowebsocket open
.z.nUTC timespan .z.wswebsockets
.z.oOS version .z.Xraw command line
.z.Plocal timestamp .z.xargv
.z.pUTC timestamp .z.Zlocal datetime
.z.pcclose .z.zUTC datetime
.z.pdpeach handles .z.zdzip defaults
.z.pgget .z.T|t|D|dtime/date shortcuts
.z.phHTTP get