Re: Transfer a text file from the IFS (revised)

CPYFRMIMPF will handle fixed formatted files. DTAFMT(*FIXED) needs to
used and so does. FLDDFNFILE(yourlib/yourfile/yourmember)

Field definition file (FLDDFNFILE) - Help

Specifies the field definition file which defines the format of the data
when *FIXED is specified for the Record format of import file (DTAFMT)
parameter. If DTAFMT(*FIXED) is specified, this parameter is required.

The field definition file can be any of the following file types:

o source physical file

o DDM file

o distributed physical file

o program-described physical file

o externally-described physical file with one field.




Michael Schutte
Admin Professional
Bob Evans Farms, Inc.



midrange-l-bounces@xxxxxxxxxxxx wrote on 02/25/2008 02:22:56 PM:

Thanks to all for the responses,

I receive a file on the IFS from a vendor. Not sure what format it is

in,

but if put a .txt extension, and view the contents with Notepad, it

appears

fixed length. There are no delimiters.

I plan to have a process that runs daily from a scheduler that will

process

this file. I thought it would be easy to just move it to a DB2 and go

from

there. But my attempts to use the cpyfrmimpf to copy it into a physical
file have not worked.

I did ftp it to my C drive, then again to DB2, and processed it without
issue. Can I use ftp to get it from the ifs? My first attempt at that

did

not work.

Thanks, Tim



message: 6
date: Mon, 25 Feb 2008 12:39:28 -0600
from: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
subject: Re: Transfer a text file from the IFS

Hi Tim,

What's the easiest was to transfer a text file from the IFS to a
physical file on the 400.

"cat" is probably the "simplest". But, is it right for you? Hard to

say.

CPYFRMSTMF and CPYFRMIMPF are relatively simple -- when they work -- and
probably more familiar to someone with an i5/OS background. But are
they right for you?

It's really hard to say what's right for you, since we don't know the
format of the text file (plain? flat file? delimited? markup? something
else?) and we don't know what you plan to use it for.


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