Errors When Transferring Data from ASCII Text Files

When you transfer data from a workstation ASCII text file to an iSeries, eServer™ i5, or System i5® file, the following errors can occur:
  • A data field in the ASCII text file is too long for a field in the iSeries-, eServer i5-, or System i5-defined file. In this case, the data is truncated. This occurs when the description file defines the character data as longer than the field length specified for the system file.

    If the data transfers to an EBCDIC field, this error occurs only if the extra bytes are not spaces.

    If the data transfers to a hexadecimal field, this error occurs only if the extra bytes are not zeros. These extra bytes are truncated so the data fits into the specified field.

  • The value of numeric data is too large for the system field. The maximum value is used. This error occurs when:
    • Numeric data in the field does not fit into the specified number of bytes for the field.
    • The decimal value of a numeric field contains more digits than were specified for the field.

    The value of the field is set to the maximum value possible for the number of bytes and digits specified by the iSeries, eServer i5, or System i5.

  • Data in this field has too many decimal positions. The number is rounded. This error occurs when the number of decimal positions in the field is greater than the number of decimal positions specified on the iSeries, eServer i5, or System i5. These extra bytes are significant because the data rounds up if the first extraneous digit is 5 or greater, and rounds down if it is less than 5.
  • Data in this field is incorrect or does not match the data type. This error occurs when:
    • Nonnumeric data is found in a field that the file descriptions defined as numeric. The transfer request ends to prevent transferring incorrect data to the file.
    • ASCII numeric data is found that does not match the format the file description specified. An incorrectly positioned decimal point within the field could cause this error.
    • A value other than X'30' through X'39', minus, plus, or decimal point is found. A duplicated decimal point or minus is found. The transfer request ends to prevent transferring incorrect data to the file.
  • Data for this field is missing. The default values are used. This error occurs when a data field is defined, but the data is not in the file. This means that the end of the record is reached before all of the defined data is found.

    The field or fields for which data has been defined but not found then fill with default values and transfer to the file. The default values are EBCDIC spaces for character fields, or zeros for numeric and hexadecimal fields.

    To supply your own default values, use the default (DFT) keyword in the data description specifications (DDS) for the file.

  • Extra data is found at the end of this record. The extra data is not transferred. Data found at the end of this record and not defined by the system data definitions or workstation file-description file is not transferred to the system file, because no definitions exist to define the data and how it should change.

When you transfer data from an ASCII text file to an iSeries, eServer i5, or System i5 file without using a file-description file, any extra data found past the record length specified for the file is not transferred.