| Topic | Detail | Date |
| Sqlcode | This is the return code from the SQL call | |
| Declare cursor | This is needed in a COBOL program where more than 1 row will be returned. It is a SQL call which is typically coded in working storage | |
| Fetch | Fetch is a corresponding call to the declare cursor. It actually retrieves the row into the host variables that are coded in the declare cursor statement | |
| View | A view is an alternative representation of a DB2 table. It may contain all of some of the columns of the actual table. (The DBA usually references the table while the programmer usually is only concerned with the view | |
| Host variable | This must be defined & coded in the COBOL program to hold the data returned from DB2. It needs to be the same data type so if possible using fields in the dclgen is usually the best practice | |
| Dclgen | This is the COBOL copybook which gets generated by the DB2 catalog. | |