× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.