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	`$`	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

accumulators		maps		maps
`/` `\`	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

Set Attribute

Command-line options and system commands

file
`\a`	tables	`\r`	rename
`-b`	blocked	`-s` `\s`	slaves
`\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`	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

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

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` or `0`	`0Nj` or `0N`	`0Wj` or `0W`	bigint	Long	int64
8	e	real	4	`0e`	`0Ne`	`0We`	real	Float	single
9	f	float	8	`0.0` or `0f`	`0n`	`0w`	float	Double	double
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		`v'`
107		`v/`
108		`v\`
109		`v':`
110		`v/:`
111		`v\:`
112		dynamic 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.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 .Q.a .Q.A .Q.addmonths .Q.bt .Q.dd .Q.def .Q.f .Q.fc .Q.ff .Q.fmt .Q.ft .Q.fu .Q.gc .Q.id .Q.qt .Q.res .Q.s .Q.s1 .Q.sbt .Q.sha1 .Q.trp .Q.ts .Q.u .Q.V .Q.v .Q.view Environment .Q.k .Q.opt .Q.w .Q.x IPC .Q.addr .Q.fps .Q.fs .Q.fsn .Q.hg .Q.host .Q.hp .Q.l Datatype lowercase alphabet .Q.btoa b64 encode uppercase alphabet .Q.j10 encode binhex .Q.j12 encode base64 backtrace .Q.M long infinity join symbols .Q.ty type .Q.x10 decode binhex format .Q.x12 decode base64 parallel on cut append columns Database format .Q.chk fill HDB apply simple .Q.dpft save table apply unique .Q.dpfts save table with sym garbage collect .Q.dsftg load process save sanitize .Q.en enumerate varchar cols is table .Q.ens enumerate against domain keywords .Q.fk foreign key plain text .Q.hdpf save tables string representation .Q.qt is table string backtrace .Q.qp is partitioned SHA-1 encode extend trap Partitioned database state time and space .Q.bv build vp date based .Q.cn count partitioned table table to dict .Q.D partitions value .Q.ind partitioned index subview .Q.MAP maps partitions .Q.par locate partition .Q.PD partition locations version .Q.pd modified partition locns command parameters .Q.pf partition field memory stats .Q.pn partition counts non-command parameters .Q.qp is partitioned .Q.pt partitioned tables .Q.PV partition values IP address .Q.pv modified partition values streaming algorithm .Q.vp missing partitions streaming algorithm streaming algorithm Segmented database state HTTP get .Q.D partitions hostname .Q.P segments HTTP post .Q.u date based load

File I/O .Q.Cf create empty nested char file .Q.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