Attunity Connect supports the following Enscribe file types:

  • Key-sequenced.
  • Entry-sequenced
  • Relative: The Enscribe driver exposes a column called # for the relative record number. The # column can be used in SQL statements just like any other column. The Enscribe driver exposes a virtual index on the # column. It implements the index functionality using the Enscribe API.
  • Unstructured: Unstructured files that keep fixed length records are supported. The unstructured file is read using a read-ahead buffer of 4K. The Enscribe driver also supports RBA usage. The RBA holds the relative record number in the stream file where the record begins. The RBA column can be used in SQL statements just like any other column. Set the record organization in the metadata to unstructured.