kdb+ cli q limits query results to 20

Community Support
1

Hi

I’ve got problem that my cli limits select results to 20

q)select from trade
time                 sym    price    size

0D07:35:53.755779000 GS.N   179.5914 53
0D07:35:53.755779000 VOD.L  343.9744 421
0D07:35:54.755778000 MSFT.O 45.37211 824
0D07:35:54.755778000 BA.N   127.7568 367
0D07:35:55.755780000 BA.N   127.7511 510
0D07:35:55.755780000 MSFT.O 45.37663 790
0D07:35:56.756317000 GS.N   179.6004 618
0D07:35:56.756317000 VOD.L  343.969  320
0D07:35:57.756315000 MSFT.O 45.37562 848
0D07:35:57.756315000 VOD.L  343.9696 634
0D07:35:58.756312000 VOD.L  343.9691 572
0D07:35:58.756312000 VOD.L  343.9934 134
0D07:35:59.756315000 VOD.L  343.9898 227
0D07:35:59.756315000 GS.N   179.5892 376
0D07:36:00.755697000 VOD.L  344.0026 134
0D07:36:00.755697000 GS.N   179.5779 84
0D07:36:01.755692000 VOD.L  343.9819 919
0D07:36:01.755692000 GS.N   179.5836 216
0D07:36:02.755693000 MSFT.O 45.37723 579
0D07:36:02.755693000 BA.N   127.7514 159
..

even if table contains more

select does not help either

q)select[55] from trade

reutrns also max 20

I am using:

KDB+ 3.6 2018.12.24 Copyright (C) 1993-2018 Kx Systems
w32/ 4()core 4095MB XXXXXXXXXXX NONEXPIRE

Welcome to kdb+ 32bit edition

…

Cheers

2

You need to change console size. The default is 25 rows, 80 columns https://code.kx.com/q/ref/cmdline/#-c-console-size HTH, Sean