For every database there might be multiple Tablespace (TS). I need this information in a single line.
My Approach was to tag all the "DATABASE =" with a sequence (you can see it in the right side cornor) and also the corresponding TS rows with a sequence. This way I can use the JOINKEY to join on sequence number and get the output in a single line.
Struck with the sequence number generation for TS rows. Any pointers here?
Have a look at IFTHEN=(WHEN=GROUP with BEGIN for the DSNT362I. You PUSH the database-name into a fixed position. Identify a "tablepace record" and use BUILD to format the data how you want it. Use OUTFIL OMIT= to get rid of the DSNT362I records.