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 fieldsNote: 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.
-