Tools: DB2 on iSeries and VBA in Bartender barcode software
I am creating catalogs for customers using data gathered via DB2 SQL and Bartender for printing. These items are grouped by category and I need an index of the categories to put in front of these catalogs.
My Data file:
ITEM Description Cost Category
012345, My first item, 9.99, Cat1
012356, My second item, 8.99, Cat1
123456, My third item, 9.99, Cat2
112345, My fourth item, 9.99, Cat3
222356, My fifth item, 8.99, Cat3
333456, My sixth item, 9.99, Cat3
and so on...
There are 13 records per page.
So I'm thinking something along the lines of:
Set PageCount = 1
Set CatName = ItmCat
RecCount increments by 1 for every record
PageCount increments by 1 everytime RecCount = 14.
Reset RecCount after hitting 14
IF ItmCat <> CatName
Write PageCount and ItmCat to file every time ItmCat changes
Loop back to Set
So that my end result is a file to print my index:
Pg 1 Cat1
Pg 2 Cat 2
Pg 6 Cat8
and so on....