Re: Copy multiple files to PC csv format

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

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.


        * 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
>
>