RE: IBMDA400 and performance using VBA in Excel

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

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
>   
>