Flat File Data Sources - trillium_discovery - trillium_quality - 17.1

Trillium can import or link to data from any of the following flat file data source:

• Flat files: Fixed-length files described by a schema. Includes those files created by Trillium Quality processes in the Control Center.

  Note: Duplicate row ID (formerly checksum) calculation, sparse row counting, and row length statistics are not supported for Trillium connections.

• Delimited files

  • With ASCII, extended ASCII, or hexadecimal delimiters

  • With or without ANSI SQL DDL

• COBOL flat fixed length files

  • Data must match copybook layout

  • Various character encoding including ASCII, EBCDIC, and Unicode

  • Big or little Endian byte orders

  • One- or two-byte data alignment

  • Common COBOL copybook features such as:

  • REDEFINES clause

  • OCCURS clause

  • FILLER clause

  • COBOL data types: 9, X, A, B

  • Numeric storage formats: COMP-3, Packed-DECIMAL, COMP, COMPUTATIONAL, or BINARY

  • Comments beginning with *

  • Descriptors such as USAGE IS, DISPLAY, SEPARATE, LEADING, and TRAILING

  • Unnamed fields

  • Unsigned COMP-3 fields

    Note: Copybook features such as Multiple Record Types and OCCURS DEPENDING must be manually removed from the Copybook and the data file prior to loading into the Trillium.

    Note: For more information about supported and unsupported COBOL copybook features, see COBOL Copybooks.