var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Load command in db2
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.
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.