Using Ca-Culprit and IDMS

martinc · New User Joined: 14 Sep 2015 Posts: 2 Location: Australia

Hi folks,
Looking for some direction here.

Using Ca-Culprit and IDMS.

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.

Any thoughts would be appreciated.

MAC

martinc · New User Joined: 14 Sep 2015 Posts: 2 Location: Australia

mmm, ok lets simplify the problem.

Is there a way to count the number of members in s set, using Culprit and then do something with the count ?.

Kryptster · New User Joined: 16 Sep 2010 Posts: 1 Location: India

Hi Martin,

Is the query resolved?
If so can you pls let me know how?
I am facing the similar issue.
Also I need to know if there is a way to get the DB-Key of the Records.

Thanks,

Akatsukami · Posted: Fri Oct 14, 2016 11:04 pm

Do you really expect an answer after more than a year?