大型机上的DB2 for the COBOL Programmer part 2

DB2 for the COBOL programmer Part 2 ============================================================ Thank you for purchasing DB2 for the COBOL Programmer Part 2. This README file contains information about the downloadable files that can be used with this book. To read this file on screen, use the Page Down and Page Up keys. To print the file, open it in any Windows word processing program and choose the Print command from the File menu. ============================================================ List of the downloaded text files: ============================================================ PROGRAMS JCL SQL PROC CLIST -------- --- --- ---- ----- CALLCUST BINDPKG PLANTBL DSNHCOB2 DYNAM3CL DB2DIN1 BINDPLN DB2DIN2 COMPILE DYNAM1 PREPSP DYNAM2 DYNAM3 SYMBOLIC EMPLTRNS MAPSETS MAPS GETCUST ------- -------- DINSET1 DINMAP2 DINSET2 ============================================================ Chapter 3 - How to use dynamic SQL ============================================================ Text file Description --------- ----------- DYNAM1 A COBOL program that uses the EXECUTE IMMEDIATE statement to delete rows from temporary work tables that contain customer data DYNAM2 A COBOL program that uses the PREPARE and EXECUTE statements to delete rows from temporary work tables that contain customer data DYNAM3 A COBOL program that uses a fixed-list SELECT statement to display data from a range of rows in temporary work tables that contain customer data. COMPILE JCL that calls the DSNHCOB2 procedure and binds the DYNAM3 program to a package. DSNHCOB2 A DB2 procedure for precompiling, compiling, and link-editing a COBOL program. BINDPLN JCL for binding the collection (MMACOLL) that will contain the DYNAM3 package into a plan. BINDPKG JCL for bindig the DYNAM3 program to a package in the MMACOLL collection. DYNAM3CL A CLIST to run the DYNAM3 program. ============================================================ Chapter 4 - How to work with distributed data ============================================================ Text file Description --------- ----------- EMPLTRNS A COBOL program that uses DRDA to transfer employees from one site to another. Table used: EMPLOYEE. ============================================================ Chapter 5 - How to create and execute stored procedures ============================================================ Text file Description --------- ----------- GETCUST A stored procedure coded in COBOL that retrieves a row from the customer table. Table used: CUSTOMER. CALLCUST A COBOL program that displays information from a row in the customer table. The program calls the GETCUST procedure to get the customer information it displays. PREPSP JCL for preparing the GETCUST stored procedure. ============================================================ Chapter 7 - Basic CICS/DB2 programming techniques ============================================================ Text file Description --------- ----------- DB2DIN1 A CICS program that displays customer information. Table used: CUSTOMER. DINSET1 The BMS mapset for the DB2DIN1 program. MAPASSM JCL to assemble the DINSET1 mapset. ============================================================ Chapter 8 - How to browse DB2 data in a CICS program ============================================================ Text file Description --------- ----------- DB2DIN2 A CICS program that browses customer data. Table used: CUSTOMER. DINSET2 The BMS mapset for the DB2DIN2 program. DINMAP2 The customized symbolic map for the DB2DIN2 program. ============================================================ Chapter 13 - How to get performance analysis data using the EXPLAIN statement ============================================================ Text file Description --------- ----------- PLANTBL An SQL statement that can be used in SPUFI to create the MM01.PLAN_TABLE.