kdb+ and q
Q+A on all things kdb+ database and the q language
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Set string data type

Hi,I need to set the data type for columns c3,c4 as "C" without inserting single record in tablesuppose, tab is table having c3,c4 is list columntab:([] c1:`int$(); c2:`boolean$(); c3:(); c4:())q)meta tab c | t f a --| -----c1| i c2| b c3| c4| I want...

Deepak by New Contributor
  • 1 replies
  • 0 kudos

run q-sql as string

I want to run q-sql which is inputted as string to the program. ALL of them run fine in the console. I can use eval ( parse queryString) however the big ones dont parse fine and hence dont run. Is there a way to just run them without using eval/parse...

RE: [personal kdb+] Select a column mapped to a username

X-Originating-IP: Workspace Webmail 5.15.9Message-Id: <20151029072108.85f80dae80d1d2f2e266ec6278e6cbe8.096f6de106.wbe@email07.europe.secureserver.net>From: "David Demner \(AquaQ\)" To: personal-kdbplus@googlegroups.comSubject...

Select a column mapped to a username

I have table with columns for users.ie. t:([]Dave:`$();Nick:`$())I am wondering how to dynamically select the column that matches the current username using .z.uI will have to consider string cases, using something like `$ssr[string .z.u;string .z.u;...