Skip to content
kdb+ and q documentation
Simple Exec – Reference – kdb+ and q documentation
Initializing search
Ask a question
Home
kdb+ and q
kdb Insights SDK
kdb Insights Enterprise
KDB.AI
PyKX
APIs
Help
kdb+ and q documentation
Home
kdb+ and q
kdb+ and q
About
Getting Started
Getting Started
Install
Licenses
Learn
Learn
Overview
Mountain tour
Mountain tour
Overview
Begin here
The q session
Tables
CSVs
Datatypes
Scripts
IDE
Q for quants
Q by Examples
Q for All (video)
Examples from Python
Examples from Python
Basic
Array
List
Strings
Dictionaries
Q for Mortals 3
Q by Puzzles
Q by Puzzles
About
12 Days of Xmas
ABC problem
Abundant odds
Four is magic
Name Game
Summarize and Say
Word wheel
Reading room
Reading room
Information desk
Boggle
Cats cradle
Fizz buzz
Klondike
Phrasebook
Scrabble
Application examples
Application examples
Astronomy
Detecting card counters
Corporate actions
Disaster management
Exoplanets
Market depth
Market fragmentation
Option pricing
Predicting floods
Signal processing
Space weather
Trading surveillance
Transaction-cost analysis
Trend indicators
Advanced q
Advanced q
Remarks on Style
Shifts & scans
Technical articles
Views
Origins
Terminology
Starting kdb+
Starting kdb+
Overview
The q language
IPC
Tables
Historical database
Realtime database
Language
Language
Reference card
By topic
Iteration
Iteration
Overview
Implicit iteration
Iterators
Maps
Accumulators
Guide to iterators
Keywords
Keywords
abs
aj, aj0, ajf, ajf0
all, any
and
asc, iasc, xasc
asof
attr
avg, avgs, mavg, wavg
bin, binr
ceiling
count, mcount
cols, xcol, xcols
cor
cos, acos
cov, scov
cross
csv
cut
delete
deltas
desc, idesc, xdesc
dev, mdev, sdev
differ
distinct
div
dsave
each, peach
ej
ema
enlist
eval, reval
except
exec
exit
exp, xexp
fby
fills
first, last
fkeys
flip
floor
get, set
getenv, setenv
group
gtime, ltime
hcount
hdel
hopen, hclose
hsym
ij, ijf
in
insert
inter
inv
key
keys, xkey
like
lj, ljf
load, rload
log, xlog
lower
lsq
max, maxs, mmax
md5
med
meta
min, mins, mmin
mmu
mod
neg
next, prev, xprev
not
null
or
over, scan
parse
pj
prd, prds
prior
rand
rank
ratios
raze
read0
read1
reciprocal
reverse
rotate
save, rsave
select
show
signum
sin, asin
sqrt
ss, ssr
string
sublist
sum, sums, msum, wsum
sv
system
tables
tan, atan
til
trim, ltrim, rtrim
type
uj, ujf
union
ungroup
update
upsert
value
var, svar
view, views
vs
where
within
wj, wj1
xbar
xgroup
xrank
Overloaded glyphs
Operators
Operators
Add
Amend
Apply, Index, Trap
Assign
Cast
Coalesce
Compose
Cut
Deal, Roll, Permute
Delete
Display
Dict
Divide
Dynamic Load
Drop
Enkey, Unkey
Enumerate
Enumeration
Enum Extend
Equal
Exec
File Binary
File Text
Fill
Find
Flip Splayed
Greater
Greater Than
Identity, Null
Join
Less Than
Lesser
Match
Matrix Multiply
Multiply
Not Equal
Pad
Select
Set Attribute
Simple Exec
Signal
Subtract
Take
Tok
Update
Vector Conditional
Control constructs
Control constructs
Cond
do
if
while
Namespaces
Namespaces
.h (markup)
.j (JSON)
.m (memory backed files)
.Q (utils)
.z (env, callbacks)
Application
Atomic functions
Comparison
Conformability
Connection handles
Command-line options
Datatypes
Dictionaries
Enumerations
Evaluation control
Exposed infrastructure
File system
Function notation
Glossary
Internal functions
Joins
Mathematics
Metadata
Namespaces
Parse trees
qSQL
qSQL
qSQL queries
Functional qSQL
Regular Expressions
Syntax
System commands
Tables
Variadic syntax
Database
Database
Tables in the filesystem
Populating tables
Populating tables
Loading from large files
Foreign keys
Linking columns
Data loaders
From MDB via ODBC
Persisting tables
Persisting tables
Serializing an object
Splayed tables
Partitioned tables
Segmented databases
Multiple partitions
Maintenance
Maintenance
Data management
Data-At-Rest Encryption
Compression
Compression
File compression
Compression examples
Permissions
Query optimization
Query scaling
Time-series simplification
Compacting HDB sym
Working with sym files
Developing
Developing
IPC
IPC
Overview
Listening port
Deferred response
Async callbacks
Named pipes
Serialization examples
Socket sharding
SSL/TLS
HTTP
WebSockets
Tools
Tools
Code profiler
Debugging
Errors
man.q
Unit tests
Monitor & control execution
Coding
Coding
Geospatial indexing
Linear programming
Multithreaded input
Multithreaded primitives
Pivoting tables
Precision
Programming examples
Programming idioms
Temporal data
Timezones
Unicode
DevOps
DevOps
CPU affinity
Daemon
Firewalling
inetd, xinetd
Linux production notes
Log Files
Multi-threading
Multiple versions
Parallel processing
Performance tips
Shebang script
Surveillance latency
Windows service
Optane Memory
Optane Memory
Optane Memory and kdb+
Performance tests
Release notes
Release notes
History
Changes in 4.1
Changes in 4.0
Changes in 3.6
Changes in 3.5
Changes in 3.4
Changes in 3.3
Changes in 3.2
Changes in 3.1
Changes in 3.0
Changes in 2.8
Changes in 2.7
Changes in 2.6
Changes in 2.5
Changes in 2.4
Withdrawn
Developer tools
FAQ
Streaming
Streaming
General architecture
General architecture
Overview
kdb+tick
kdb+tick
Tickerplant (tick.q)
Tickerplant pub/sub (u.q)
RDB (r.q)
Alternative architecture
TP Log (data recovery)
RTEs (real-time engines)
Gateway design
Query routing
Load balancing
Profiling
Disaster recovery
Kubernetes
Order Book
Alternative in-memory layouts
Corporate actions
Advanced
Advanced
Distributed systems
RDB intraday writedown
Interfaces
Interfaces
Languages
Languages
C/C++
C/C++
Quick guide
API reference
C API for kdb+
Extending q with C/C++
Async callbacks (C client)
C#
Foreign Function Interface (FFI)
Java
Python
R
Rust
Scala
KX libraries
Bloomberg
Excel
FIX messaging
GPUs
Matlab
ODBC
ODBC
ODBC client
ODBC3 server
ODBC3 and Tableau
Solace pub/sub
Open source
Machine learning
Using kdb+ in the cloud
Using kdb+ in the cloud
About
Amazon Web Services
Amazon Web Services
Reference architecture
Amazon EC2 & Storage Services
Amazon EC2 & Storage Services
Migrating a kdb+ HDB to Amazon EC2
Elastic Block Store (EBS)
EFS (NFS)
Amazon Storage Gateway
FSx for Lustre
AWS Lambda
Microsoft Azure
Microsoft Azure
Reference architecture
Google Cloud
Google Cloud
Reference architecture
Auto Scaling
Auto Scaling
About
Amazon Web Services
Realtime data cluster
Costs and risks
Other file systems
Other file systems
MapR-FS
Goofys
S3FS
S3QL
ObjectiveFS
WekaIO Matrix
Quobyte
Academy
Discussion Forum
White papers
About this site
kdb Insights SDK
kdb Insights Enterprise
KDB.AI
PyKX
APIs
Help
?
Simple Exec
¶
For functional Simple Exec, see Basics:
Functional qSQL
Back to top