Printable View
I am trying to develop a VB application using ADO connecting to a DB2 database that will be run on an AS/400. Our problem is that we have encountered excessive run times when trying to do a lot of inserts to tables using the 'one insert at a time' method. Has anyone developed code that will do bulk inserts (say 50 or 100 at a time) in this type of environment that they would be willing to share with me?
Thanks,
Ron
Why not use dts packages to do the bulk work see if that increases performance.
Actually i think that i can find out from my job they do all that stuff. I think they also used the FTP method as well, but they are going to datamirroring with some company. THey have an FTP VB Component. I will find out and let you know.
RyeBread: Are you sure it's not DHTML.
I downloaded the db2 drivers from MS. I think the are OLEIBMXXX something. I have to check at work tomorrow. I also use client access. The way that we are doing some of the stuff we have robot running on the as400 that checks for changed data if it changes it puts it in the out queue which is the queue that talks to WinSpool. Winspool takes the data converts the file type to PDF. and dumps it to an Win2000 File server. then i pick it up with a web interface.
The method of FTP'ing the data to the 400 would work if you are doing a Batch update, but we also have the need to do block inserts with interactive applications where the users will be updating their information. I don't believe FTP would work in this type of environment.
Comments?
Ron