Skip to content

Reference card

Keywords

A abs acos aj aj0 ajf ajf0 all and any asc asin asof atan attr avg avgs
B bin binr
C ceiling cols cor cos count cov cross csv cut
D delete deltas desc dev differ distinct div do dsave
E each ej ema enlist eval except exec exit exp
F fby fills first fkeys flip floor
G get getenv group gtime
H hclose hcount hdel hopen hsym
I iasc idesc if ij ijf in insert inter inv
K key keys
L last like lj ljf load log lower lsq ltime ltrim
M mavg max maxs mcount md5 mdev med meta min mins mmax mmin mmu mod msum
N neg next not null
O or over
P parse peach pj prd prds prev prior
R rand rank ratios raze read0 read1 reciprocal reval reverse rload rotate rsave rtrim
S save scan scov sdev select set setenv show signum sin sqrt ss ssr string sublist sum sums sv svar system
T tables tan til trim type
U uj ujf ungroup union update upper upsert
V value var view views vs
W wavg where while within wj wj1 wsum
X xasc xbar xcol xcols xdesc xexp xgroup xkey xlog xprev xrank

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

Operators

@
.
Apply
Index
Trap
Amend
$ 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
Coalesce
,
'
Join
Compose

Overloaded glyphs

Iterators

Execution control

Debugging

Other

Attributes

g grouped p parted s sorted u unique

Set Attribute

Command-line options and system commands

file
\a tables \r rename
-b blocked -s \s secondary processes
\b \B views \S random seed
-c \c console size -t \t timer ticks
-C \C HTTP size \ts time and space
\cd change directory -T \T timeout
\d directory -u -U \u usr-pwd
-e \e error traps -u disable syscmds
-E \E TLS server mode \v variables
\f functions -w \w memory
-g \g garbage collection -W \W week offset
\l load file or directory \x expunge
-l -L log sync -z \z date format
-o \o UTC offset \1 \2 redirect
-p \p listening port \_ hide q code
-P \P display precision \ terminate
-q quiet mode \ toggle q/k
-r \r replicate \\ quit

system
Command-line options, System commands, OS commands

Datatypes

n   c   name      sz  literal            null inf SQL       Java      .Net
\------------------------------------------------------------------------------------
0   *   list
1   b   boolean   1   0b                                    Boolean   boolean
2   g   guid      16                     0Ng                UUID      GUID
4   x   byte      1   0x00                                  Byte      byte
5   h   short     2   0h                 0Nh  0Wh smallint  Short     int16
6   i   int       4   0i                 0Ni  0Wi int       Integer   int32
7   j   long      8   0j                 0Nj  0Wj bigint    Long      int64
                      0                  0N   0W
8   e   real      4   0e                 0Ne  0We real      Float     single
9   f   float     8   0.0                0n   0w  float     Double    double
                      0f                 0Nf
10  c   char      1   " "                " "                Character char
11  s   symbol        \`                  \`        varchar   String    string
12  p   timestamp 8   dateDtimespan      0Np  0Wp           Timestamp DateTime (RW)
13  m   month     4   2000.01m           0Nm
14  d   date      4   2000.01.01         0Nd  0Wd date      Date
15  z   datetime  8   dateTtime          0Nz  0wz timestamp Timestamp DateTime (RO)
16  n   timespan  8   00:00:00.000000000 0Nn  0Wn           Timespan  TimeSpan
17  u   minute    4   00:00              0Nu  0Wu
18  v   second    4   00:00:00           0Nv  0Nv
19  t   time      4   00:00:00.000       0Nt  0Wt time      Time      TimeSpan

20-76 enums 77 anymap 78-96 77+t – mapped list of lists of type t 97 nested sym enum 98 table 99 dictionary 100 lambda 101 unary primitive 102 operator 103 iterator 104 projection 105 composition 106 f' 107 f/ 108 f\ 109 f': 110 f/: 111 f\: 112 dynamic load

n: short int returned by type and used for Cast, e.g. 9h$3
c: character used lower-case for Cast 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.br linebreak .h.cd CSV from data .h.code code after Tab .h.d delimiter .h.fram frame .h.ed Excel from data .h.ha anchor .h.edsn Excel from tables .h.hb anchor target .h.hc escape lt .h.ht Marqdown to HTML .h.hr horizontal rule .h.hta start tag .h.iso8601 ISO timestamp .h.htac element .h.jx table .h.htc element .h.td TSV from data .h.html document .h.tx filetypes .h.http hyperlinks .h.xd XML .h.nbr no break .h.xs XML escape .h.pre pre .h.xt JSON .h.text paragraphs .h.xmp XMP

.h.he HTTP 400 .h.c0 web color .h.hn HTTP response .h.c1 web color .h.hp HTTP response pre .h.HOME webserver root .h.hy HTTP response content .h.logo Kx logo .h.sa anchor style .h.hu URI escape .h.sb body style .h.hug URI map .h.ty MIME types .h.sc URI-safe .h.val value .h.uh URI unescape

.j

De/serialize as JSON

.m

Memory backed by files

.Q

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

.z

System variables, callbacks