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 .
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: 19270 Location: Inside the Matrix
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.