Flat files on iSeries (WAS: Help with capturing errors codes in .ASP code talking toDB2/400)

Joe,

to me, a flat file is a file with only one (long) alphanumeric field, 
period.

It can be created with CRTPF RCDLEN(xxx) or have a DDS, for me the 
determining factor is the one-big-alpha-field rule.

Just my two euro-cents.

Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----




"Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
19/02/2005 00:55
Please respond to Midrange Systems Technical Discussion

 
        To:     "'Midrange Systems Technical Discussion'" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: Help with capturing errors codes in .ASP code 
talking toDB2/400


> From: Dave Odom
> 
> an iSeries flat file.

I can't help much with ASP access, but I was wondering what an iSeries
"flat file" is.  Back in the day, a flat file meant a file with no
intrinsic format: for example, 80-byte card files.  You had to map the
fields yourself using data structures or the like.  On the iSeries, you
create such a file with a CRTPF command using the RCDLEN parameter.

Physical files and logical files with DDS are NOT flat files, by this
definition.  What in your terminology makes an iSeries file a flat file?
What is NOT a flat file?

Joe