UltraQuest IDMS Interface

The UltraQuest Interface for IDMS maximizes your investment in IDMS with:

	UltraQuest Reporter for end-user reporting. UltraQuest Applications for Web-based application development.

 Easy access to IDMS databases

UltraQuest's interface to IDMS offers flexible and efficient access to data in either IDMS or IDMS/SQL. UltraQuest's reporting, decision support, database browser and application development facilities provide users with a full range of capabilities that address a broad spectrum of reporting and analysis requirements.

UltraQuest's interfaces to other mainframe data sources, such as DB2 for OS/390, DB2 for VM, IMS, and Teradata database, make it easy to link information from multiple sources with IDMS data. Users have a consistent view of the data because UltraQuest retrieval and analysis commands operate identically on all supported file types with no special sub-environments to access.

Workstation users can also access mainframe data, including IDMS, using RP/Server, Select's high-performance middleware.

Designed for Efficient Use

UltraQuest's interface to IDMS features an interactive Schema generator that simplifies and speeds the process of data definition. UltraQuest's interface is designed to use the IDMS database efficiently by communicating UltraQuest requests directly to IDMS and processing the resulting data. The UltraQuest Schema greatly reduces the amount of program coding required since it defines items just once and makes them available to all users. The information needed to access IDMS data is stored in the UltraQuest Schema, eliminating the need to retrieve information each time that data is accessed.

The UltraQuest interface supports "smart" data selection when IDMS keys are used as UltraQuest keys. UltraQuest support efficient keyed retrieval for IDMS CALC keys, INDEX keys and sorted set keys.

UltraQuest also support efficient retrieval of IDMS logical records by converting UltraQuest SELECT expressions into IDMS WHERE expressions.

Support for IDMS Version 12

With support for IDMS Version 12, which provides for the IDMS/SQL Option, UltraQuest can provide read-only access to IDMS/SQL tables by passing an SQL SELECT statement directly to the database engine.

	Benefits Full-featured reporting and analysis. Efficient data retrieval and processing. Support for IDMS/SQL Option. Powerful data control and security. Simplified and fast data definition. Access to multiple data sources maximizes all your information resources. Performance features for use in production environments.

Overview of Features
Version Support - Versions 10 and 12

	Environments VM, z/VM, z/OS, or OS/390. Local or central version mode. Access to IDMS subschemas. Access to data in secondary dictionaries and databases. Interactive or batch execution. Session Manager.   Data Access IDMS, IDMS/SQL.   Schema Generation Schema language describes records to be accessed from the IDMS subschema and defines additional computations. Interactive Schema generator simplifies and speeds the process of data definition. Compiled Schema provides description of structural relationships. SWITCH facility dynamically inverts member/owner relationships. Support for long EXTNAME names in all UltraQuest commands, dot notation and with FROM keyword.   Access to Multiple File Types Build databases containing data from multiple sources - VSAM, QSAM, DB2 for VM, DB2 for OS/390, and Teradata Common view of different data sources UltraQuest retrieval and analysis commands operate identically on all file types with no subenvironments to access   Data Screening Screening methods: SELECT command, WHERE and TEST clauses Limit instances retrieved at system, schema or user level Optimized IDMS retrieval for screening conditions involving CALC keys   Security Features Security down to item level Support for IDMS security features Protection through: Passwords Procedures during initial database access Procedures during record retrieval   For Production Environments Performance features for use in production environments Resource efficiency facilities: Automatic data screening SELECT command applies selection criteria to data accessed for all subsequent retrievals Reduced volume of records sent back to UltraQuest by IDMS Server TEST clause for testing report output Control the UltraQuest instances retrieved by a UltraQuest retrieval command, set either in access profile or used interactively DBPROC clause identifies IDMS procedures to be executed when master or segment is first accessed REMOVE command prevents segments or items from being accessed. Used interactively or procedurally. MODIFY command changes the name or attributes of database entries. Used interactively or procedurally.   UltraQuest's IDMS/SQL Interface Read-only access to IDMS/SQL tables Passes SQL SELECT statements directly to database engine Dynamic SQL statements compiled dynamically at run time Result of SQL SELECT Report UltraQuest created database Used to further access same data directly from UltraQuest

To find out more about how Select Business Solutions can help you either Contact Us, or visit our Product Resources area for all the latest related downloads.