Copy data into Excel (csv) format -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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).

This mailing list archive is Copyright 1997-2024 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.