RE: cpyfrmimpf

Douglas,

Nope, the FDF is a separate file. I usually use a source member. Here's
an example:

RCACNO   1              10          0  
RCCKNO   11             20          0  
RCCAMT   21             30          0  
RCCPDT   31             36          0  
RCCODE   37             37          0  
*END                                   

There's someplace in the infocenter that describes the format in detail;
if my memory serves the above is:
FIELDNAM  STARTPOS      ENDPOS      ALLOW NULL

The field name match the field to which the data will be load in the DB
file.  I believe this is the same format as the FDF file used by the
iSeries Access data transfer utility.

Basically it describes the format of the stream file so that OS/400 can
map between the stream file and the DB file.  OS/400 doesn't expect the
fields between the stream file and DB file to be in the same order, have
the same size, or even the same number of fields (the DB file could
default to NULL or some other value for some fields.)

I'd be nice if there was an option to say, forget the FDF as the stream
file is an exact match to the DB file.  But that isn't the case.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx] 
> On Behalf Of Douglas W. Palme
> Sent: Thursday, February 02, 2006 2:13 PM
> To: Mid Range List
> Subject: cpyfrmimpf
> 
> I am trying to import some data from a fixed length file and 
> I keep getting 
> an error code 10.  In looking at the ref, error code 10 tells 
> me that the 
> system did not like the field definition file, but I thought 
> I could use the 
> source file (PF source) as the FDF, is this not the case? Suggestions?
> 
> Douglas
> 
> 
> If you bought it, it was hauled by a truck - somewhere, sometime.
> 
> -- 
> 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.
> 
>