In this session you take an application that includes CICS, IMS, and DB2 and contains Assembler programs and get it working on Mainframe Express.
SQL Option and Host Compatibility Option are alternative facilities for handling a DB2 application. In this session you use SQL Option. See the chapter Assembler, CICS, IMS, DB2 (Host Compatibility Option) for a similar session using Host Compatibility Option.
You need to have read the chapter Start Here for the Tutorials and worked through the first session, Using Mainframe Express before you do this session. You also need to have worked through the first session on each of the Options used.
You need to have installed the Assembler, CICS, IMS and SQL Options to do this session.
We assume you are familiar with Assembler, CICS, IMS and DB2 on a mainframe.
The demo application used in this session is a simple application that you might have downloaded from a mainframe. In this session, you get it working on your PC. It consists of several COBOL programs, one Assembler program, a BMS file, a DB2 database, and an IMS database. You create some CICS transactions to run it. The application is a suite of transactions to maintain employee records.
If you installed both SQL Option and Host Compatibility Option, ensure SQL Option is active, as described in the section Preparation in the chapter DB2 Applications (SQL Option).
If you have closed Mainframe Express, open it as before. If any project window or other windows are open, close them.
In this session you:
To create the project:
You now get a page asking which of the installed options this project uses.
Because you have said this project uses CICS, you get the pages that relate to CICS.
Because you have said this project uses SQL, and you installed SQL Option (rather than Host Compatibility Option), you now get a page asking for details of the SQL server the project uses.
Mainframe Express checks that an SQL server is running on your computer. When it finds that none is, it displays a dialog box asking if you want to start one, and if it should check in future.
You need the server running so you can use the SQL Wizard and run the application. You could start it later from the Tools menu, but it's convenient to start it here.
The SQL server starts, with its window minimized. You can click it on the Windows taskbar if you want to see it, but as you don't need to watch it you can leave it minimized.
To add your files to the project:
The files are added to the project.
The DB2 database used in this session is installed with Mainframe Express. You run the SQL Wizard with the supplied DDL file to add a table and data:
A message appears saying "Connecting to database". The SQL Wizard starts and runs minimized (you'll see it on the Windows taskbar). Guided by the .sql file, it creates a new database, adds a table and inserts table data, and then exits.
We want the BMS compiler to recognize certain features recognized by the SDF BMS compiler on the mainframe.
SDF features are used in the BMS mapset used in this session.
To build the project:
The build finishes with "Build finished with no errors".
You run the IMS Database Utility with the supplied .dbu file to create an IMS database for use by this application:
This displays a list of the IMS databases in the project. There is one - CICSDLID.
The list disappears. The Database field on the IMSDBU window is now set to CICSDLID.
A screen appears where you can specify details of the Load operation.
Messages appear, showing the Load starting and successfully completing.
To define CICS transactions for the project's programs:
|CDI1||CICSDLI1||Program to handle the menu|
|CDI4||CICSDLI4||Program to handle listings|
|CDI5||CICSDLI5||Program to handle updates|
|CDI6||CICSDLI6||Program to handle displays.|
To run the application:
The Application Output window appears, emulating a 3270 terminal. Messages appear, showing the application starting up, then the application displays its first map.
We will make a simple change to one employee record.
Hide the Application Output window.
Shut down the SQL server - click in its entry on the Windows taskbar to select it, then press Esc. It may take a few seconds to respond.
Close the project. If you want to take a break before going on to the next session, you can close Mainframe Express.
Return to the Tutorials Map in the chapter Start Here for the Tutorials and choose which session to go on to next, depending on your interests.
Comments on the books? Click Send Us Comments.
Copyright © 2001 Micro Focus International Limited. All rights reserved.
This document and the proprietary marks and names used herein are protected by international law.