RE: Copy multiple files to PC csv format

Which version of the OS are you on? 


Mark Walter
Senior Programmer/Analyst
IBM Certified RPG Developer
Hainey Business Systems
(717) 771-2362
mwalter@xxxxxxxxxxx
http://www.hbs-inc.com
 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Anne d'Hooge
Sent: Thursday, February 02, 2006 10:56 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Copy multiple files to PC csv format 


>
>
>
>message: 7
>date: Thu, 2 Feb 2006 08:54:12 -0500
>from: "Mark Walter" <mwalter@xxxxxxxxxxx>
>subject: RE: Copy multiple files to PC csv format
>
>It's there if you press F10. Don't use QDLS. That's the old DOS 8.3 
>file system. I'd use either QOpenSys or another folder in the /root 
>file system. You can make your own folder by doing a MD '/MyNewFolder'.

>Then direct your CPYTOIMPF to that.
>

There really isn't a STMFCODPAG, we have :
FROMFILE,TOFILE,TOSTMF,MBROPT,TOCCSID,RCDDLM,DTAFMT,STRDLM,FLDDLM,NULLIN
D,DECPNT,DATFMT
and TIMFMT

Anne



>Mark Walter
>Senior Programmer/Analyst
>IBM Certified RPG Developer
>Hainey Business Systems
>(717) 771-2362
>mwalter@xxxxxxxxxxx
>http://www.hbs-inc.com
>
>
>
>message: 8
>date: Thu, 2 Feb 2006 07:55:09 -0600
>from: FrankKany@xxxxxxxxxxx
>subject: Re: Copy multiple files to PC csv format
>
>Anne,
>
>Try pressing F9 when you have CPYTOIMPF prompted.  Then press F11 to 
>see the STMFCODPAG parameter.
>
>Have you tried FTP'ing the file from the AS400 to your PC?

There really isn't a STMFCODPAG, we have :
FROMFILE,TOFILE,TOSTMF,MBROPT,TOCCSID,RCDDLM,DTAFMT,STRDLM,FLDDLM,NULLIN
D,DECPNT,DATFMT
and TIMFMT

Can you use FTP in a CLP with variables ? I want to use a file with all
filenames and libraries in it, which I can read and pass through as
parameters to a CL.

Anne





>hth,
>
>Frank
>
>
>
>
>
>message: 9
>date: Thu, 2 Feb 2006 08:02:08 -0600
>from: "Grizzly Malchow" <grizzlym@xxxxxxxxxxxxxxxxxxxxx>
>subject: RE: Copy multiple files to PC csv format
>
>If you type the following in the address bar of windows explorer do you

>get anything? (SXXXXXXX is the name of your iSeries or the serial 
>number).
>\\SXXXXXXX\QDLS
>If not you might need to set up a share Ops Nav.

I found our AS400 doing \\, but no QDLS or the directory I created.
There is a QCA400 and a QIBM in it.

Anne


>
>-----Original Message-----
>From: midrange-l-bounces@xxxxxxxxxxxx
>[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Anne d'Hooge
>Sent: Thursday, February 02, 2006 7:44 AM
>To: midrange-l@xxxxxxxxxxxx
>Subject: Re: Copy multiple files to PC csv format
>
>
>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
>
>
>
>------------------------------
>
>--
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest 
>list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, 
>unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a

>moment to review the archives at 
>http://archive.midrange.com/midrange-l.
>
>
>
>End of MIDRANGE-L Digest, Vol 5, Issue 237
>******************************************

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.