I'm having fun with the ODBC stuff. Thanks for coming up with it.
Possible Enhancements:
NB. MAXARRAYSIZE=: 2147483647
MAXARRAYSIZE=: 32000 NB. DM 2006 07 27
I had some very peculiar results doing a ddins with about 80000 rows, 6 columns.
The sqlbulkoperations was still running after 1.8 million rows had been
added. I had to terminate the J task to stop it. Setting MAXARRAYSIZE to 32000
fixed them. It's possible a larger number would work also.
The following changes allow ddins to work with variable length character columns
passed as a vector of text vectors.
NB. if. -. *./ 2=> [EMAIL PROTECTED]&.>}.x do. errret ISI08 return. end. NB. DM
2006 07 27
(comment out rank check)
case. SQL_CHAR;SQL_VARCHAR do.
if. 32=3!:0 ]0{(of+i){x do. NB. DM 2006 07 27
bx=.,brow&{ >(of+i){x NB. DM 2006 07 27
(bname)=: ,a=. ln&{."1 >brow&{ >(of+i){x
(blname)=: ,.;#&.>bx NB. DM 2006 07 27
else. NB. DM 2006 07 27
(bname)=: ,a=. ln&{."1 brow&{ >(of+i){x
(blname)=: (rows,1)$#{.a
end. NB. DM 2006 07 27
q=. sh;(>:i);SQL_C_CHAR;(vad bname);(#{.a);(<vad blname)
David Mitchell
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
