Culprit User Manual

 

IBM MAINFRAME: Using Ca-Culprit and IDMS -:::: Author Message martinc New User Joined: 14 Sep 2015 Location: Australia Posted: Mon Sep 14, 2015 9:12 am Post subject: Using Ca-Culprit and IDMS Hi folks, Looking for some direction here. Using Ca-Culprit and IDMS. I'm looking to develop a job along the following lines. Get R-100-userid 2. Where (subset) record R200-user-perks has more than 299 database records in the (Subset) for that user-id. Display R100-userid that satisfy the condition.

Ca Culprit User Manual

Jun 21, 2018 - Construction Business Owner uses cookies on this site to enhance your user experience. The Hidden Culprit of Soaring Construction Costs. The data shows a direct connection between manual collection and suffering.

Pajero

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.

Culprit

Any thoughts would be appreciated. Martinc New User Joined: 14 Sep 2015 Location: Australia Posted: Fri Sep 18, 2015 7:22 am Post subject: Reply to: looking for some direction. 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 Location: India Posted: Fri Oct 14, 2016 10:50 pm Post subject: Reply to: Using Ca-Culprit and IDMS 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 Global Moderator Joined: 03 Oct 2009 Location: Bloomington, IL Posted: Fri Oct 14, 2016 11:04 pm Post subject: Do you really expect an answer after more than a year?:::: - All times are GMT + 6 Hours Page 1 of 1 Search our Forum.