The challenge has neither a right or wrong answer. The challenge requires development of data processing services for the Flours, Sugars, and Oils Company.
COBOL source code and 2 DB2 tables are provided along with a minimum requirement to complete the challenge. The minimum requirement is a matter of following the instructions enabling interative execution of the COBOL program without any COBOL programming source code modifications.
Develop business helpful application services beyond the minimum requirement to distinguish your application from other contestants during the judging process. The quality and usefulness of your business application services will contribute to your chances of being a top place winner.Judges will execute each contestant challenge 15 COBOL program checking for:
1) Successful program execution
2) Successful program execution of SQL
and essential to be selected as a top place winner:
3) Program enhancements that distinguish your application services from the others
You are at liberty to change any or all of the program.
Learning System ID special instructions for this challenge.
Use your existing DB2 table, T#####, with the client profile data
If you decide to create one or more additional DB2 tables, each table needs a unique table name
Each new DB2 table can be uniquely identified as follows:
A#####, B#####, C##### - where ##### is the 5 digits of your ID
If you decide to create a new DB2 table, DCLGEN instructions are provided to generate the COBOL source code variables declaring the new DB2 table in the program.
JCL is provided to precompile the COBOL source expanding the EXEC SQL statements, create the executable module, and bind the DBRM module into a required DB2 plan. The DB2 plan name and the COBOL executable program name is required to execute the program.
Summary of previous challenges that can help you complete the final challenge:
- COBOL programming language
- COBOL access to Flours, Sugars, Oils Company sequential data set
- COBOL DB2 API to Flours, Sugars, and Oils company DB2 table
- Your ID was GRANTed CREATETS, CREATETAB, LOAD ON DATABASE MTM2017
- You created a DB2 table and loaded FSO.CLIENT.PROFILE into your DB2 table
- A COBOL program, DB2FSO, was provided to interact with your DB2 table
- JCL procedure to build COBOL program executable and a DB2 Plan
- Interactive execution of COBOL program using DB2 table as a data source
Instructions to meet minimum requirements:
run prog(fso) lib(load) plan(z#####b)
Upon review of the COBOL source code, hlq.SOURCE(FSO), you will see the code uses 2 DB2 tables. Your client table, T#####, is select/update/insert capable, The FSO.FSOSKU table, asis, is only select capable.
The FSO.FSOSKU table only has 3 product records with SKU identifiers, F1001, S1001, and Q1001. The column names with respective data types can be found in the FSO COBOL source code.
If you decide to create another data source for reading, writing, or updating, it can be any data set type, SEQ, PDS, VSAM, Unix file, or DB2 table.
If you decide to create another DB2 table, copy hlq.SQL member STEP2 to a new member name, then modify to create the new tablespace, table, and optional unique index. Careful here. Comment the drop S##### tablespace statement to avoid deleting your T##### client profile table unless you really mean to drop your existing tablespace and table as a part of a redesign of your new application services program.
Many SQL educational websites explain the SQL DML insert and update statements.
Figure 94. is a simple diagram of the insert statement syntax.
DB2 for z/OS Data Types
Competing in the final challenge demonstated your ability to be a z/OS application developer. Your completion of Part 3 demonstrates your willingness and capability to be hired by employers needing those attributes to learn from senior IBM Z technicians supporting some of the most critical systems responsible for the day to day business transactions.