Cover image for DB2 for the COBOL programmer
DB2 for the COBOL programmer
Garvin, Curtis, 1961-
Personal Author:
Second edition.
Physical Description:
volumes : illustrations ; 26 cm
General Note:
"Covers version 4.1"-- Cover of part 1.
Title Subject:
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 G385 1999 Adult Non-Fiction Central Closed Stacks

On Order



If you are looking for a practical DB2 book that focuses on application programming, this is the book for you. Written from the programmer's point of view, it will quickly teach you what you need to know to access and process DB2 data in your COBOL programs using embedded SQL. This second edition has been thoroughly updated and expanded to make it even more valuable to the programmer who is slugging it out on the job. You will learn: the critical DB2 concepts that let you understand how DB2 works; the basic DB2 coding features you will use in every program you write; how to use version 4 enhancements like outer joins and explicit syntax for inner joins; how to work with column functions, scalar functions, and subqueries to manipulate data; how to use error handling techniques and ROLLBACK to protect DB2 data; why program efficiency is vital under DB2... and more.

Author Notes

Curtis Garvin has 13 years of COBOL application programming experience working in MVS shops using DB2, IMS, and IDMS databases. He's also worked as a systems analyst in a shop where he was the DB2 and IDMS Database Administrator, RACF Security Administrator, and Data Administrator. He's used these years of practical experience to update and reorganize the classic 2-book series by Steve Eckols, DB2 for the COBOL Programmer, so that the books are even more useful to today's DB2 programmer.

Table of Contents

Introductionp. v
Section 1 The basics of DB2 programming in COBOLp. 1
Chapter 1 Introduction to DB2 and embedded SQLp. 3
Chapter 2 How to retrieve DB2 data from a single tablep. 41
Chapter 3 How to modify DB2 tablesp. 71
Chapter 4 How to use unions and joinsp. 103
Section 2 Other programming essentialsp. 143
Chapter 5 How to use advanced selection conditionsp. 145
Chapter 6 How to use column functionsp. 165
Chapter 7 How to use the data manipulation featuresp. 179
Chapter 8 How to use variable length data and nullsp. 215
Chapter 9 How to use subqueriesp. 235
Chapter 10 How to use the features for error processingp. 263
Chapter 11 How to maximize locking efficiencyp. 283
Section 3 Program development skillsp. 301
Chapter 12 How to use DB2I to prepare and run programsp. 303
Chapter 13 How to develop programs outside DB2Ip. 339
Chapter 14 How to use SPUFIp. 351
Chapter 15 How to use QMF to update tablesp. 371
Appendixesp. 385
Appendix A Source code generated by the DB2 compilerp. 385
Appendix B SQLCODE and SQLSTATE valuesp. 390
Indexp. 421