RE: CPYTOIMPF

[Alan Shore <AlanShore@xxxxxxxx>]

Then in my opinion (for what its worth) is to revisit FTP

within a CL program

OVRDBF     FILE(INPUT) TOFILE(YOURLIB/QTXTSRC) +
             MBR(YOURSCRIPT)
OVRDBF     FILE(OUTPUT) TOFILE(YOURLIB/FTPLOG)
FTP        RMTSYS(&SITE)
DLTOVR     FILE(*ALL)

where &SITE is the IP address of the windows 2000 server

then in the member YOURSCRIPT, within QTXTSRC within the library YOURLIB is
the following

username    password
CD directory-name
put yourlib/filename pcfilename.txt
quit


You may have to do some tweaking of the member YOURSCRIPT
but you can play around yourself

on the command line type
ftp '999.999.999.999'
press Enter
where 999.999.999 is the ip address (same as &site)
enter the username as in the script and press Enter
enter the password as in the script and press Enter
you are now in the windows 2000 server
type
?
and press enter
This is the help
Good luck



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill
midrange-l-bounces@xxxxxxxxxxxx wrote on 08/30/2007 02:24:18 PM:

> Hi.
>
> Yes that helps, but the problem is that the file has to be copied
> automatically.
>
> I already have the query running at a specific time. Now I need that the
> file (witch is the result of the query) move/copy automatically to a
> folder that the windows application can reach it, in order that it can
> read the file.
>
> The problem with the iSeries is that it's always asking for the
> password. If it could be possible to eliminate the password part, maybe
> it could be possible to schedule the windows to run the *dtf.
>
>
>
> Thanks,
> Marco Silva
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
> Sent: quinta-feira, 30 de Agosto de 2007 19:15
> To: Midrange Systems Technical Discussion
> Subject: RE: CPYTOIMPF
>
> Hi Marco
> if you are using Client Access, you can click on Actions at the top of
> the
> Client Access window and choose Receive file from host
> In this window you have your i-series portion and your pc portion
> Does this help?
>
>
>
> Alan Shore
>
> NBTY, Inc
> (631) 244-2000 ext. 5019
> AShore@xxxxxxxx
> "If you're going through Hell, keep going" - Winston Churchill
>
> midrange-l-bounces@xxxxxxxxxxxx wrote on 08/30/2007 02:03:17 PM:
>
> > Hi guys,
> >
> > Thanks for your time.
> >
> > I'm trying to copy a file from:
> > Library: eiqry01
> > File: itemmaster
> >
> > I need to transform this file to a txt file in order that another
> > application can read it.
> >
> > Well my first idea was to copy this file directly to a windows 2000
> > server share, but if it's not possible, maybe if I can transform this
> > file (eiqry01/itemmaster) or copy into another library that can be
> > accessible from windows.
> >
> >
> > Is there's another way to turn accessible this file so a windows
> > application can read, please tell me.
> >
> >
> > I also heard about FTP, but with that I'm even lost.
> >
> >
> > Any ideas?
> >
> > Thanks,
> > Marco
> >
> >
> >
> >
> >
> >
> >
> >
> > Obrigado,
> > Marco Silva
> >
> >
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
> > Sent: quinta-feira, 30 de Agosto de 2007 18:47
> > To: Midrange Systems Technical Discussion
> > Subject: Re: CPYTOIMPF
> >
> > Hello Marco,
> >
> > > Who help me with the command CPYTOIMPF?
> >
> > I'll try -- what do you want to know?
> >
> >
> > > I don't know is it is to ask to much, but if it possible could you
> > send
> > > me a print?
> >
> > I see from the MI list that what you're really looking for is the
> manual
> > page for the CPYTOIMPF command.  IBM has lots of info in the
> Information
> > center.  Take a look:
> http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/d
> > m/rbal3usingcpyto.htm
> >
> > Here's an example.  Let's say I have a file named CUSTMAS in a library
> > named FILES.  I want to copy it to my PC, which is named 'scottk'.  On
> > that PC, I've shared a directory named 'Incoming' and I'd like to put
> > the file there.
> >
> > I want the PC file to be in ASCII and in tab-delimited format, so I
> can
> > open it in Excel.  Here's what I type:
> >
> >   CPYTOIMPF FROMFILE(FILES/CUSTMAS)
> >             TOSTMF('/qntc/scottk/Incoming/custmas.tab')
> >             FROMCCSID(*FILE)
> >             STMFCODPAG(*PCASCII)
> >             DTAFMT(*DLM)
> >             RCDDLM(*CRLF)
> >             STRDLM(*NONE)
> >             FLDDLM(*TAB)
> >
> >
> > Here's what it means:
> >
> > TOSTMF tells it where to put the resulting stream file.  On i5/OS, any
> > IFS path that starts with /QNTC tells it to use Windows Networking.
> It
> > will use Windows Networking to find the host named 'scottk', and it
> will
> > send the file to the shared directory named 'Incoming', and the file
> on
> > the PC will be called 'custmas.tab'
> >
> > FROMCCSID tells the system what the CCSID of the existing data file
> is.
> >    The special value *FILE means it'll look for the CCSID in the file
> > description.  On my system, it happens to be CCSID 37 which is the
> > flavor of EBCDIC that's used where I live in the United States -- but
> I
> > don't have to hard code that, because *FILE will get it from the file
> > itself.
> >
> > STMFCODPAG is the code page of the stream file it's creating.
> *PCASCII
> > means that it'll calculate an ASCII code page that's equivalent to the
> > EBCDIC one that was specified in the preceding parameter.   Since I'm
> > using EBCDIC for the USA in my example, it'll find an ASCII that
> > supports the same characters.
> >
> > DTAFMT tells whether the resulting file should be a delimited file
> > (which is what my example shows) or a fixed file.  The difference is
> > that delimited files have variable-length fields, and each field is
> > separated from the others by a special character. Software reading the
> > file will search for this character to know where the field ends, and
> > the next one begins.  By contrast, in a fixed format file, the fields
> > always start and end in the same positions in the record, so the
> > software would need to have a list of from/to positions for each
> field.
> >   Delimited files are more common in data interchange applications
> > because they're more "self-describing" (i.e. your software doesn't
> have
> > to have from/to positions coded into it, it can figure it out from the
> > data itself)
> >
> > RCDDLM specifies the special character(s) that denote the end of the
> > record.  *CRLF is the standard on Windows systems, *LF is the standard
> > on Unix.  Old Apple systems used *CR by itself.
> >
> > STRDLM lets you specify characters that go around each character
> field.
> > CSV files typically want double quotes (*DBLQUOTE) but most other file
> > formats don't use this.
> >
> > And FLDDLM is the character used (in delimited files) to denote the
> end
> > of one field and the start of another.  In my example, I used *TAB
> > because I was making a tab delimited file.  For CSV you'd use a comma.
> > For a fixed-format file, you'd set this to *NONE.
> >
> > Hope that helps.
> > --
> > 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.
> >
> >
> > --
> > 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.
> --
> 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.
>
>
> --
> 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.