Fixed-Length Flat File Data Sources - trillium_discovery - 17.2

Trillium Administration Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
17.2
Language
English
Product name
Trillium Discovery
Title
Trillium Administration Center
Topic type
How Do I
Overview
Installation
Configuration
Reference
First publish date
2008
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T06:51:21.336195

Discovery Center can import or link to data from the following fixed-length, flat file data sources:

  • 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 data 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
    • Supports 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 Discovery Center.