mainframegurukul.com

Can you please show the screen shot how you tried?

INSERT INTO TABLE2 VALUES(COL1,COL2,COL3) SELECT COL1,COL2,COL3 FROM TABLE1 WHERE COL1 = COL3 ;

INSERT INTO T2 (intcol1,identcol2) SELECT intcol1, identcol2
FROM T1
Please refer
http://publib.boulder.ibm.com/infocente ... 000970.htm

you can use Delmited separtor as comma(,) .the you can extract PDS and it extracted file extension should be .csv.
Now you can get directly excel format