The FILETYPE parameter specifies whether the database file description describes data records or source records.
Further, the FILETYPE parameter specifies whether each member of a database file being created is to contain data records or source records (statements). For example, the file could contain RPG source statements for an RPG program or data description source (DDS) statements for another device or database file.
Records in a source file must have at least three fields: the first two are the source sequence number field and the date field; the third field contains the source statement. These three fields are automatically provided by the i5/OS™ when a source file is created for which no DDS is provided; additional source fields can be defined in DDS. The length of the sequence number field must be six zoned digits with two decimal places. The length of the date field must be six zoned digits with no decimal places.
The source sequence number and date fields are added to the source record when:
The fields are added when an inline data file (specified as the standard source file format) is read from the device. The spooling reader places a sequence number in the source sequence number field and sets up a zeroed date field.
If those fields already exist in records read from the device, they are not changed. If the records in a database file are in source format and are being read as an inline data file in data format, the source sequence number and date fields are removed.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.