Search found 3 matches

by cmsmoon
Tue Jun 19, 2012 4:05 pm
Forum: TSO, CLIST & REXX
Topic: Getting no of records in a file
Replies: 13
Views: 34617

Can you please show the screen shot how you tried?
by cmsmoon
Mon Jun 18, 2012 4:21 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: please send me the query
Replies: 5
Views: 5741

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
by cmsmoon
Mon Jun 18, 2012 4:05 pm
Forum: TSO, CLIST & REXX
Topic: Mainframe PS to Excel and mail it.
Replies: 18
Views: 25939

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