Pipeline and memory

Someone is offering $4.80 for this question. Thought someone here might know. H. Attempting to Pipeline several tables from Informix 7.x to Oracle 8. One table in particular has roughly 3.6 Million rows. Both database are on a unix platform and PowerBuilder is running on NT4.0. Here's the problem as the Pipeline moves the rows from one DBMS to another it uses up my memory. It is uses about 2k for every 100 rows read from Informix which is fine but it never releases it after writing to Oracle and it uses up more memory per each 100 rows. I have tried this on different machines and I get the same results everytime I run out of memory. Their are no errors, so this couldn't be the problem. Is there some sort of setting I can use to stop this? Any suggestions? http://www.respondnet.com/ -------------------------------------------- Question asked by: ErnestoP, who has graded 100% of responses. Average grade given is ........................ RespondNET.com is an engaging, interactive community that dynamically links users who have questions with professionals who respond with answers. Now you can earn money by answering questions in any RespondNET.com category or you can ask questions and name your own price for an answer from other registered professionals. Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.