upsert in c or jdbc for a partiioned table

Community Support
1

How do you do an upset (append new rows in partitioned table) ?

In the q command line I can do :

`:/db/2009.01.02/t/ upsert (09:33:00;`:/db/sym?`ibm; 103.)

How do I do this in c or jdbc ..?

Thanks

2 
K r=k(handle,"functionname",params,(K)0);

See http://code.kx.com/wiki/Cookbook/InterfacingWithC

3

Sorry if I was not clear .. I was talking about the c class in java API. There are two drivers in Java JDBC and C .

More interested in c .. 

c c = new c (“host”,5043);

Object x = (new Time.VaueOf(“09:33:00”),“howcaniaddthissymbol”, new Float(103.4));

c.ks(“.u.upd”,“trade”,x);

4

upsert is a dyadic function:

q)upsert
.[;();,;]

So just do
c.ks(“upsert”,“trade”,x);

2012/5/16 Dodong Juan :
> Sorry if I was not clear .. I was talking about the c class in java API.
> There are two drivers in Java JDBC and C .
>
> More interested in c ..
>
> c c = new c (“host”,5043);
> Object x = (new Time.VaueOf(“09:33:00”),“howcaniaddthissymbol”, new
> Float(103.4));
> c.ks(“.u.upd”,“trade”,x);
>
>
>
>
>
> On Wednesday, May 16, 2012 12:37:09 PM UTC-4, Dodong Juan wrote:
>>
>> How do you do an upset (append new rows in partitioned table) ?
>>
>> In the q command line I can do :
>>
>> :/db/2009.01.02/t/ upsert (09:33:00;:/db/sym?ibm; 103.)<br>&gt;&gt;<br>&gt;&gt;<br>&gt;&gt; How do I do this in c or jdbc ..?<br>&gt;&gt;<br>&gt;&gt; Thanks<br>&gt;&gt;<br>&gt;<br>&gt; On Wednesday, May 16, 2012 12:37:09 PM UTC-4, Dodong Juan wrote:<br>&gt;&gt;<br>&gt;&gt; How do you do an upset (append new rows in partitioned table) ?<br>&gt;&gt;<br>&gt;&gt; In the q command line I can do :<br>&gt;&gt;<br>&gt;&gt; :/db/2009.01.02/t/ upsert (09:33:00;:/db/sym?ibm; 103.)
>>
>>
>> How do I do this in c or jdbc ..?
>>
>> Thanks
>>
>
> On Wednesday, May 16, 2012 12:37:09 PM UTC-4, Dodong Juan wrote:
>>
>> How do you do an upset (append new rows in partitioned table) ?
>>
>> In the q command line I can do :
>>
>> :/db/2009.01.02/t/ upsert (09:33:00;:/db/sym?ibm; 103.)<br>&gt;&gt;<br>&gt;&gt;<br>&gt;&gt; How do I do this in c or jdbc ..?<br>&gt;&gt;<br>&gt;&gt; Thanks<br>&gt;&gt;<br>&gt;<br>&gt; On Wednesday, May 16, 2012 12:37:09 PM UTC-4, Dodong Juan wrote:<br>&gt;&gt;<br>&gt;&gt; How do you do an upset (append new rows in partitioned table) ?<br>&gt;&gt;<br>&gt;&gt; In the q command line I can do :<br>&gt;&gt;<br>&gt;&gt; :/db/2009.01.02/t/ upsert (09:33:00;:/db/sym?ibm; 103.)
>>
>>
>> How do I do this in c or jdbc ..?
>>
>> Thanks
>>
>
> On Wednesday, May 16, 2012 12:37:09 PM UTC-4, Dodong Juan wrote:
>>
>> How do you do an upset (append new rows in partitioned table) ?
>>
>> In the q command line I can do :
>>
>> :/db/2009.01.02/t/ upsert (09:33:00;:/db/sym?ibm; 103.)<br>&gt;&gt;<br>&gt;&gt;<br>&gt;&gt; How do I do this in c or jdbc ..?<br>&gt;&gt;<br>&gt;&gt; Thanks<br>&gt;&gt;<br>&gt;<br>&gt; On Wednesday, May 16, 2012 12:37:09 PM UTC-4, Dodong Juan wrote:<br>&gt;&gt;<br>&gt;&gt; How do you do an upset (append new rows in partitioned table) ?<br>&gt;&gt;<br>&gt;&gt; In the q command line I can do :<br>&gt;&gt;<br>&gt;&gt; :/db/2009.01.02/t/ upsert (09:33:00;:/db/sym?ibm; 103.)
>>
>>
>> How do I do this in c or jdbc ..?
>>
>> Thanks
>>
> –
>

Submitted via Google Groups

5

Thanks .. Will try this ..For inserts , does it really make a difference whether I am using the c or jdbc driver ..?