Internal functions

! with a negative integer as left-argument calls a k internal function.


-n! bindings are subject to change. If a cover function is provided in the .q or .Q namespaces – use that instead!

Neal Stephenson thinks it's cute to name his labels 'dengo'

These should rarely – if ever – be used, but in order to recognise them when seen in the wild, here is a partial list.

-1!x (hsym)


-2!x (attr)


-3!x (.Q.s)

Returns the string representation of x.

Strictly, this is .Q.s1, but it's better to use .Q.s

-4!x (tokens)

Returns the list of q tokens found in string x. (Note the q parsing of names with embedded underscores.)

q)-4!"select this from that"
," "
," "
," "

q)-5!"select this from that" / compare with −5!

q)-4!"a variable named aa_bb"
," "
," "
," "

-5!x (parse)


-6!x (eval)


-7!x (hcount)


-8!x (to bytes)

return the IPC byte representation of x

q)-8!1 2 3

-9!x (from bytes)

Create data from IPC byte representation x

q)-9!-8!1 2 3
1 2 3

-10!x (type enum)

Resolve a type number to an enum vector and check if it’s available

q)type vv

-11!x (streaming execute)

Streaming-execute over file x, used for example in kdb+tick to replay logfiles in a memory-efficient manner.

A logfile is just a list of lists, and each list is read in turn and evaluated, either by value or by if it is defined.

Here, for demonstration purposes, we manually create a logfile, and play it back through -11!. This is functionally equivalent to doing value each get `:logfile but uses far less memory.

q)`:logfile.2013.12.03 set () / create a new,empty log file
q)h:hopen `:logfile.2013.12.03 / open it
q)h enlist(`f;`a;10) / append a record
q)h enlist(`f;`b;20) / append a record
q)hclose h / close the file
q)f:{0N!(x;y)} / define the function that is referenced in those records
q)-11!`:logfile.2013.12.03 / playback the logfile
q)/ DO NOT DO THIS ON LARGE LOGFILES!!!! This is the whole purpose of -11!x.
q)value each get `:logfile.2013.12.03
`a 10
`b 20

If successful, the number of chunks executed is returned. If the end of the file is corrupt a 'badtail error is signalled. In the event that the log file references an undefined function, the function name is signalled as an error. This can be confusing if the missing function name is upd, as it does not reflect the same situation as the license expiry 'upd error. e.g.

/ Continuing the above example
q)delete f from `.
q)-11!`:logfile.2013.12.03 / function f no longer defined, so it signals an error
'f for examples of usage

−11!(-1;x) (streaming execute)

Same as −11!x.

−11!(n;x) (streaming execute)

Streaming-execute the first n chunks of logfile x, return the number of chunks if successful.

It's possible to leverage the above to playback n records from record M onwards.

Firstly create a sample log file, which contains 1000 records as ((f;0);(f;1);(f;2);..;(f;999)).

q)`:log set();h:hopen`:log;i:0;do[1000;h enlist(`f;i);i+:1];hclose h;

then define function f to just print its arg, skip the first M records. If is defined, -11! calls for each record.

q)m:0;M:750;f:0N!;{m+:1;if[m>M;value x;];};-11!(M+5-1;`:log)

-11!(-2;x) (logfile chunks)

Given a valid logfile, return the number of chunks.

Given an invalid logfile, return the number of valid chunks and length of the valid part.

q)logfile:`:good.log / a non-corrupted logfile
q)logfile:`:broken.log / a manually corrupted logfile
q)upd:{[x;y]} / define a dummy upd file as components are of the form (`upd;data)
q)hcount logfile
q)/ 26 valid chunks until position 35634 (out of 39623)

-12!x (

-13!x (.Q.addr)


-14!x (quote escape)

Handle " escaping in strings: used to prepare data for CSV export.

-15!x (md5)


-16!x (ref count)

Return the reference count for a variable

q)a:b:c:d:e:1 2 3

