|
This is because a delimited file does not need the leading zeroes. Numeric values do not have the quotation marks around them, just commas. Can you use fixed length, since they can handle trailing blanks? Or try making a logical that changes the data type to alpha - does this work if the number is packed? - and do the CPYTOIMPF from that logical file. At 07:34 AM 8/1/02 -0500, you wrote: >This is a multi-part message in MIME format. >-- >[ Picked text/plain from multipart/alternative ] >OK, I've searched the archives and Google, but haven't come up with an >answer. I'm using CPYTOIMPF to create a csv file to send to an Oracle >platform. Yes, I get the blanks at the end of the fields, but the Oracle >guys can deal with that. The part that gets them flustered is this: > >The file contains Social Security numbers, and for those numbers that >start with one or two zeros, the leading zeros get stripped off. > >Any thoughts? > >Paul Nelson >Braxton-Reed, Inc. >630-327-8665 Cell >708-923-7354 Home >pnelson@braxton-reed.com >--
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
