CA TPX Session Management for z/OS

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