Greetings, I have created a report from DCOLLECT data with dataset_name volume_serial creation_date space (in kb) and various other fields.
I am looking for a way to scan this report and summarise the space used by each HLQ. Could someone help me out with this requirement please. The input record layout is something like : SYS1.VVDS.VPROD46 PROD46 2011123 10 ABC.DATASET.SOMETHING XYZA41 2008101 80 XYZ.SOMETHING.ELSE YXZA44 2007114 90 ABCXYZ.SOMETHING.ELSE ABC123 2006762 100 ABC.SOME.OTHER.DATASET AAA111 2005092 20 SYS1.VTOCIX.PROD46 ZZZ123 2005123 20 I would like the output to be something like this: SYS1 30 ABC 100 XYZ 90 ABCXYZ 100 I am looking at the IFTHEN and PARSE statements as of now, however, I haven't had much success yet. Any help or pointers would be appreciated. CSC • This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose • Computer Sciences Corporation India Pvt Ltd • 7th, Floor, Block 1B, DLF IT Park, Sivaji Garden, Nandambakkam Post, Ramapuram, Chennai-600 089.

