Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2001
    Posts
    4

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Why not load the data to a staging table, then do an INSERT INTO as a join of the 2
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2001
    Posts
    4
    We can do that. But I am looking if there is a way which I can do both of them simultaneously.

  4. #4
    Join Date
    Jan 2004
    Posts
    49

    Thumbs up Load Command

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •