KX Community

effbiae

on windows, we can load scripts with UNC filename:\l //wi/c/tmp.qwe can load csv:t: ... 0:`://wi/c/tmp.csvbut we can't save:save `://wi/c/t.csv'//wi/c/t.csv. OS reports: The specified path is invalid.`://wi/c/t.txt 0:enlist"text"'//wi/c/t. OS reports...

effbiae

i need to find groups of a where b contains 8 9q)show t:([]a:3 3 3 4 4;b:7 7 8 8 9)a b---3 73 73 84 84 9i can do this in qq)where all each 8 9 in/:(t.b group t.a),4can i solve the same in sql something likeq)select by a where all b in 8 9 ... ?many t...

effbiae

q)show t:([]a:1 1 1;b:1 2 2;c:`a`b`c)a b c-----1 1 a1 2 b1 2 ci can find distinct rows considering a,b byq)distinct select a,b from ta b---1 11 2but need to incorporate the c column so the result i want might bea b c------1 1 a1 2 bso an idistinct wo...

effbiae

interesting treatment of n?0 for different zeroes. show the range of many rolls:q)flip (min;max)@'\:10000?/:"idmpz"$\:0-2147220343 2147473647 2000.01.01 2003.12.31 2000.01 2003.12 2000.01.01D15:44:08.050010204 2003.12.31D18:08:55.7036925922000.01.01T...

effbiae

this is the correct way of calling k() with variable number of parms:k(0,"1",(S)0)after doing some fossicking around, i believe the (S) is not required.ie. k(0,"1",0)on linux 64, the terminating 0 is promoted to 64bit (SYSV ABI)on linux 32, to 32bit ...

effbiae

try > set QHOME=D:\q> D:\q\w32\qsee https://code.kx.com/q/ref/card/#environment-variablesfor other environment variables you may have set for 3.5

effbiae

> replace forward-slash `/' with the normal backward ones `\'these three experiments with saving to UNC filenames didn't workq)save `:\\wi\c\t.csv'\ [0] save `:\\wi\c\t.csv ^q)save `\\wi\c\t.csv'\ [0] save `\\wi\c\t.csv ^ q)save `://wi/c/t.csv'//wi/c...

effbiae

this video is about connecting to kdb but the need is to connect to another db from kdb

effbiae

To solve the size problem, why not use a where clause like where date>=a and date

effbiae

>csv and odbccsv loading is an alternative to odbc. for odbc, see https://code.kx.com/q/interfaces/q-client-for-odbc/

KX Community

User Statistics

User Activity

UNC filenames

by...where

idistinct

roll date types

variadic k()

Re: Error in installing v3.6

Re: UNC filenames

Re: sql server database to kdb+ database

Re: sql server database to kdb+ database

Re: sql server database to kdb+ database