FWIW,

I use a cl command to copy a data file to an IFS shared directory. This file can then be opened with Excel. I built a front end program with display screen that asks for library, file name, and PC file name to copy it to. It allows me to very quickly copy any database file to a .csv format.

i.e. cpytoimpf fromfile(' from file name or variable from pgm ') tofile(' to IFS directory/New PC file name.csv') fromccsid(37) stmfccsid(*pcascii) rcddlm(*crlf) addcolnam(*sql)



Ok, but which options to choose in this version( on 'personal communications iseries for windows >workstation program version 6.0 for windows.) provided i am on OS/400 V7R4M000 so that i could >download data in excel file and notepad files in good looking format (currently it's getting >downloaded as Hex or junk values in notepad and excel files) I tried various options under file types l>ike BIFF3 -BIFF8 (MS Excel 3 to MS Excel 8)) but nothing is giving me a proper excel or notepad file >which have data in readable format same like in green screen(like inside IBM i environment).

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.