Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Where is output from PARM ABEXIT (SNA... packerm CA Products 3 Thu Sep 28, 2017 4:06 pm
No new posts MQ command in option 6 of ISPF! Vignesh Sid All Other Mainframe Topics 3 Tue Sep 26, 2017 6:01 pm
No new posts Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 pm
No new posts column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts XMITIP sends it out. Can it copy on l... Rommel Dayon Rustia IBM Tools 0 Tue Sep 05, 2017 10:16 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us