|The NOMAD Interface for DB2 for VM provides the full functionality and power of NOMAD for application development and end-user computing to maximize your investment in DB2.|
|Provides cooperative processing solutions for conserving and taking advantage of all your system resources. The NOMAD Interface for DB2 for z/VM takes full advantage of the power of the DB2 database engine while supplementing its basic query and updating facilities with the full power of NOMAD, the most comprehensive tool for application development and end-user computing available today.
Users quickly benefit from NOMAD's complete non-procedural language for fast prototyping, its full range of easy-to-use reporting and analysis capabilities, and its fully integrated programming language with functionality comparable to PL/I and COBOL.
Using a common language and syntax within a single environment, and coupled with the DB2 database engine, NOMAD addresses the need for improved productivity and ease-of-use, as well as the concern for overall system performance.
Highly Integrated with DB2
NOMAD translates its commands into SQL statements, sending as much work as possible to DB2. Sorting and aggregation triggered by NOMAD's LIST command for reporting are done by DB2, with only the columns needed to fulfill the data request shipped back to NOMAD. Selective data listing can be performed efficiently through SELECT and LIST WHERE commands.
Global data maintenance is handled by passing set-level requests for CHANGE and DELETE as a single transaction.
Access rights are granted directly through DB2. Additional security can be provided with NOMAD passwords, database profiles, retrieval and update procedures. Concurrent access by multiple users and data sharing are handled by DB2.
DB2 tables can be created by NOMAD's data definition language using a single command, SCHEMA NEW. Conversely, SCHEMGEN provides an automated facility for describing pre-existing DB2 tables and views to NOMAD.
SCHEMGEN can also be used to describe system catalog information to NOMAD. The database administrator can then easily report from catalog information, which helps provide better control over data resources.
NOMAD interfaces efficiently with DB2 for VM because NOMAD itself is designed on a relational model. In addition, NOMAD provides important relational features not found in DB2:
|Using the NOMAD Interface for DB2
Accessing the Data
With the NOMAD Interface for DB2 a database can include not only data stored in DB2 but data stored in NOMAD's native relational database and external files such as ISAM, VSAM and QSAM. (With additional NOMAD interfaces, it can also include data from other DBMSs such as IDMS and Teradata )
The TYPE parameter on the MASTER statement indicates how data is stored. DB2 tables can be maintained using all of NOMAD's navigation and maintenance commands. Data stored in multiple files can be drawn together using NOMAD's relational facilities such as DEFINE EXTRACT and MERGE MATCHING.
NOMAD reporting, file creation and maintenance facilities work exactly as if the data were stored in NOMAD. NOMAD retains its concept of position, despite the fact that DB2 does not support such a concept. Thus, you have the ability to move backward and forward through the data.
Moving the Data
Moving data from a NOMAD database to an DB2 table is accomplished simply by adding the TYPE SQL parameter and issuing the SCHEMA REORG command. There is no need to worry about dumping and reloading data. The NOMAD Interface for DB2 does the work of creating a new table for you.
Using the Data
To use NOMAD with existing DB2 tables, you use SCHEMGEN, a menu-assisted Schema generator, which produces a basic NOMAD Schema from selected tables. This Schema can be edited to take advantage of NOMAD's extensive data-definition language to add headings, masks, limits, member checks, defined items and passwords. NOMAD also provides unique data types that include TEXT, fixed and varying arrays and time series, as well as NAME, FORMAT and PICTURE display formats. After the Schema is compiled, all of NOMAD's command language is available for application development, reporting and analysis.
NOMAD for Application Development and Reporting
View features in NOMAD for application development and reporting.
Additional Unique Features
NOMAD also provides commands that enable the user to dynamically:
|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.|
NOMAD Interface For DB2 For z/VM
|:: What's New|
|:: Follow us|