:>: -----Original Message----- :>: From: IBM Mainframe Discussion List [mailto:[email protected]] On :>: Behalf Of John McKown :>: Sent: Friday, April 04, 2014 5:33 AM :>: To: [email protected] :>: Subject: Unload CA-1TMC data into "flat file" for insert into RDMS? :>: :>: Sorry, CA, but I don't like EARL. :>: :>: And I am no longer very CA-1 literate. What I would like to do is to be :>: able to unload the TMC to a "flat file" which is columnar. I would like :>: something akin to what IRRDBU00 does for the RACF data base. I could :>: then :>: write a simple program to read the data in the columns and insert it :>: into :>: my favorite data base (in my case PostgreSQL on Linux). :>: :>: Is there a simple way to do this? I have used an EARL program, but that :>: results in a "report" which is limited in line length (too short) and :>: has :>: "junk" in it (page headings).
Appendix A in the CA-1 Programming Guide shows format of Volume Record and the DSNB Record. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
