Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Avoiding Zero suppression

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Tech Help & IT News
Author Message
crownrk

New User


Joined: 17 Dec 2006
Posts: 2
Location: HYD
PostPosted: Thu Jan 17, 2008 6:17 pm    Post subject: Avoiding Zero suppression
 Reply with quote
Hi

I am trying to FTP a file having of PIC X(5) having values '0000' into CSV file and when i try to open it zeros are suppressed.

Is there any way to avoid the zero suppression
Back to top
View user's profile Send private message
References
PostPosted: Thu Jan 17, 2008 6:17 pm    Post subject: Re: Avoiding Zero suppression Reply with quote
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 895
Location: Virginia, USA
PostPosted: Thu Jan 17, 2008 7:12 pm    Post subject: Re: Avoiding Zero suppression
 Reply with quote
crownrk wrote:
Hi

I am trying to FTP a file having of PIC X(5) having values '0000' into CSV file and when i try to open it zeros are suppressed.

Is there any way to avoid the zero suppression


What are you using to open the CSV file, EXCEL doesn't like leading zeros and drops them. If that is the case then (you should be in a microsoft forum) rename the file to .txt, open it from EXCEL and you can set the field to be text not numeric.
Back to top
View user's profile Send private message
Moved: Thu Jan 17, 2008 7:13 pm by superk From Mainframe COBOL to PC Tech Help & IT News
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Tech Help & IT News All times are GMT + 6 Hours
Page 1 of 1