[prev in list] [next in list] [prev in thread] [next in thread] 

List:       racf-l
Subject:    Re: Unload RACF Database
From:       Stu Henderson <stu () STUHENDERSON ! COM>
Date:       2015-07-26 8:59:57
Message-ID: 55B4A18D.1040003 () stuhenderson ! com
[Download RAW message or body]

List,

     Several of you have offered much better answers than mine:
*_
_**_From Walt Farrell_*

I just noticed the DBU2MSXL package available from the RACF Downloads 
page: 
http://www-03.ibm.com/systems/z/os/zos/features/racf/downloads/dbu2msxl.html

I have no experience using that tool, but it claims to do what the OP 
wants, I think.



_*From Nigel Pentland*_

The original question relates to Excel, so I thin it's only fair to give
mention to Cory Curtis who has tools for pulling the unload into Access

https://sites.google.com/site/cgcurtis/

As for me, well guess it's not going to come as any surprise I use my
own utilities

http://www.racf.co.uk



Thanks for sharing, and thanks to IBM for giving us the DBU utility in 
the first place.  Stu




On 7/25/2015 1:59 PM, Stu Henderson wrote:
> List, several people have gently pointed out to me that the approach 
> below won't work.  I was mistaken in thinking that there are escape 
> characters around fields containing blanks, and of course that would 
> make no sense.  What other tools do people use (other than RACFICE, 
> REXX, and DB2, which after all may be sufficient)? Thanks, Stu
>
>
> On 7/24/2015 12:41 PM, Stu Henderson wrote:
>> Sam, I believe that the fields in the unloaded flat file are all 
>> fixed length, and separated with blanks, with I think double quote as 
>> the escape character.  Just load it into excel as text, not csv, 
>> telling Excel that the separater is a blank, and what the escape 
>> character is.  That should do it.  (Don't tell excel fixed length, 
>> since the fields in the various record types do have different 
>> lengths.  HTH. Stu
>>
>>
>> On 7/24/2015 12:05 PM, sam armas wrote:
>>> Morning,
>>> Has anyone done a RACF Database unload and was able to download to a 
>>> CSV format for eventual downloading to an excel spreadsheet, lately.
>>> Sam
>>>
>>
>

-- 
Stu Henderson (301) 229-7187  stu@stuhenderson.com  SITE= www.stuhenderson.com fax=301-229-3958
BLOG at:  www.stuhenderson.com/isauditblog
Next RACF Seminar: December 1-4, 2015 in Bethesda, MD
Next Mainframe Audit Seminar Sept. 21-24, 2015 in Chicago
[prev in list] [next in list] [prev in thread] [next in thread]