The Ivory® Data Access SQL engine provides direct access to IMS or DL/1 databases from a variety of open system environments or mainframe platforms using standard SQL syntax. Ivory Data Access supports the joining of data from IMS or DL/1 tables with data from other, non-relational mainframe data sources (i.e. VSAM, DB2, Adabas, CA-Datacom, CA-IDMS, 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, efficient IMS or DL/1 data access through automatic use of key information
- Support for SELECT, INSERT, UPDATE and DELETE commands
- Transaction support with 2-phase commit
- Intelligent import of meta-data to obtain table and structure definitions for relational access
- Optimizes access strategy through analysis of PSB and DBD definitions
- Support for logical databases and secondary indexes
- Support for multiple record types and segment structures
- Processes keyed and non-keyed segments
- Relational processing of IMS hierarchies through SQL commands or IMS path calls
- Support for virtual tables for segment structures that contain OCCURS and OCCURS DEPENDING ON
- Automatic detection and presentation of key information simplifies creation of relations and joins with other data sources
- Support for standard security systems (RACF, ACF2, etc.)
- Use of standard SQL commands to provide transparent integration of IMS data with information from other data sources (such as PDS/PS, VSAM, DB2, Adabas, CA-Datacom, CA-IDMS)
- 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
