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: 8631
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 Sum the fields in particular format f... sharana64 DFSORT/ICETOOL 9 Fri Jan 05, 2018 1:11 am
No new posts Query on XMITIP abdulrafi All Other Mainframe Topics 1 Wed Oct 25, 2017 6:54 pm
No new posts Format Last Record differently from r... Learncoholic DFSORT/ICETOOL 5 Tue Oct 24, 2017 12:01 pm
No new posts Format issues using XMITIP MSGDD ssdjp1 CLIST & REXX 5 Mon Oct 23, 2017 8:47 pm
No new posts Where is output from PARM ABEXIT (SNA... packerm CA Products 3 Thu Sep 28, 2017 4:06 pm

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