Re: Automatic Commits?

In article <58q51c$pi7@cssun.mathcs.emory.edu>, elderbox@teleport.com writes > >Another database engine which we had a while ago and which I don't care >name here allowed us to specify that during an sql insertion I >want the engine to automatically do a commit after say 100 rows have been >inserted. We are now very happily using Online Version 7.1, but cannot >find a way to do this. This is a problem for us since we have a need to >periodically transfer as many as 200k rows from one database to another >and must have logging turned on. We run out of log space and locks. > >We didn't want to have to write an esql/c program to do this chore. We do >not have 4GL at this time. Does anyone know of a way to accomplish this? > >elderbox@teleport.COM Public Access User --- Not affiliated with Teleport >Public Access UNIX and Internet at (503) 220-1016 (2400-28800, N81) > Look into the tool dbload, you can tell it to commit after x rows where x is any sensible number you choose. -- David Williams