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

  • 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

  • #2
    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.....

    Comment


    • #3
      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

      Working...
      X