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
 
Convert field to displayable format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
baljinders

New User


Joined: 21 Aug 2006
Posts: 72

PostPosted: Wed May 12, 2010 9:07 pm    Post subject: Convert field to displayable format
Reply with quote

Hi,

I am ftping a flat file to excel sheet. The issue here is that one of the fields for the flat file has picture clause of S9(15)V99. This field contian amounts.

The value is excel sheet is appearing like 0000000002217691{ for a value of 221769.10

This means i need to convert S9(15)V99 to a displayable format. Can anyone tell me what should be the desired picture clause that i should convert this field to.
Back to top
View user's profile Send private message

Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2504
Location: Atlanta, Georgia, USA

PostPosted: Wed May 12, 2010 10:20 pm    Post subject: Reply to: Convert field to displayable format
Reply with quote

Drop the "S" and all will be forgiven.... icon_wink.gif

Bill
Back to top
View user's profile Send private message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Wed May 12, 2010 10:35 pm    Post subject:
Reply with quote

Quote:

This means i need to convert S9(15)V99 to a displayable format.


If i understood correctly it means edited format...

9(15).99
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 967
Location: Richmond, Virginia

PostPosted: Thu May 13, 2010 12:30 am    Post subject:
Reply with quote

Source field is signed, so need one of these (or with - instead of + for no sign if pos; or with some Z's for zero suppression):

+9(15).99 or 9(15).99+
Back to top
View user's profile Send private message
baljinders

New User


Joined: 21 Aug 2006
Posts: 72

PostPosted: Thu May 13, 2010 12:45 am    Post subject:
Reply with quote

Thanks guys,

I used -ZZZZZZZZZZZZ9.99 and got the desired result.
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Can EDCICONV convert EBCDIC to ASCII... natt.sut IBM Tools 3 Fri Nov 17, 2017 8:46 pm
This topic is locked: you cannot edit posts or make replies. Incrementing current time field by 30... arunsoods DFSORT/ICETOOL 11 Thu Oct 26, 2017 3:22 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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm

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