Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

download from Iseries to Excel and retain headings

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Guest's Avatar
    Guest replied
    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...............

    Leave a comment:


  • Guest's Avatar
    Guest replied
    download from Iseries to Excel and retain headings

    I have created a cl to download a PF in a CSV format. This works great. But how does one include the column headings? Is there a way to do this? Thank you.....

    Leave a comment:


  • download from Iseries to Excel and retain headings

    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
Working...
X