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.

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.


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


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



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:


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


UltraQuest created database

Used to further access same data directly from UltraQuest



Learn More

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.

Product Resources
Want to learn more about this product? Every download relating to a particular product can now be accessed in one location. Click here to continue

Useful Links
IBM Mainframe servers
Velocity Software