Cobol program to get data from Large table
Posted: Wed Sep 21, 2016 5:54 pm
I have a table having 7 million records but I want to get only the 2016 data for the employees having the grade from 1 TO 100 .
Is that possible to get total count of each grade through a DB2 query.
I have a program which I have to run 100 times to get the total count for a grade.
Is there any simple way to extract from table.
Please suggest your thoughts.
Is that possible to get total count of each grade through a DB2 query.
I have a program which I have to run 100 times to get the total count for a grade.
Is there any simple way to extract from table.
Please suggest your thoughts.