Topic
2 replies Latest Post - ‏2012-10-30T14:46:50Z by SystemAdmin
SystemAdmin
SystemAdmin
849 Posts
ACCEPTED ANSWER

Pinned topic CQ to get list of Datsets for a given Copybook

‏2012-10-29T16:09:44Z |
I am trying to get the list of impacted datasets for a copybook. Can you provide Custom query to retrieve the same?
Updated on 2012-10-30T14:46:50Z at 2012-10-30T14:46:50Z by SystemAdmin
  • jcdelmo
    jcdelmo
    292 Posts
    ACCEPTED ANSWER

    Re: CQ to get list of Datsets for a given Copybook

    ‏2012-10-29T22:38:20Z  in response to SystemAdmin
    Assuming the COPYBOOK defines an I/O structure (DATA ELEMENT asset) of a given file (DATASTORE asset) than what you want is a list of all the data sets (DATASET asset) that are read/written to/from that I/O structure, correct?

    The meta-data data links that have to be followed to go from a DATA ELEMENT to DATA SET would be:

    FILE -> DATA ELEMENT -> DATA STORE -> PROGRAM -> RUN UNIT CONTENT -> RUN UNIT -> BATCH JOB -> DD -> DATA SET

    While it may be possible to write such a query, the Impact analysis functionality of RAA is what would normally be used to accomplish your request. Is there a reason you need this as a custom query vs an Impact analysis on the I/O record asset for the data store ?
    • SystemAdmin
      SystemAdmin
      849 Posts
      ACCEPTED ANSWER

      Re: CQ to get list of Datsets for a given Copybook

      ‏2012-10-30T14:46:50Z  in response to jcdelmo
      Our analysts are looking out to see the cross-reference when they look at any Dataset/Copybook. That is the reason for looking out for the CQ.