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
 
Avoiding Zero suppression

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News
View previous topic :: :: View next topic  
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

Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
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
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 Zero Suppression GuyC DB2 4 Fri May 06, 2011 10:30 am
No new posts Avoiding messages displayed by REXX Sathish Gurumoorthy CLIST & REXX 2 Wed Jul 07, 2010 4:44 pm
No new posts Zero Suppression with DB2 SQL Occitiger DB2 4 Mon Feb 01, 2010 11:19 pm
No new posts space suppression mf_karthik COBOL Programming 13 Thu Nov 05, 2009 8:47 pm
No new posts Leading spaces suppression Robert Sample COBOL Programming 3 Wed Oct 14, 2009 4:03 pm

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