The Ivory® Data Access SQL engine provides direct access to sequential files from a variety of open system environments or mainframe platforms using standard SQL syntax. Ivory Data Access supports the join of information from sequential files with information from other, non-relational mainframe data sources (i.e. IMS, DL/1, DB2, VSAM, ADABAS, CA-Datacom, PDS/PS), presenting the end user with relevant data in familiar relational data views. Ivory Data Access provides fast, efficient data access that is flexible and transparent.
Features:
- Dynamic access to sequential files
- Supports provided for:
- Sequential files (DSORG=PS for OS/390, SAM and VSAM managed files for VSE)
- MVS/PDS Member
- JES output
- POWER queues (VSE)
- VSE Library Member
- CICS Temporary Storage
- CICS Transient Data
- Intelligent import of meta-data from copybooks to obtain table and structure definitions for relational access
- Support for redefinitions
- Support for virtual tables for record structures that contain OCCURS an OCCURS DEPENDING ON
- Automatic recognition and presentation of key information
- Support for standard security systems (RACF, ACF2, etc.)
- Use of standard SQL commands to provide transparent integration of sequential file data with information from other data sources (such as CA-IDMS, IMS, DL/1, DB2, VSAM, ADABAS, CA-Datacom)
- Support for individual user or departmental data views
- Support for any connectivity method, such as TCP/IP, SNA, MQ-Series and HLLAPI
Click here to request additional product information