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 INVALID FIELD OR CONSTANT IN SORTOF ?? Ron Klop DFSORT/ICETOOL 8 Wed Jan 11, 2017 3:44 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Performing arithmetic on input field zh_lad DFSORT/ICETOOL 31 Tue Dec 06, 2016 8:04 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts Overlaying one set of charater values... Kevin Lindsley SYNCSORT 7 Sat Nov 05, 2016 3:21 am


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