Re: Automatic Commits?
Check out dbload in Informix Guide to SQL:Reference.
--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523,
USofA; 970-491-1244 FAX 970-491-4100 cwoodall@vth1.vth.colostate.edu
"Ask me about my vow of silence!"
--
On Thu, 12 Dec 1996 elderbox@teleport.com wrote:
}
} 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)
}
}