Thanks for your follow-up, Jonny. But no, I still didn’t manage to make it work.
Following are my tests:
Console direct input:
D:\Dev>q
KDB+ 3.3 2015.07.09 Copyright (C) 1993-2015 Kx Systems
w32/ 4()core 4095MB Think flying-thinkpad 10.166.16.225 NONEXPIRE
Welcome to kdb+ 32bit edition
For support please see http://groups.google.com/d/forum/personal-kdbplus
Tutorials can be found at http://code.kx.com/wiki/Tutorials
To exit, type \
To remove this startup msg, edit q.q
q)system"l ",getenv`HDB_DIR
q)show(outside;tables
)
`outside
s#
DailyIndex
Minute
q)\d .ns
q.ns)show(inside;tables
.)
`inside
s#
DailyIndex
Minute
q.ns)HDB:select count i by date from.
Index
k){$[#pm;pmx;z in vt x;vp x;+(!+. x)!`/:dd[y;z],x]}
'Index
.:
`Index
q.Q))
Test script (test.q):
system"l ",getenv`HDB_DIR
show(outside;tables
)
\d .ns
show(inside;tables
.)
/HDB:select count i by date from Index
/HDB:select count i by date from value `Index
HDB:select count i by date from.
Index
\d .
And the result of running test.q:
D:\Dev>q test.q
KDB+ 3.3 2015.07.09 Copyright (C) 1993-2015 Kx Systems
w32/ 4()core 4095MB Think flying-thinkpad 10.166.16.225 NONEXPIRE
Welcome to kdb+ 32bit edition
For support please see http://groups.google.com/d/forum/personal-kdbplus
Tutorials can be found at http://code.kx.com/wiki/Tutorials
To exit, type \
To remove this startup msg, edit q.q
`outside
s#
DailyIndex
Minute
`inside
s#
DailyIndex
Minute
k){$[#pm;pmx;z in vt x;vp x;+(!+. x)!`/:dd[y;z],x]}
'Index
.:
`Index
q.Q))
As you can see above, none of the approaches worked for me. Not sure what the diff is between our setups…