Assignment #9 – Screen Handling and Database
This assignment relates to the following Course Learning Requirements:
CLR 7: Debug COBOL program problems using manual methods and computerized tools.
CLR 8: Demonstrate facility with the prescribed operation system.
Objective of this Assignment:
The objective of this assignment is to demonstrate the MicroFocus Screen Section and vendor additions that can be used to make quick user interfaces for COBOL programs within a command shell. You will demonstrate your knowledge of the screen extensions by answering questions and creating your own screen and modifying the existing screens.
Pre-Assignment Instructions:
1.
Launch Visual COBOL for Eclipse
2.
Create a new COBOL Project called Assignment #9
3.
Copy the
ADSAMP.CBL
source file to your Eclipse workspace and include it in your project.
Assignment Tasks:
Exercise #1 (Full Screen demonstration and code analysis)
1)
Open the ADSAMP.CBL source file in the Visual COBOL for Eclipse editor.
2)
Analyze the code before running the program.
3)
Run the code and test the screen features.
Read the following guide to get an understanding on how to enable and disable user Function keys.
https://www.microfocus.com/documentation/visual-cobol/VC23/VS2012/BKCICIADISS035.html
4)
Answer the following questions:
a)
What does the key do?
|
Answer:
|
b)
What does pressing Alt+ keys together do?
|
Answer:
|
c)
How does F1 display the help menu? Where are the display statements?
|
Answer:
|
d)
What would you have to do to enable user key? Try it out before answering.
|
Answer:
|
e)
What would be the steps needed to create another screen?
|
Answer:
|
f)
How would you enable or disable consecutive keys?
|
Answer:
|
Exercise #2 (screen layout modifications, enable key, and new screens):
1)
Modify the source program to add entries for the user’s telephone and gender.
2)
Enable the user key for input.
3)
Create a new screen (for display only) to display your name, student ID and Program of Study.
4)
Ensure that pressing will navigate to that screen. Pressing any key from that screen will return to the main screen.
5)
Update the main screen to include a description for the functionality of F5. (In between F1 and Escape)
Upload your assignment, your modified source code and a screenshot of your new screen to Brightspace.
Exercise #3 (Enable the SQL Pre-Processor)
1)
Open the
DatabaseIntegration.cbl
source file in the Code Editor window. You will notice pattern errors throughout the source code listing mainly on the EXEC SQL verbs. The pre-compiler is not liking these statements.
2)
To overcome this, find your source file in the COBOL Explorer window, right-click the file and select Properties.
3)
Next, navigate to COBOL -> SQL Preprocessor and select the following features:
·
Enable file specific settings
·
Use SQLPreprocessor.
Before clicking ‘Apply and Close’, notice the preprocessor type.
![Graphical user interface, application<br><br>Description automatically generated]()
Exercise #4 (Analyse and Run through the application)
1)
Run through the application and note the Working-Storage section and steps in the Procedural Division to open the ODBC connection, create the cursor, fetch from the cursor and display the record data that was returned. It is important that you understand how the program works before proceeding to the next exercise.
2)
View the final output when the program is completed.
Exercise #3 (Program enhancements)
1)
Enhance the code to fetch two additional fields and have them displayed in the terminal window.
·
Book: Publication Year
·
Patron: State
2)
Update the Identification Division with your name and student ID
3)
Capture a screenshot of your output after the updates.
Upload your update source code and screenshot to Brightspace.