Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Using Ca-Culprit and IDMS

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
martinc

New User


Joined: 14 Sep 2015
Posts: 2
Location: Australia

PostPosted: Mon Sep 14, 2015 9:12 am    Post subject: Using Ca-Culprit and IDMS
Reply with quote

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
Back to top
View user's profile Send private message

martinc

New User


Joined: 14 Sep 2015
Posts: 2
Location: Australia

PostPosted: Fri Sep 18, 2015 7:22 am    Post subject: Reply to: looking for some direction.
Reply with quote

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 ?.
Back to top
View user's profile Send private message
Kryptster

New User


Joined: 16 Sep 2010
Posts: 1
Location: India

PostPosted: Fri Oct 14, 2016 10:50 pm    Post subject: Reply to: Using Ca-Culprit and IDMS
Reply with quote

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,
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Fri Oct 14, 2016 11:04 pm    Post subject:
Reply with quote

Do you really expect an answer after more than a year?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm
No new posts ADS 3270 Batch simulator for IDMS rel... gpowell382 IDMS/ADSO 1 Thu May 05, 2016 8:02 pm
No new posts ALTER of an IDMS AREA with NEW/OLD pa... Awanti IDMS/ADSO 2 Mon Mar 14, 2016 10:01 pm
This topic is locked: you cannot edit posts or make replies. Sticky: CA IDMS v18.5 Manuals Pandora-Box IDMS/ADSO 0 Sun Dec 13, 2015 5:37 pm
No new posts Need documents or links to understand... sherlinpraveenkumar IDMS/ADSO 5 Wed Oct 28, 2015 4:40 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us