Copyright © TIBCO Software Inc. All rights reserved
Copyright © TIBCO Software Inc. All rights reserved


Chapter 1 Overview : Supported File Types and Data Types

Supported File Types and Data Types
The adapter supports a FileType parameter designation of SEQ only. Keyed or random access is not currently supported.
Both FilePublisher and FileSubscriber support the following numeric (non-text) data types:
The rightmost four bits of a byte are called the numeric bits (N) and normally consist of a code representing a decimal digit. The leftmost four bits of a byte are called the zone bits (Z), except for the rightmost byte of a decimal operand, where these bits might be treated either as a zone or as a sign (S).
Binary (COMP and COMP-4)
A binary number occupying 2, 4, or 8 bytes of storage and is handled for arithmetic purposes as a fixed-point number with the leftmost bit being the operational sign.
Each byte contains two decimal digits (D), except for the rightmost byte, which contains a sign to the right of a decimal digit.
A 4-byte single-precision, floating point number. COMP-1 fields do not require a precision definition tag.
An 8-byte double-precision, floating point number. COMP-2 fields do not require a precision definition tag.
 
Field Precision and Length
The precision of a field is its length and number of decimals, and is specified using the “precision” tag. The format is precision="n,p" where n is the number of digits for the number (including decimals) and p is the number of decimals.
The length of a field in a record depends on the numeric format and specified precision in the field.
Zoned Type:  Zoned numbers occupy 1 byte of storage for each numeric digit specified.
Binary Type:  Binary numbers occupy 2, 4, or 8 bytes of storage, depending on the specified precision: 2 bytes: n from 1 to 4; 4 bytes: n from 5 to 9; and 8 bytes: n from 10 to 18.
Packed Type:  Packed numbers occupy from 1 to 15 bytes of storage. The number of bytes is determined from the formula n/2 + 1. For example, a field with precision="7,2" would occupy 4 bytes of storage.

Copyright © TIBCO Software Inc. All rights reserved
Copyright © TIBCO Software Inc. All rights reserved