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

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	multithread 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.hu	URI escape
.h.c0	web color	.h.hug	URI map
.h.c1	web color	.h.hy	HTTP response
.h.cd	CSV from data	.h.iso8601	ISO timestamp
.h.code	code after Tab	.h.jx	table
.h.ed	Excel from data	.h.logo	Kx logo
.h.edsn	Excel from tables	.h.nbr	no break
.h.fram	frame	.h.pre	pre
.h.ha	anchor	.h.sa	style
.h.hb	anchor target	.h.sb	style
.h.hc	escape lt	.h.sc	URI-safe
.h.he	HTTP 400	.h.td	TSV
.h.hn	HTTP error	.h.text	paragraphs
.h.hp	HTTP response	.h.tx	filetypes
.h.hr	horizontal rule	.h.ty	MIME types
.h.ht	Marqdown to HTML	.h.uh	URI unescape
.h.hta	start tag	.h.val	value
.h.htac	element	.h.xd	XML
.h.htc	element	.h.xmp	XMP
.h.html	document	.h.xs	XML escape
.h.http	hyperlinks	.h.xt	JSON

.j

De/serialize as JSON

.j.j

serialize

.j.k

deserialize

.m

Memory backed by files

.Q

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

.Q.a	lower-case alphabet	.Q.j10	encode binhex
.Q.A	upper-case alphabet	.Q.x10	decode binhex
.Q.addmonths		.Q.j12	encode base64
.Q.addr	IP address	.Q.x12	decode base64
.Q.bt	backtrace	.Q.k	version
.Q.btoa	b64 encode	.Q.l	load
.Q.bv	build vp	.Q.M	long infinity
.Q.chk	fill HDB	.Q.MAP	maps partitions
.Q.cn	count partitioned table	.Q.opt	command parameters
.Q.Cf	create empty nested char file	.Q.par	locate partition
.Q.D	partitions	.Q.pd	modified partition locations
.Q.dd	join symbols	.Q.pf	partition field
.Q.def		.Q.pn	partition counts
.Q.dpft	save table	.Q.pt	partitioned tables
.Q.dpfts	save table with symtable	.Q.pv	modified partition values
.Q.dsftg	load process save	.Q.P	segments
.Q.en	enumerate varchar cols	.Q.PD	partition locations
.Q.ens	enumerate against domain	.Q.PV	partition values
.Q.f	format	.Q.qp	is partitioned
.Q.fc	parallel on cut	.Q.qt	is table
.Q.ff	append columns	.Q.res	keywords
.Q.fk	foreign key	.Q.s	plain text
.Q.fmt	format	.Q.sbt	string backtrace
.Q.fps	streaming algorithm	.Q.sha1	SHA-1 encode
.Q.fs	streaming algorithm	.Q.trp	extend trap
.Q.fsn	streaming algorithm	.Q.ts	time and space
.Q.ft	apply simple	.Q.ty	type
.Q.fu	apply unique	.Q.u	date based
.Q.gc	garbage collect	.Q.v	value
.Q.hdpf	save tables	.Q.V	table to dict
.Q.hg	HTTP get	.Q.view	subview
.Q.host	hostname	.Q.vp	missing partitions
.Q.hp	HTTP post	.Q.w	memory stats
.Q.id	sanitize	.Q.x	non-command parameters
.Q.ind	partitioned index	.Q.Xf	create file

.z

System variables, callbacks

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