You may think that all you need to do is to "dump the flat file", but the MXG logic to properly combine the TMS CA-1 DSNB and TMSVOL records is about 1200 lines of SAS, and the post processing after it is in a "flat file" (i.e., raw record converted to a SAS observation) requires 33 DATA steps and 20 SORTs to build the TMS data that MXG users require for TAPE, especially for CHARGEBACK.
The real problem is that you need access to all of the related multiple DSNB records and the corresponding VOL record, with coding, for example, to sum each DSNB's space to get the amount of space used on a tape. I think you would want to start with capture of the TMS reports, seems to me I used TMSBINQ output long ago, as it provided all of the important fields at the detail level I needed for validation of my code. Barry Herbert W. “Barry” Merrill, PhD President-Programmer MXG Software Merrill Consultants 10717 Cromwell Drive Dallas, TX 75229 [email protected] http://www.mxg.com - FAQ has Most Answers [email protected] – invoices/PO/Payment [email protected] – technical tel: 214 351 1966 - expect slow reply, use email fax: 214 350 3694 – prefer email, still works -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of John McKown Sent: Friday, April 04, 2014 12:07 PM To: [email protected] Subject: Re: Unload CA-1TMC data into "flat file" for insert into RDMS? On Fri, Apr 4, 2014 at 11:43 AM, Gibney, Dave <[email protected]> wrote: > Copy/format with your SORT product. As already said the TMC is already > pretty much a flat file > Thanks for the reminder. That would be easier than coding up an HLASM routine. Just didn't occur to me. Bad case of Fridayitis, I guess. -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
