Hello,
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

you might try something like this:

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