View previous topic :: View next topic
|
Author |
Message |
chandrakanth_s
New User
Joined: 15 Mar 2006 Posts: 13
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
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 |
|
|
chandrakanth_s
New User
Joined: 15 Mar 2006 Posts: 13
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
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 |
|
|
|