Data Types for Which Whitespace Can Be Trimmed

The information in this section applies only to fields specified with one of the character-data data types:

• CHAR data type

• Datetime and interval data types

• Numeric EXTERNAL data types:

  • INTEGER EXTERNAL

  • FLOAT EXTERNAL

  • (packed) DECIMAL EXTERNAL

  • ZONED (decimal) EXTERNAL

    Note:

    Although VARCHAR and VARCHARC fields also contain character data, these fields are never trimmed. These fields include all whitespace that is part of the field in the data file.