Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.