Hi,
When I am trying to send a flat file of CSV format through XMITIP , I am able to view the columns of default width in XL sheet,Due to which i am not able to view the whole data . Is there any possibilty so that we can view the data in proper format .
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello and welcome to the forum,
Please clarify your difficulty. Often when delimited data is loaded into a spreadsheet, the spreadsheet often needs to be changed to accomodate the full width of the data.
If you can post an example of the data being downloaded and what you would prefer to download, we may be able to offer suggestions. Please do not post Windows documents as attachments or screenshots.
Hi,
I had attached my input file and the output which I am getting , I am not able to view the Bill Account no's in correct format, by exapnding the column width directly I was able to view the acct no's, But how to modify the column width directly in the JCL itself to avoid that.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
You need to talk with your desktop/Windows Office support people to change the way the default width is defined on your pc (if that is possible - i'm not a Windows support person).
What you see is quite common - i've either just dragged the spreadsheet column wider or imported into sql server or access and used the data from the database.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Not on the mainframe - the mainframe typically creates a delimited text file which is downloaded, then imported into some Windows app like Excel.
As i mentioned before, you need to talk with your Windows support (or possibly find a Windows/Office forum) and ask if there is a way to change the width of spreadsheet columns so you won't have to adjust them manually.