Loading DB2 From CSV

[rhnewfie]

Is there a fast way to load a db2 database on an AS400 from a csv file. Someone is doing it already with a VB app but it takes 3 days on the AS400 but only 17 minutes on a desktop. Is there some built-in method to load DB2 from a csv file?

Thanks
RHNewfie There are 3 Types of People in the World
Those Born to Think Logically
Those that can Learn to Think Logically
Those that Shouldn't Try

 

[challenn]

CPYFRMIMPF is the command you're looking for. It's not particularly quick but should beat 3 days.

Performance is improved if you have SMP installed