Pinned topic CQ to get list of Datsets for a given Copybook
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
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 0600012HN8347 Posts
Re: CQ to get list of Datsets for a given Copybook2012-10-29T22:38:20ZThis is the accepted answer. This is the accepted answer.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 110000D4XK849 Posts
Re: CQ to get list of Datsets for a given Copybook2012-10-30T14:46:50ZThis is the accepted answer. This is the accepted answer.
- jcdelmo 0600012HN8