Re: Q: Improving INSERT performance using E/SQLC
Posted in 1998
Bob Maccione wrote: > > Art S. Kagel wrote in message <360A6455.4441@bloomberg.net>... > >Get the source to my dbcopy.ec from my submission to the IIUG software > >Repository. It uses PUT Cursors, increased buffer size and has > >complete error recovery from errors detected at FLUSH time. You can > >use the same logic in your program. The program also uses the IDS > >FetchArray feature to fetch large numbers of rows in a single FETCH > >statement and uses that array of FETCHed rows for recovery. If you are > >reading data from a file or stream you can either save file positions > >or input records in a local array and use that array for the recovery. > >The logic is the same. Have fun. > > I looked all over IIUG and couldn't find a dbcopy.* anywhere, any other > pointers? Mia culpa. I thought that I had posted the name of the submission file. Dbcopy.ec is in the shell archive named utils2_ak. Sorry again. Art S. Kagel