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.

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

 

 

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 DB2
IBM Mainframe servers
Velocity Software
Teradata