CA TPX Session Management for z/OS

Repository Tip: Microsoft Excel input --> Metadata Repository DBXLOAD 

02-10-2015 06:12 PM

Description

Do you use the DBXLOAD utility to load metadata into the Repository? If yes, have you loaded data from a Microsoft Excel spreadsheet into the CA Repository For z/OS?  If so, you may have found that text fields in your Excel sheet do not remain fixed when uploading to a mainframe dataset requiring you to manually align the text fields which can be very time consuming and cumbersome.

Solution

  1. Open the original Excel spreadsheet in Excel

  2. Select FILE .SAVE AS and select FILES OF TYPE (*. CSV ) Comma Delimited File

  3. Open the (*. CSV ) file in Excel

  4. Select FILE .SAVE AS and select FILES OF TYPE(*.PRN) Space Delimited File

  5. Upload the .PRN file to the mainframe

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.