Hi Joe
Using this
Google query you can find a
repository and
documentation about DBU2MSXL. I suppose the same holds for the other tool.
With CARLa you can easily create CSV output, using the HEADER=CSV (or better, with column titles using HEADER=CSVT) parameter in the OPTION and NEWLIST commands. For example:
newlist type=racf header=csvt
select class=user segment=base
sortlist key name ljdate($date,10) revoked
Personally, I much prefer the TSVT format that uses TAB characters as separator, thus removing need for quotes. Quotes play havoc with some field types.
If you want to output dataset and resource profiles, use newlist type=racf_access for easier formatting of the ACL. For inspiration about field names, for the different profile types and segments, look at the RECREATE application, that is member names CKRXCxxx and CKRXRxxx in SCKRCARL.
If you need to export several classes of profiles in the same pass (job), you can use the DD=ddname parameter on the NEWLIST command, and allocate said ddnames in your JCL. Each DD receives its own data WITH a proper title line. If your output data set in a PDSE, you can even allocate DDs to different members of the same PDSE, but don't try this with a traditional PDS.
I suggest you stay away from XML, due to the limitations on support in CARLa and necessary work-arounds, unless your application demands it.
------------------------------
Rob van Hoboken
------------------------------