From a@kx.com Mon, 11 Feb 2002 14:34:18 -0500 From: To: Return-Path: Received: from admin.listbox.com (admin.listbox.com [208.210.125.36]) by matuta.host4u.net (8.11.6/8.11.6) with ESMTP id g1BJSZ521778 for ; Mon, 11 Feb 2002 13:28:35 -0600 Received: by admin.listbox.com (Postfix) id 845002662D; Mon, 11 Feb 2002 14:31:18 -0500 (EST) Delivered-To: kdb-outgoing@admin.listbox.com Received: by admin.listbox.com (Postfix, from userid 502) id 28E092662A; Mon, 11 Feb 2002 14:31:18 -0500 (EST) Delivered-To: kdb@listbox.com Received: from mail2.registeredsite.com (mail2.registeredsite.com [64.224.9.11]) by admin.listbox.com (Postfix) with ESMTP id 6790D26619 for ; Mon, 11 Feb 2002 14:31:16 -0500 (EST) Received: from mail.kx.com (mail.kx.com [64.224.252.243]) by mail2.registeredsite.com (8.11.6/8.11.4) with ESMTP id g1BIapV01936 for ; Mon, 11 Feb 2002 13:36:51 -0500 Received: from B [64.224.252.243] by mail.kx.com (SMTPD32-6.06) id AC022D390090; Mon, 11 Feb 2002 14:31:14 -0500 Message-ID: <000701c1b333$18de2440$75f5fed0@B> Date: Mon, 11 Feb 2002 14:34:18 -0500 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Sender: owner-kdb@admin.listbox.com Precedence: bulk Reply-To: kdb@listbox.com X-Account: Bob/CoSyBob Subject: disk and swap Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Status: R there are two things that can kill a kdb server: 1. disk full. FIX: more disk i've seen this twice in the last 14 years . not serious 2. swap full. FIX: controlled access (stored procedures) (aka ws full) nt/w2000 2GB swap+map w2000AS /3GB 3GB swap+map linux 2GB swap+1GBmap unix 3.5GB swap+map it is fairly easy to hit this limit with today's machines. in general, it is impossible to protect against swap(ws)full. (kdb is a full programming system. this would be solving the= halting problem.) in practice, production servers must have controlled access. --- The KDB list is managed by majordomo@listbox.com Send a message there, containing the word 'help', for assistance,= e.g. unsubscribing. From a@kx.com Mon, 11 Feb 2002 14:53:15 -0500 From: To: Return-Path: Received: from admin.listbox.com (admin.listbox.com [208.210.125.36]) by matuta.host4u.net (8.11.6/8.11.6) with ESMTP id g1BJlSa27545 for ; Mon, 11 Feb 2002 13:47:28 -0600 Received: by admin.listbox.com (Postfix) id E1C562663A; Mon, 11 Feb 2002 14:50:15 -0500 (EST) Delivered-To: kdb-outgoing@admin.listbox.com Received: by admin.listbox.com (Postfix, from userid 502) id A26662663C; Mon, 11 Feb 2002 14:50:15 -0500 (EST) Delivered-To: kdb@listbox.com Received: from mail1.registeredsite.com (mail1.registeredsite.com [64.224.9.10]) by admin.listbox.com (Postfix) with ESMTP id 002682663A for ; Mon, 11 Feb 2002 14:50:14 -0500 (EST) Received: from mail.kx.com (mail.kx.com [64.224.252.243]) by mail1.registeredsite.com (8.11.6/8.11.4) with ESMTP id g1BJoEg10088 for ; Mon, 11 Feb 2002 14:50:14 -0500 Received: from B [64.224.252.243] by mail.kx.com (SMTPD32-6.06) id A0742F9300F6; Mon, 11 Feb 2002 14:50:12 -0500 Message-ID: <000901c1b335$bf6dd790$75f5fed0@B> Date: Mon, 11 Feb 2002 14:53:15 -0500 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Sender: owner-kdb@admin.listbox.com Precedence: bulk Reply-To: kdb@listbox.com X-Account: Bob/CoSyBob Subject: Re: disk and swap Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Status: R > disk full > i've seen this twice in the last 14 years . not serious what i meant to say is: it happened that it wasn't serious in these two cases. --- The KDB list is managed by majordomo@listbox.com Send a message there, containing the word 'help', for assistance,= e.g. unsubscribing. From a@kx.com Fri, 15 Feb 2002 11:18:43 -0500 From: To: "Smith, Judy" CC: "Wang, Jinsong" , <"Schwartz>, Adam , Return-Path: Received: from admin.listbox.com (admin.listbox.com [208.210.125.36]) by matuta.host4u.net (8.11.6/8.11.6) with ESMTP id g1FGCWd05580 for ; Fri, 15 Feb 2002 10:12:32 -0600 Received: by admin.listbox.com (Postfix) id 902DC2663E; Fri, 15 Feb 2002 11:15:44 -0500 (EST) Delivered-To: kdb-outgoing@admin.listbox.com Received: by admin.listbox.com (Postfix, from userid 502) id 4CF712664A; Fri, 15 Feb 2002 11:15:44 -0500 (EST) Delivered-To: kdb@listbox.com Received: from mail1.registeredsite.com (mail1.registeredsite.com [64.224.9.10]) by admin.listbox.com (Postfix) with ESMTP id 976972663E for ; Fri, 15 Feb 2002 11:15:43 -0500 (EST) Received: from mail.kx.com (mail.kx.com [64.224.252.243]) by mail1.registeredsite.com (8.11.6/8.11.4) with ESMTP id g1FGFfg10812; Fri, 15 Feb 2002 11:15:41 -0500 Received: from B [64.224.252.243] by mail.kx.com (SMTPD32-6.06) id A4294B0E00BE; Fri, 15 Feb 2002 11:15:37 -0500 Message-ID: <000701c1b63c$70ee1a30$75f5fed0@B> References: Date: Fri, 15 Feb 2002 11:18:43 -0500 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Sender: owner-kdb@admin.listbox.com Precedence: bulk Reply-To: kdb@listbox.com X-Account: Bob/CoSyBob Subject: Re: query results through browser and xml Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Status: R > Great- that worked. A few questions > > (1) What are the performance ramifications, if any? text is much slower. and can take enormous amounts of space. so it is fine for small results. (aggregation queries) big results should come back as binary through kdbc into java or= c. > > (2) How does one denote the full result set regardless of= size? k db x -N 0I (0I is integer infinity) > > (3) Does the xml interface support ANSI SQL as well as KSQL? yes. http://host:port/.xml?$select ... > > (4) How can one get an xml result for a query as 'select last= price from > trade' for now, the xml just handles table results. this query returns a record. --- The KDB list is managed by majordomo@listbox.com Send a message there, containing the word 'help', for assistance,= e.g. unsubscribing. From a@kx.com Mon, 1 Jul 2002 20:46:31 -0700 From: To: "Humphreys, Darryl" CC: Return-Path: Received: from cosy.cosy.com (root@localhost) by cosy.com (8.11.6/8.11.6) with ESMTP id g623jMW07042 for ; Mon, 1 Jul 2002 23:45:22 -0400 X-ClientAddr: 208.210.125.36 Received: from admin.listbox.com (admin.listbox.com [208.210.125.36]) by cosy.cosy.com (8.11.6/8.11.6) with ESMTP id g623jLu07038 for ; Mon, 1 Jul 2002 23:45:21 -0400 Received: by admin.listbox.com (Postfix) id 1D970265C9; Mon, 1 Jul 2002 23:45:21 -0400 (EDT) Delivered-To: kdb-outgoing@admin.listbox.com Received: by admin.listbox.com (Postfix, from userid 502) id D264D26619; Mon, 1 Jul 2002 23:45:20 -0400 (EDT) Delivered-To: kdb@listbox.com Received: from mail7.atl.registeredsite.com (mail7.atl.registeredsite.com [64.224.219.81]) by admin.listbox.com (Postfix) with ESMTP id 301A9265C9 for ; Mon, 1 Jul 2002 23:45:20 -0400 (EDT) Received: from mail.kx.com (mail.kx.com [64.224.252.243]) by mail7.atl.registeredsite.com (8.12.2/8.12.2) with ESMTP id g623jHHV014358; Mon, 1 Jul 2002 23:45:17 -0400 Received: from B [64.224.252.243] by mail.kx.com (SMTPD32-6.06) id A1CB296400B0; Mon, 01 Jul 2002 23:45:15 -0400 Message-ID: <002a01c2217b$0e2169c0$825ac93f@B> References: <113E17BE2252025-01@MMS__lehman.com_> Date: Mon, 1 Jul 2002 20:46:31 -0700 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Sender: owner-kdb@admin.listbox.com Precedence: bulk Reply-To: kdb@listbox.com Delivery-Date: Tue, 2 Jul 2002 07:25:45 X-Account: Bob Subject: Re: kdb time variable type and Java Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Status: R kdb time is a double fraction of a day. e.g. new Time((long)(8.64e7*x)) ----- Original Message ----- From: "Humphreys, Darryl" To: Sent: Monday, July 01, 2002 2:22 PM Subject: kdb time variable type and Java > I noticed no binding example from the "time" type in kdbc. How= do I bind to > this type in Java? Looks like a double and not sure how to= convert to Java > Date instance. > > >= ----------------------------------------------------------------= ---------- ---- > This message is intended only for the personal and confidential= use of the designated recipient(s) named above. If you are not the intended= recipient of this message you are hereby notified that any review,= dissemination, distribution or copying of this message is strictly prohibited. = This communication is for information purposes only and should not be= regarded as an offer to sell or as a solicitation of an offer to buy any= financial product, an official confirmation of any transaction, or as an= official statement of Lehman Brothers. Email transmission cannot be= guaranteed to be secure or error-free. Therefore, we do not represent that this= information is complete or accurate and it should not be relied upon as such.= All information is subject to change without notice. > > > --- The KDB list is managed by majordomo@listbox.com Send a message there, containing the word 'help', for assistance,= e.g. unsubscribing. From a@kx.com Mon, 11 Feb 2002 10:38:18 -0500 From: To: Return-Path: Received: from admin.listbox.com (admin.listbox.com [208.210.125.36]) by matuta.host4u.net (8.11.6/8.11.6) with ESMTP id g1BFWYL13794 for ; Mon, 11 Feb 2002 09:32:34 -0600 Received: by admin.listbox.com (Postfix) id 996B52663A; Mon, 11 Feb 2002 10:35:20 -0500 (EST) Delivered-To: kdb-outgoing@admin.listbox.com Received: by admin.listbox.com (Postfix, from userid 502) id 55EBC2663C; Mon, 11 Feb 2002 10:35:20 -0500 (EST) Delivered-To: kdb@listbox.com Received: from mail6.registeredsite.com (mail6.registeredsite.com [64.224.9.22]) by admin.listbox.com (Postfix) with ESMTP id 9CF1A2663A for ; Mon, 11 Feb 2002 10:35:19 -0500 (EST) Received: from mail.kx.com (mail.kx.com [64.224.252.243]) by mail6.registeredsite.com (8.11.6/8.11.4) with ESMTP id g1BFZGI03643 for ; Mon, 11 Feb 2002 10:35:16 -0500 Received: from B [64.224.252.243] by mail.kx.com (SMTPD32-6.06) id A4B36A600F4; Mon, 11 Feb 2002 10:35:15 -0500 Message-ID: <002701c1b312$21151ea0$75f5fed0@B> References: <20020211065132.30196.qmail@web13905.mail.yahoo.com> Date: Mon, 11 Feb 2002 10:38:18 -0500 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Sender: owner-kdb@admin.listbox.com Precedence: bulk Reply-To: kdb@listbox.com X-Account: Bob/CoSyBob Subject: Re: zero counts for enumerate Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Status: R > what's the best way to get counts of zero in a result? > that is, i want a count, zero or positive of the number > of rows for each enumerate, E, in table, t. > ('select count $ by E from t' omits the last row) use the 'rack' (procrustes) lay out a result table and combine it (union,+,*,&,|) ([E:E E])+select count$by E from t union,+,*,... are very useful --- The KDB list is managed by majordomo@listbox.com Send a message there, containing the word 'help', for assistance,= e.g. unsubscribing. From a@kx.com Mon, 11 Feb 2002 12:03:18 -0500 From: To: Eric Newhuis CC: Return-Path: Received: from admin.listbox.com (admin.listbox.com [208.210.125.36]) by matuta.host4u.net (8.11.6/8.11.6) with ESMTP id g1BGvYW09665 for ; Mon, 11 Feb 2002 10:57:34 -0600 Received: by admin.listbox.com (Postfix) id 333BC2663E; Mon, 11 Feb 2002 12:00:20 -0500 (EST) Delivered-To: kdb-outgoing@admin.listbox.com Received: by admin.listbox.com (Postfix, from userid 502) id E191926641; Mon, 11 Feb 2002 12:00:19 -0500 (EST) Delivered-To: kdb@listbox.com Received: from mail2.registeredsite.com (mail2.registeredsite.com [64.224.9.11]) by admin.listbox.com (Postfix) with ESMTP id 3A68F2663E for ; Mon, 11 Feb 2002 12:00:19 -0500 (EST) Received: from mail.kx.com (mail.kx.com [64.224.252.243]) by mail2.registeredsite.com (8.11.6/8.11.4) with ESMTP id g1BG5rV12083; Mon, 11 Feb 2002 11:05:53 -0500 Received: from B [64.224.252.243] by mail.kx.com (SMTPD32-6.06) id A89F29F0108; Mon, 11 Feb 2002 12:00:15 -0500 Message-ID: <001501c1b31e$014144d0$75f5fed0@B> References: <000101c1b31a$cc212390$4dc201cf@XENO> Date: Mon, 11 Feb 2002 12:03:18 -0500 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Sender: owner-kdb@admin.listbox.com Precedence: bulk Reply-To: kdb@listbox.com X-Account: Bob/CoSyBob Subject: Re: /3gb Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Status: R the /3gb takes the combined swap+map space from 2-x to 3-x (where x is around 100MB) so yes, it is a good thing boot.ini /3GB (w2000AS) (50% gain) [operating systems] multi(0)disk(0)rdisk(1)partition(1)\WINNT=3D"w2000" /fastdetect= /3gb --- The KDB list is managed by majordomo@listbox.com Send a message there, containing the word 'help', for assistance,= e.g. unsubscribing. From a@kx.com Fri, 28 Jun 2002 09:06:45 -0400 From: To: Return-Path: Received: from cosy.cosy.com (root@localhost) by cosy.com (8.11.6/8.11.6) with ESMTP id g5SD5ZR31559 for ; Fri, 28 Jun 2002 09:05:35 -0400 X-ClientAddr: 208.210.125.36 Received: from admin.listbox.com (admin.listbox.com [208.210.125.36]) by cosy.cosy.com (8.11.6/8.11.6) with ESMTP id g5SD5Yu31555 for ; Fri, 28 Jun 2002 09:05:34 -0400 Received: by admin.listbox.com (Postfix) id BE58D26627; Fri, 28 Jun 2002 09:05:34 -0400 (EDT) Delivered-To: kdb-outgoing@admin.listbox.com Received: by admin.listbox.com (Postfix, from userid 502) id 825742663E; Fri, 28 Jun 2002 09:05:34 -0400 (EDT) Delivered-To: kdb@listbox.com Received: from mail8.atl.registeredsite.com (mail8.atl.registeredsite.com [64.224.219.82]) by admin.listbox.com (Postfix) with ESMTP id 2766226627 for ; Fri, 28 Jun 2002 09:05:33 -0400 (EDT) Received: from mail.kx.com (mail.kx.com [64.224.252.243]) by mail8.atl.registeredsite.com (8.12.2/8.12.2) with ESMTP id g5SD5WsN012376 for ; Fri, 28 Jun 2002 09:05:32 -0400 Received: from B [64.224.252.243] by mail.kx.com (SMTPD32-6.06) id AF1B77300E0; Fri, 28 Jun 2002 09:05:31 -0400 Message-ID: <006e01c21ea4$a8184d70$ea59c93f@B> References: <20020628043632.46238.qmail@web13907.mail.yahoo.com> Date: Fri, 28 Jun 2002 09:06:45 -0400 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Sender: owner-kdb@admin.listbox.com Precedence: bulk Reply-To: kdb@listbox.com Delivery-Date: Fri, 28 Jun 2002 10:02:42 X-Account: Bob Subject: Re: enumeration Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Status: R > is this the conventional way to enumerate person.color: > update color:color[color] from 'person' > (because color['g'] is 1)? yes > > is the conventional inverse: > update color:'color' at color from 'person' > (because color at 1 is 'g')? yes. we have to quote because of the name conflict. i like to have column names be their type. (especially with foreign keys. e.g. order.customer.nation) but it can be awkward if the object being pointed to is also needed. (quoting works because `sym at x becomes sym[x]) --- The KDB list is managed by majordomo@listbox.com Send a message there, containing the word 'help', for assistance,= e.g. unsubscribing. From a@kx.com Wed, 20 Feb 2002 14:55:21 -0500 From: To: Peter Briggeman CC: Return-Path: Received: from admin.listbox.com (admin.listbox.com [208.210.125.36]) by matuta.host4u.net (8.11.6/8.11.6) with ESMTP id g1KJpu921551 for ; Wed, 20 Feb 2002 13:51:56 -0600 Received: by admin.listbox.com (Postfix) id 4FF6E2664B; Wed, 20 Feb 2002 14:52:19 -0500 (EST) Delivered-To: kdb-outgoing@admin.listbox.com Received: by admin.listbox.com (Postfix, from userid 502) id D66E826645; Wed, 20 Feb 2002 14:52:18 -0500 (EST) Delivered-To: kdb@listbox.com Received: from mail2.registeredsite.com (mail2.registeredsite.com [64.224.9.11]) by admin.listbox.com (Postfix) with ESMTP id A0F9926646 for ; Wed, 20 Feb 2002 14:52:16 -0500 (EST) Received: from mail.kx.com (mail.kx.com [64.224.252.243]) by mail2.registeredsite.com (8.11.6/8.11.4) with ESMTP id g1KIvnV15837; Wed, 20 Feb 2002 13:57:50 -0500 Received: from B [64.224.252.243] by mail.kx.com (SMTPD32-6.06) id AE6A51E90100; Wed, 20 Feb 2002 14:52:10 -0500 Message-ID: <000901c1ba48$88067220$75f5fed0@B> References: <628900C9F8A7D51188E000A0C9F3FDFA107F41@S-NY-EXCH01> Date: Wed, 20 Feb 2002 14:55:21 -0500 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Sender: owner-kdb@admin.listbox.com Precedence: bulk Reply-To: kdb@listbox.com X-Account: Bob/CoSyBob Subject: Re: Insanely Simple Question Mime-Version: 1.0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Status: R
>How do you assign= the single value of a query result to a variable?  Something like= this:

