Skip to content

Internal functions

The operator ! with a negative integer as left argument calls an internal function.

0N!x show Replaced: -4!x tokens -1! hsym -8!x to bytes -2! attr -9!x from bytes -3! .Q.s1 -10!x type enum -5! parse -11! streaming execute -6! eval -14!x quote escape -7! hcount -16!x ref count -12! -18!x compress byte -13! .Q.addr -21!x compression stats -15! md5 -22!x uncompressed length -19! set -23!x memory map -20! .Q.gc -25!x async broadcast -24! reval -26!x SSL -29! .j.k -27!(x;y) format -31! .j.jd -30!x deferred response -32! .Q.btoa -33!x SHA-1 hash -34! .Q.ts -36! load master key -35! .Q.gz -38!x socket table -37! .Q.prf0 -120!x memory domain

Internal functions are for use by language implementors.

They are exposed infrastructure and may be redefined in subsequent releases.

They also allow new language features to be tried on a provisional basis.

Where they are replaced by keywords or utilities, use the replacements.

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

0N!x (show)

The identity function. Returns x after writing it to the console.

An essential tool for debugging.

-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"
," "
," "
," "


Should not be used with input data over 2GB in length (0Wi). Returns domain error with this condition since 4.1 2022.04.15.

-8!x (to bytes)

Returns the IPC byte representation of x.

q)-8!1 2 3

-9!x (from bytes)

Creates 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 is available.

q)type vv

-11! (streaming execute)


Where n is a non-negative integer and x is a logfile handle

-11!x and -11!(-1;x)

replay x and return the number of chunks executed; if end of file is corrupted, signal badtail.


returns the number of consecutive valid chunks in x and the length of the valid part of the file


replays n chunks from top of logfile and returns the number of chunks executed

In replaying, if the logfile references an undefined function, the function name is signalled as an error.

Replaying logfiles

-14!x (quote escape)

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

-16!x (ref count)

Returns the reference count for a variable.

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

-18!x (compress byte)

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

-21!x (compression stats)

Where x is a file symbol, returns a dictionary of compression statistics for it. The dictionary is empty if the file is not compressed.

q)-21!`:ztest       / compressed
compressedLength  | 137349
uncompressedLength| 80000016
algorithm         | 2i
logicalBlockSize  | 17i
zipLevel          | 6i
q)-21!`:test        / not compressed
q)count -21!`:test

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

Attempts to force the object x to be resident in memory by hinting to the OS and/or faulting the underlying memory pages. Useful for triggering sequential access to the storage backing x.

-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

q)-25!(handles; msg)

Handles should be a vector of positive int or longs.

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]@\:(::).

-25!(handles; ::) can also flush the handles

Possible error scenarios:

  • 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
  • an int is passed which is not a handle

    q)-25!(7 8;0Ng)
    '7 is not an ipc handle

-26!x (SSL)

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

SSLEAY_VERSION   | OpenSSL 1.0.2g  1 Mar 2016
SSL_CERT_FILE    | /Users/kdb/certs/server-crt.pem
SSL_CA_CERT_FILE | /Users/kdb/certs/ca.pem
SSL_CA_CERT_PATH | /Users/kdb/certs/
SSL_KEY_FILE     | /Users/kdb/certs/server-key.pem

In the result, all keys except SSLEAY_VERSION are initialized from their corresponding environment variables.

.z.e TLS connection status

-27!(x;y) (format)


  • x is an int atom
  • y is a float

returns y as a string or strings formatted as a float to x decimal places. (Since V3.6 2018.09.26.) It is atomic and doesn’t take \P into account. e.g.

q)-27!(3i;0 1+123456789.4567)

This is a more precise, built-in version of .Q.f but uses IEEE754 rounding:


You might want to apply a rounding before applying -27!.

-30!x (deferred response)


Where handle is an int, isError is a boolean, and msg is a string

  • -30!(::) allows the currently-executing callback to complete without responding
  • -30!(handle;isError;msg) responds to the deferred sync call

Since V3.6 2018.05.18.

Deferred response

-33!x (SHA-1 hash)


where x is a string, returns its SHA-1 hash as a list of strings of hex codes.

q)raze string -33!"mypassword"

Command-line options -u and -U

-36! Load master key

-36!(::)    / since 4.1 2024.03.12 and 4.0 2024.03.02
-36!(x;y;z) / since 4.1 2024.03.12 and 4.0 2024.03.02


  • x is a master-key file as a file symbol
  • y is a password as a string
  • z is whether to unlock/lock as a bool


Expose whether a key has already been loaded, returning 0b or 1b accordingly.

-36!(x;y) and -36!(x;y;z)

loads and validates the master key into memory as the key to use when decrypting or encrypting data on disk.

Create master key

Expect this call to take about 500 milliseconds to execute. It can be executed from handle 0 only.

Signals errors:

Encryption lib unavailable      failed to load OpenSSL libs
Invalid password
Main thread only                can be executed from the main thread only
PKCS5_PBKDF2_HMAC               library invocation failed
Restricted                      must be executed under handle 0
Unrecognized key format         master key file format unrecognized

z indicates unlock/lock. To reload using a new key, unlock using current key and then proceed with the new key. If load is attempted while locked, it throws 'DARE key locked.

-38!x (socket table)


where x is a list of socket handles, returns a table with columns

  • p (protocol): q (IPC) or w (WebSocket)
  • f (family): t (TCP) or u (Unix domain socket)
  • z (compression enabled flag): since v4.1 2024.05.31
  • n (count unsent msgs): since v4.1 2024.05.31
  • m (total unsent bytes, like .z.W): since v4.1 2024.05.31

Since v4.0 2020.06.01.

h| p f z n m
-| ---------
8| q u 0 0 0
9| q t 0 0 0

.z.H active sockets

-120!x (memory domain)


returns x’s memory domain (currently 0 or 1), e.g.

q)-120!'(1 2 3;.m.x:1 2 3)
0 1

.m namespace