View Single Post

   
  #2 (permalink)  
Old 02-26-2008, 05:39 PM
Serge Rielau
 
Posts: n/a
Default 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
Reply With Quote