|
Anne,There are probably better ways to do this (it was my first and only requirement, so far,to get a csv file from a DB2 file) but here's some sample code:
CPYTOIMPF FROMFILE(*LIBL/PMONLINE &USER) + TOSTMF('/QDLS/PM/ONLINE.CSV') + MBROPT(*REPLACE) STMFCODPAG(*PCASCII) + RCDDLM(*CRLF) DTAFMT(*FIXED) STRDLM(' ') + FLDDLM(' ')
The DB2 file (PMONLINE) only has two fields (qty and item#), but it imports into a web order form OK.
midrange.com
* Jerry C. Adams
*iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
615.995.7024
fax
615.995.1201
email
jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>
Anne d'Hooge wrote:
Hi,I need to copy a large amount of AS400 externally described files to PC in .csv format. Manually transferring is impossible due to the large amount, so I wanted to do this through CL, but how to get them to a PC environment ? I've noticed a command CPYTOSTMF, but that doesn't work with externally described files.Can anyone help me ? Regards Anne d'Hooge
As an Amazon Associate we earn from qualifying purchases.
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.
