Help
kdb+ and q
Q+A on all things kdb+ database and the q language
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Start a conversation

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
  • 590 Views
  • 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: 174.7.132.159User-Agent: 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;...

Main Office Contacts

EMEA
Tel: +44 (0)28 3025 2242

AMERICAS
Tel: +1 (212) 447 6700

APAC
Tel: +61 (0)2 9236 5700

Useful Information
Resources
Popular Links
Follow Us

KX. All Rights Reserved.

KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.

Privacy Policy

Export Statement

Terms of Use

Processing Notice