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...

User by Not applicable
  • 3 replies
  • 0 kudos

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;...

ISO-8601 (.h.iso8601)

Hi all,I noticed that .h.iso8601 is defined as following:k){$[^x;"";@[$"p"$x;4 7 10;:;"--T"]]}Since it converts everything to a timestamp, it give rise to values like "2015.10.29T00:00:00.000000000" with an input of 2015.10.29.This might be find for ...

Flying by New Contributor III
  • 0 replies
  • 0 kudos