Re: istar data loads

-- Art S. Kagel Any organism which has ceased to grow, has begun to die. cxvale@promarkone.com wrote in article <6u9u5o$flb$1@nnrp1.dejanews.com>... > This is a pretty simpe question, but I haven't been able to find an answer -- > how can I select from database A into database B through istar without > getting a long transaction??? From what I understand, 4gl does not support > "insert into" into a for loop (to put start a counter to commit every 5 or > 10K). Is that accurate?? > > We're trying to avoid unloading from one database, then rcp-ing the .unl file > and loading back into another database. > > Any ideas?? Any pieces of code? Anything.......??????? Get my submission to the IIUG Software Repository, named utils2_ak. It contains a program, dbcopy.ec which does just what you want. It is VERY fast, commits every N rows and can even copy between databases with different logging modes (ie from a non-logged database to a logged one). Art S. Kagel