>pERowID::.d.r("select rERowID from tELastRowID where $ =3D 0")  

>Although= I get the value it creates a table and puts this value in it, I just want= to assign it to a variable.

 

.d.r("x:first .= select rERowID from tELastRowID where $=3D0")

  <= /P>

or

 

x:.d.r("...")   /local x

 

 

select returns a table(or a record, e.g. select sum x,sum y from t)


to get back a single field do: .= select x from t
e.g. p['p1'].color is equal to:= first . select color from p where p=3D'p1'
 

 

 

 From a@kx.com Mon, 5 Aug 2002 08:05:26 -0700 From: To: Return-Path: Received: from cosy.cosy.com (root@localhost) by cosy.com (8.11.6/8.11.6) with ESMTP id g75F47o08005 for ; Mon, 5 Aug 2002 11:04:07 -0400 X-ClientAddr: 208.210.125.36 Received: from admin.listbox.com (admin.listbox.com [208.210.125.36]) by cosy.cosy.com (8.11.6/8.11.6) with ESMTP id g75F43u07921 for ; Mon, 5 Aug 2002 11:04:03 -0400 Received: by admin.listbox.com (Postfix) id 5064E266D5; Mon, 5 Aug 2002 11:04:00 -0400 (EDT) Delivered-To: kdb-outgoing@admin.listbox.com Received: by admin.listbox.com (Postfix, from userid 502) id EA03F266D9; Mon, 5 Aug 2002 11:03:59 -0400 (EDT) Delivered-To: kdb@listbox.com Received: from mail7.atl.registeredsite.com (mail7.atl.registeredsite.com [64.224.219.81]) by admin.listbox.com (Postfix) with ESMTP id 2BDB5266D5 for ; Mon, 5 Aug 2002 11:03:59 -0400 (EDT) Received: from mail.kx.com (mail.kx.com [64.224.252.243]) by mail7.atl.registeredsite.com (8.12.2/8.12.5) with ESMTP id g75F3w9R006079 for ; Mon, 5 Aug 2002 11:03:58 -0400 Received: from B [64.224.252.243] by mail.kx.com (SMTPD32-6.06) id A3DC2BB00BA; Mon, 05 Aug 2002 11:03:56 -0400 Message-ID: <004c01c23c91$88683390$6400a8c0@B> References: <628900C9F8A7D51188E000A0C9F3FDFA01AE500F@S-NY-EXCH01> Date: Mon, 5 Aug 2002 08:05:26 -0700 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Sender: owner-kdb@admin.listbox.com Precedence: bulk Reply-To: kdb@listbox.com Delivery-Date: Mon, 5 Aug 2002 11:28:01 X-Account: Bob Subject: Re: Return Error Message Mime-Version: 1.0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Status: R
  if[...;'"not all values can= be blank"]
 

Given the stored procedure:

 

\spGetDate{:[a;b;c;d]

          &= nbsp; x:("select ?,?,?,? from table";$a,$b,$c,$d)=

          &= nbsp;