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 joining of data from sequential files with information from other 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 and z/OS, SAM and VSAM managed files for VSE)
- MVS/PDS Member
- JES output
- POWER queues (VSE)
- VSE Library Member
- CICS Temporary Storage Queues
- CICS Transient Data Queues
- 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