-17!x (flip endian-ess)

Flip endian-ness of kdb+ datafile x, see notes in Changes in kdb+ V2.6

-18!x (compress byte)

Return compressed IPC byte representation of x, see notes about network compression in Changes in V2.6

-19!x (compress file)

Syntax: -19! x

Where x is a list of 5 items:

  • source file: file symbol
  • target file: file symbol
  • logical block size: a power of 2 between 12 and 20 (pageSize or allocation granularity to 1MB – pageSize for AMD64 is 4kB, SPARC is 8kB. Windows seems to have a default allocation granularity of 64kB). When choosing the logical block size, consider the minimum of all the platforms that will access the files directly – otherwise you may encounter "disk compression - bad logicalBlockSize". Note that this argument affects both compression speed and compression ratio: larger blocks can be slower and better compressed.
  • compression algorithm: one of:
    • 0: none
    • 1: q IPC
    • 2: gzip
    • 3: snappy (since V3.4)
  • compression level: an integer between 0 and 9 (valid only for gzip, use 0 for other algorithms)

returns the target file as a file symbol.

q)`:test set asc 10000000?100; / create a test data file
q) / compress input file test, to output file ztest
q) / using a block size of 128kB (2 xexp 17), gzip level 6
q) / check the compressed data is the same as the uncompressed data

Cookbook/File compression

-20!0 (.Q.gc)


-21!x (compression stats)

Syntax: -21! x

Where x is a file symbol, returns a dictionary of compression statistics for it.

compressedLength  | 137349
uncompressedLength| 80000016
algorithm         | 2i
logicalBlockSize  | 17i
zipLevel          | 6i

Cookbook/File compression

-22!x (uncompressed length)

An optimized shortcut to obtain the length of uncompressed serialized x, i.e. count -8!x

q)v:til 100000
q)\t do[5000;-22!v]
q)\t do[5000;count -8!v]
q)(-22!v)=count -8!v

-23!x (memory map)

Since V3.1t 2013.03.04

Maps data into memory without copying.

q)/ previous tricks to force load included .. where i>=0
q)-23!t:select from get`:t/; 

-24!x (read-only eval)

Since V3.3t 2014.10.07.

read-only evaluation, underpinning the keyword "reval", similar to eval (-6!), which behaves as if the cmd line option -b were active for the duration of the -24! call.

An example usage is inside the message handler, useful for access control, here blocking sync messages from updating

q){reval(value;x)} / define on local process listening on port 500
q)h:hopen 5000 / from another process on localhost
'noupdate: `. `a

-25!x (async broadcast)

Since V3.4

Broadcast data as an async msg to specified handles. The advantage of using -25!(handles;msg) over neg[handles]@\:msg is that -25!msg will serialize msg just once – thereby reducing CPU and memory load.

Use as


Handles should be a vector of int or longs > 0.

msg will be serialized just once, to the lowest capability of the list of handles. I.e. if handles are connected to a mix of versions of kdb+, it will serialize limited to the types supported by the lowest version. If there is an error, no messages will have been sent, and it will return the handle whose cap caused the error.

Just as with neg[handles]@\:msg, -25!x queues the msg as async on those handles – they don't get sent until the next spin of the main loop, or are flushed with neg[handles]@\:(::).

Possible error scenarios:

  1. from trying to serialize data for a handle whose remote end does not support a type, or size of the data.
/ connect to 2.8 and 3.4
q)h:hopen each 5000 5001
5 6i 
q)(-5) 0Ng / 2.8 does not support guid
q)(-6) 0Ng / 3.4 does support guid 
'type error serializing for handle 5
  1. in case an int is passed which is not a handle
q)-25!(7 8;0Ng)
'7 is not an ipc handle

-26!x (SSL)

Since V3.4 2016.05.12. View TLS settings on a handle or current process -26!handle or -26!()

-29!x (parse JSON)

Since V3.3t 2015.02.17 underpins the JSON parser, .j.k.