John: TMSDATA Utility—Produce TMS Sequential Data Sets. ("Utilities and Reports
Reference Guide" Release 12.6.00, pg 233)
I'd use SORTDSNB F1STVSN,FILESEQ and your DSNB records could then be merged
(externally) with the Volume (TMC) records[1]. You'd have to do your own work
with 1stVol, VolSeq, VolSer & F1stVsn to chain multi-volume tape sets together
but I expect you're up to it. (simple) JCL is in the utilities manual.
The record layouts, as mentioned by others, are found in Appendix A of the
Programming Guide for v12.6 and you'd have to deal with the packed & binary
fields.
Excerpt from the manual:
Use the TMSDATA program to produce sequential data sets from TMC Volume records
and data set name block (DSNB) records.
You may use these data sets as input for the Generalized Report Writer
(TMSGRW), or ** for programs written in-house **. If a sort sequence is not
specified by control statements, the TMC Volume records are in volume serial
number sequence and the DSNB records are in DSNB number sequence[1]. Inactive
volume records and unused DSNB records are not processed.
CA 1 may be active, batch active or inactive when TMSDATA is run.
Example:
SORTTMC DSN,J,CDATE
SORTDSNB DSN,J,CDATE
[1] DSNB order would be painful and unnecessary since it's relative to the
TMC's internal base address. I suspect you could even DFSORT them to produce a
single file with volume & dataset/FSQ groupings.
--------> signature = 6 lines follows <--------
Neil Duffee, Joe Sysprog, uOttawa, Ottawa, Ont, Canada
telephone:1 613 562 5800 x4585 fax:1 613 562 5161
mailto:NDuffee of uOttawa.ca http:/ /aix1.uOttawa.ca/ ~nduffee
“How *do* you plan for something like that?” Guardian Bob, Reboot
“For every action, there is an equal and opposite criticism.”
“Systems Programming: Guilty, until proven innocent” John Norgauer 2004
-----Original Message-----
From: John McKown [mailto:[email protected]]
Sent: April 4, 2014 08:33
Subject: Unload CA-1TMC data into "flat file" for insert into RDMS?
[snip] 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? [snip]
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
