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
 

 

Distinct values in the field of particular Segment

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
chandrakanth_s

New User


Joined: 15 Mar 2006
Posts: 13

PostPosted: Fri Aug 17, 2007 11:12 pm    Post subject: Distinct values in the field of particular Segment
Reply with quote

Hi,

Could any one let me know how to find the unique values in the field of any Segments. Please look the below example

Assume, I have 5 segments in a Database. One of the segments has patient-status field. I wanted to know what are the values that are stored in the Patient-status field of that particular segment.

Please let me know is there any way that I can find it out through IMS File-Aid or Kindly provide if you have any JCL to retrieve those values.

Regards,
Chandrakanth
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Sat Aug 18, 2007 1:19 am    Post subject:
Reply with quote

You need to extract or unload all segment occurances of that particular segment and then run a sort step to get distinct values for patient-status field.

You can check the File AId extract option by giving selection criteria


Or the other option is to know how the patient-status field is loaded in database, assuming that there should be some rules of how this status field should be updated.
Back to top
View user's profile Send private message
chandrakanth_s

New User


Joined: 15 Mar 2006
Posts: 13

PostPosted: Sat Aug 18, 2007 1:31 am    Post subject: Reply to: Distinct values in the field of particular Segment
Reply with quote

Thanks for the information. Could you please let me know is there any batch JCL can be submitted through Fileaid to unload all the occurances of that segment.

Could you please pass on the steps to unload all the occurances to a flat file from any particualar segment through fileaid.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Sat Aug 18, 2007 2:35 am    Post subject:
Reply with quote

Try below option:

Code:
 4  Extract/Load   Extract or load a data base or subset


Code:
1 Data Base Extract   Extract from a data base to a sequential file   


The options are self explanatory.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts BI,TO=ZD Changing Values Tyler Dunbar DFSORT/ICETOOL 4 Tue Jul 25, 2017 12:12 am
No new posts Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts READ A PACKED "NEGATIVE" FI... jdesouza CA Products 3 Tue May 02, 2017 11:43 pm
No new posts Alter &DATENS field in HEADER1 Angad DFSORT/ICETOOL 4 Mon Apr 24, 2017 11:49 am


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