Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

XMITIP - Any option to adjust column width in CSV format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News
View previous topic :: :: View next topic  
Author Message
murthy gvn

New User


Joined: 11 Feb 2009
Posts: 4
Location: Hyderabad

PostPosted: Tue Feb 17, 2009 10:31 am    Post subject: XMITIP - Any option to adjust column width in CSV format
Reply with quote

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 .
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Feb 17, 2009 10:47 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
murthy gvn

New User


Joined: 11 Feb 2009
Posts: 4
Location: Hyderabad

PostPosted: Tue Feb 17, 2009 5:47 pm    Post subject: Reply to: XMITIP - Any option to adjust column width in CSV
Reply with quote

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.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Feb 17, 2009 5:55 pm    Post subject:
Reply with quote

1) Please do not post attachments as many people are unable to open them, thus cutting down on the help available.

2) What has an XL sheet have to do with a mainframe ?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Feb 17, 2009 8:17 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
murthy gvn

New User


Joined: 11 Feb 2009
Posts: 4
Location: Hyderabad

PostPosted: Wed Feb 18, 2009 9:24 am    Post subject:
Reply with quote

Thanks for your information. icon_smile.gif
Back to top
View user's profile Send private message
murthy gvn

New User


Joined: 11 Feb 2009
Posts: 4
Location: Hyderabad

PostPosted: Wed Feb 18, 2009 10:03 am    Post subject:
Reply with quote

so there is no sort of any utility to change the width of the excel sheet according to the data ??.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Feb 18, 2009 10:10 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am
No new posts Format record to remove Leading zeroes Learncoholic DFSORT/ICETOOL 14 Wed Apr 05, 2017 2:43 pm
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us