Re: Copy multiple files to PC csv format

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Anne,

STMFCODPAG is an option.  If you're using prompting, you need to press 
F9 for more options; it's on the 2nd panel.  I forget why (duh), but 
it's important.


QDLS is part of the IFS on the iSeries.  Unless you have a shared drive 
to it, Explorer won't find it.  on the iSeries use the WRLFLR command. 


You can, also, use iSeries Navigator: File Systems.


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

> Frank,
>
> I've tried the CPYTOIMPF, however the keyword STMFCODPAG doesn't exist in 
> this command. The copy worked without it.
> Now I have to find the file in a PC environment, I've scanned the network 
> through explorer, but I can't find QDLS, is an AS400 displayed under 
> another name ?
> Mailing is not an option, there are millions of records to transfer.
>
> Regards
>
> Anne
>
>
>
>
>  
>
> > date: Wed, 1 Feb 2006 09:31:30 -0600
> > from: FrankKany@xxxxxxxxxxx
> > subject: Re: Copy multiple files to PC csv format
> >
> > The following works for me:
> >
> > I first copy the file to an IFS folder:
> > CPYTOIMPF  FROMFILE(QTEMP/MYFILE) +
> >             TOSTMF('/QDLS/MYFOLDER/MYFILE.CSV') +
> >             MBROPT(*REPLACE) STMFCODPAG(*PCASCII) +
> >             RCDDLM(*CRLF)
> >
> > Then copy email the file to myself:
> > SNDDST     TYPE(*DOC) +
> >             TOINTNET((myemailaddress@xxxxxxxxx))       +
> >             DSTD('My File in CSV format to open in Excel')          +
> >             MSG('This goes into the body of the email') +
> >             DOC(MYFILE.CSV)                        +
> >             FLR('MYFOLDER')
> >
> > hth,
> >
> > Frank W. Kany IV
> > Senior Programmer/Analyst
> > Unipres USA, Inc.
> >
> >
> >
> > "Anne d'Hooge" <a.dhooge@xxxxxxxxxx>
> > Sent by: midrange-l-bounces@xxxxxxxxxxxx
> > 02/01/2006 09:14 AM
> > Please respond to
> > Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> >
> >
> > To
> > midrange-l@xxxxxxxxxxxx
> > cc
> >
> > Subject
> > Copy multiple files to PC csv format
> >
> >
> >
> >
> >
> >
> > 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
> >    
>
>