You can use the download program that comes with CA/400. That will provide headings consisting of either the field name, or the contents of the ALIAS keyword if you use ALIAS in your DDS. Dave
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
download from Iseries to Excel and retain headings
Collapse
X
-
download from Iseries to Excel and retain headings
This is an automatic process. I have a cl that will take the PF that was just updated and CPYTOIMPF as a CSV file. See example of my code: CHGVAR &GRUSER1 VALUE(&GRUSER) CHGVAR &DOCN (&GRUSER1|< '.CSV') CHGVAR &TOSTMF ('/QDLS/BFGBOM/'|<&DOCN) CPYTOIMPF FROMFILE(QTEMP/GRBOMS2P) + TOSTMF(&TOSTMF) + MBROPT(*REPLACE) RCDDLM(*CRLF) + DTAFMT(*DLM) STMFCODPAG(*PCASCII) Is there any way to include the headings? Thank you...............
Comment
Comment