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

[Michael_Schutte@xxxxxxxxxxxx]

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.