Is there a way in which we can load the data related to few columns from a file and the remaining columns from another table.

Why not load the data to a staging table, then do an INSERT INTO as a join of the 2

We can do that. But I am looking if there is a way which I can do both of them simultaneously.

Hi,

Why can't use the cursor with Load utility.

See the following example.

db2 declare mycurs cursor for select two,one,three from abc.table1
db2 load from mycurs of cursor insert into abc.table2

In cursor selection select data as per your requirement ie, partially from table partially from file. I hope it will solve your problem. Still if you required some more explanation get back to me.

Bala