Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: Generating insert scripts from data

    I'd like to be able to generate insert scripts from data existing already in a table. Does DB2 have an option in Gen Admin Tools or somewhere to do this or do I have to generate my own inserts from my own sql script concat'ing it together.
    Thanks in advance,
    Sybil Santos-Burgan

  2. #2
    Join Date
    Jun 2004
    you might try something like this:

    INSERT INTO t1(col1, col2) SELECT(colm, coln) FROM t2 WHERE....

Posting Permissions

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