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, AS/400
|
|
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 data types above.
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 part of the data.
See also: Mainframe Data Sources Accessed by Arbutus
.
.