RE: IBMDA400 and performance using VBA in Excel

It looks like that the ADO method "AddNew" supports multiple rows at
once.

That may be what you need to use.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx] 
> On Behalf Of Wilt, Charles
> Sent: Thursday, January 05, 2006 10:10 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: IBMDA400 and performance using VBA in Excel
> 
> It's doing what you told it to do and the way you told it to do it is
> about the worst possible way.
> 
> A few things:
> -I know the ODBC driver supported the concept of "blocked inserts" I
> assume OLEDB does, but a quick search didn't turn up any links to give
> you.
> -ODBC also supported "lazy close".  The DB would keep the file open
> after being told to close it in case it was used again.
> -A parameterized statement instead of the execute immediate 
> should help.
> 
> In addition, one thing I've done when I couldn't use actual blocked
> insert support is a statement like so
> 
> insert into mytable
>  (select 'DOG', 'APPLE' from sysibm.sysdummy1
>    UNION ALL
>   select 'CAT', 'PEAR' from sysibm.sysdummy1
>    UNION ALL
>   select 'BIRD', 'BANANA' from sysibm.sysdummy1
>  )
> 
> 
> In any event, be sure and post back if you figure out the syntax for
> blocked inserts with OLEDB.  I'd like to be able to file it away for
> future reference.
> 
> HTH,
> 
> 
> 
> Charles Wilt
> --
> iSeries Systems Administrator / Developer
> Mitsubishi Electric Automotive America
> ph: 513-573-4343
> fax: 513-398-1121
>   
>