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

maps accumulators ' Each, each, Case /: Each Right / Over, over ': Each Parallel, peach \: Each Left \ Scan, scan ': Each Prior, prior

Execution control

.[f;x;e] Trap : Return do exit $[x;y;z] Cond @[f;x;e] Trap-At ' Signal if while

Debugging

Other

` pop stack : assign 0 console 0: File Text . push stack :: identity 1, -1 stdout 1: File Binary \x system cmd generic null 2, -2 stderr 2: Dynamic Load \ abort global amend n, -n handle \\ quit q set view

() precedence [;] expn block {} lambda ` symbol (;) list argt list ; separator `: filepath ([]..) table

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

.j.j serialize .j.k deserialize .j.jd serialize infinity

`.m`

Memory backed by files

`.Q`

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

General addmonths bt dd def f ff fmt ft fu gc gz id qt res s s1 sbt trp ts u V v view Constants A a b6 nA Environment k opt w x IPC addr fps fs hg host hp l Datatype btoa b64 encode backtrace j10 encode binhex join symbols j12 encode base 36 M long infinity format ty type append columns x10 decode binhex format x12 decode base 36 apply simple apply unique Database garbage collect chk fill HDB GZip dpft save table sanitize dpfts save table with sym is table dsftg load process save keywords en enumerate varchar cols plain text ens enumerate against domain string representation fk foreign key string backtrace hdpf save tables extend trap qt is table time and space qp is partitioned date based table to dict value Partitioned database state subview bv build vp ind partitioned index cn count partitioned table uppercase alphabet MAP maps partitions lowercase alphabet D partitions bicameral alphanums par locate partition alphanums PD partition locations pd modified partition locns pf partition field version pn partition counts command parameters qp is partitioned memory stats pt partitioned tables non-command parameters PV partition values pv modified partition values vp missing partitions IP address fpn streaming algorithm Segmented database state fsn streaming algorithm D partitions HTTP get P segments hostname u date based HTTP post load

File I/O Cf create empty nested char file Xf create file

`.z`

System variables, callbacks

System information Callbacks .z.a IP address .z.ac HTTP auth from cookie .z.b dependencies .z.bm msg validator .z.c cores .z.exit action on exit .z.D/d date shortcuts .z.pc close .z.e TLS connection status .z.pd peach handles .z.ex failed primitive .z.pg get .z.ey arg to failed primitive .z.ph HTTP get .z.f file .z.pi input .z.h host .z.po open .z.i PID .z.pp HTTP post .z.K version .z.pq qcon .z.k release date .z.ps set .z.l license .z.pw validate user .z.N/n local/UTC timespan .z.ts timer .z.o OS version .z.vs value set .z.P/p local/UTC timestamp .z.wc WebSocket close .z.pm HTTP options .z.wo WebSocket open .z.q quiet mode .z.ws WebSockets .z.s self .z.T/t time shortcuts .z.u user ID .z.W/w handles/handle .z.X/x raw/parsed command line .z.Z/z local/UTC datetime .z.zd zip defaults