CA-Datacom Data Access

The Ivory^® Data Access SQL engine provides direct access to CA-Datacom databases from a variety of open system environments or mainframe platforms using standard SQL syntax. Ivory Data Access supports the join of information from CA-Datacom with information from other, non-relational mainframe data sources (i.e. IMS, DL/1, DB2, VSAM, ADABAS, 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 CA-Datacom 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 from the CA-Datacom Dictionary 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 CA-Datacom data with information from other data sources (such as PDS/PS, IMS, DL/1, DB2, VSAM, ADABAS, 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