I'm looking to develop a job along the following lines..
1. Get R-100-userid
2. Where (subset) record R200-user-perks has more than 299 database records in the (Subset) for that user-id.
3. Display R100-userid that satisfy the condition.
Problem is there's no DB element counter record in R200-user-perks that i can use as a condition.
I need to use culprit to count the number of records in the set and use the count to only extract the records with more than 300 "perks" records.
I know i could simply dump the lot to a file and use ICETOOL. I already do that for some smaller extracts, but there set are pretty chunky and i'd rather keep it in one place.
I thought about a db-exit, but not sure how to code it so it counts the records.