Re: Importing large comma-separated file Two choices I can think of:
1. Declare a cursor on PERSON and LOAD inro CHILD
2. ALTER TABLE CHILD ACTIVE NOT LOGGED INITIALLY.
Then insert from select as you propose.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab |