|File Name||Size||File Description|
|COUNTRWS.CBL||2312||This routine counts table rows.|
This COBOL II DB2/SQL routine will count the number of rows for a given table, based on a specific key/column of data. One use of this routine is to determine if there is at least one row to continue table processing. 12 points.
|CURSRPRC.CBL||5378||This routine demonstrate cursor/set processing.|
This COBOL II DB2/SQL routine will demonstrate how to code cursor/set processing for a given table. The primary use of the process is to return all required rows of data, from 1 or more tables, based on input key data. 30 points.
|DCLRCRSR.CBL||1630||An example of a user DECLARE CURSOR.|
This DB2/SQL example shows how to code a user DECLARE CURSOR table is WORKING- STORAGE. It is basic code structure for all standard SET PROCESSING. Used when selection of all rows of data are required based on specific key data. 10 points.
|MAXIMDAT.CBLL||3424||An example on how to select only one row.|
This COBOL II & DB2/SQL example shows coding required to select only one row of data from a given table, based on users key data and maximum date from a specific date column. Used where multiple rows of data exist, on key data selection. 16 points.
|CGM Home Page||COBOL Services Directory|