Complex File Support
The Arbutus technology has the ability to present virtually any
data file in a table format. This capability is not limited
to simple fixed length files, but extends to all file formats
supported by the IBM mainframe and AS/400 platforms, and
most formats supported by other platforms. Each format
is automatically and transparently converted to a table
format appropriate for your application.
| |
zSeries/zOS |
iSeries/AS400 |
Databases Supported: |
| |
DB2 |
DB2 |
| |
IMS |
|
File Organizations Supported: |
| |
VSAM (ESDS, KSDS, RRDS) |
IFS |
| |
ISAM |
Spool |
| |
QSAM (Flat Files) |
Flat Files |
| |
Partitioned or Sequential |
|
| |
GDG |
|
| |
Blocked, Unblocked or Spanned |
|
Record organizations supported:
- Fixed record length
- Variable record length
- Standard Variable length formats
- Application specific custom variable formats
- Unlimited number of redefines supported
- Specific record type(s) may be selected from the file
- Multiple record types may be “virtually flattened” as the file is read,
presenting the combined information as a single relational table
- Repeating Blocks (OCCURS)
- Single field repeating
- Block of information repeating
- Variable frequency (OCCURS DEPENDING ON)
In addition to supporting any record organization, Arbutus’ technology
also reads virtually every data type you may encounter. As with record
organization, each of these types is automatically converted to a
format appropriate for your application.
Field types supported:
Mainframe specific data types:
- EBCDIC (PIC X)
- Packed (COMP-3)
- Unsigned Packed
- Zoned (PIC 9)
- Binary (COMP-1)
- Display formatted numbers (including any punctuation)
- Float
- Date (any format supported, including Y2K specific techniques)
- Century specifier
- YY or YYYY
- MM or MMM
- DD or DDD
- Any formatting characters
- Serial dates, with any base
Other data types:
- ASCII
- Float (IEEE, BASIC, DEC)
- Reverse Binary (Little Endian)
- Logical (Y/N, 0/1, T/F, etc. )
- Half-byte
- Bit
- Unisys Packed
Each of these data types is supported in any length that is appropriate for the type. In
addition, all Arbutus Servers are fully compatible with all the above data types.
Virtual columns may also be defined. These
allow any computation, or set of computations to be dynamically calculated and presented as a
field, as if was part of the data.
|
