[Jprogramming] bulk insert with ODBC (into MySQL db)

Fri Jul 9 06:55:25 HKT 2010

Denis,
Thanks for testing, I guess that assertion should be relaxed to allow
number to be either rank-1 or rank-2 column vector. However text
should remain as rank-2 character matrix.
inverted table
http://www.jsoftware.com/jwiki/Essays/Inverted%20Table
Чтв, 08 Июл 2010, Denis Samson писал(а):
>> Bill,
>> I retried it with (>'un';'deux') and ddins works fine; OTOH, ddins insists on having data in columns, for some unknown -& quite unnecessary, I'd guess- reason:
>> lh=.'select hnd,id,lat,lon from stop'; 3 4; (>'un';'deux'); 1234 1234; 2345 2345
> lh ddins ch
> _1
> NB. (because ddins[4] if. -. *./ 2=> #@$&.>}.x do. errret ISI08 return. end.)
>> lh=.'select hnd,id,lat,lon from stop'; ,.each 3 4; (>'un';'deux'); 1234 1234; 2345 2345
> lh ddins ch
> 0
> ]data=. ddfch _1,~ 'select * from stop' ddsel ch
> ┌─┬────────────────────┬────┬────┬──┐
> │3│un │1234│2345│__│
> │4│deux │1234│2345│__│
> └─┴────────────────────┴────┴────┴──┘
>> regards,
> Denis
>>> > Date: Thu, 8 Jul 2010 01:16:57 +0800
> > From: bbill.lam at gmail.com
> > To: programming at jsoftware.com
> > Subject: Re: [Jprogramming] bulk insert with ODBC (into MySQL db)
> > 
> > Срд, 07 Июл 2010, Denis Samson писал(а):
> > > 
> (...) 
> > > ]lh=:'select hnd,id,lat,lon from stop';,.each 1 2;('un';'deux');1234 1235;2345 2345
> > > ┌──────────────────────┬─┬──────┬────┬────┐
> > > │select hnd,id,lat,lon from stop│1│┌────┐│1234│2345│
> > > │ │2││un ││1235│2345│
> > > │ │ │├────┤│ │ │
> > > │ │ ││deux ││ │ │
> > > │ │ │└────┘│ │ │
> > > └──────────────────────┴─┴──────┴────┴───┘
> > 
> > I think that should be
> > ]lh=:'select hnd,id,lat,lon from stop'; 1 2;(>'un';'deux');1234 1235;2345 2345
> > 
> > shape of numbers doesn't matter but string data must not boxed, may be
> > that is the reason for the funny characters returned.
> > 
> > -- 
> > regards,
> > ====================================================
> > GPG key 1024D/4434BAB3 2008年08月24日
> > gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
> > ----------------------------------------------------------------------
> > For information about J forums see http://www.jsoftware.com/forums.htm
>> _________________________________________________________________

-- 
regards,
====================================================
GPG key 1024D/4434BAB3 2008年08月24日
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3