Kdb ticker plant: where to find documentation on .u.upd?

I know this resource . But it does not indicate what parameters .u.updare taken and how to check whether it works.

This statement is executed without errors, although it does nothing:

.u.upd[`t;(`$"abc";1;2;3)]

If I predefine a table, for example

t:([] name:"aaa";a:1;b:2;c:3)

then the above .u.updis still performed without errors and does not change t.

+4
source share
2 answers

.u.updhas the same functional signature as insert(see http://code.kx.com/q/ref/qsql/#insert ) in prefix form. In the simplest case, it .u.updcan be defined as insert.

So: .u.upd[`table;<records>]

For example:

q).u.upd:insert
q)show tbl:([] a:`x`y;b:10 20)
   a b
   ----
   x 10
   y 20
q).u.upd[`tbl;(`z;30)]
   ,2
q)show tbl
   a b
   ----
   x 10
   y 20
   z 30
q).u.upd[`tbl;(`a`b`c;1 2 3)]
   3 4 5
q)show tbl
   a b
   ----
   x 10
   y 20
   z 30
   a 1
   b 2
   c 3
+3
source

, , .. Tickerplants, : http://www.timestored.com/kdb-guides/kdb-tick-data-store

enter image description here

.u.upd [TABLENAME; tableData] , . feedhandler. tableData, , , in-memory, , , .

+3

All Articles