|
It's a packed numeric field. Thanks for the reference. I'll try to use it, but I'm not sure that I can. The system I'm working on is several hundred miles from here, and I access it thru M$ terminal server client. I don't think I can get out to the web from my connection. Paul Nelson Braxton-Reed, Inc. 630-327-8665 Cell 708-923-7354 Home pnelson@braxton-reed.com ----- Original Message ----- From: <jmoreno@militarycars.com> To: <midrange-l@midrange.com> Sent: Thursday, August 01, 2002 8:01 AM Subject: Re: CPYTOIMPF question > > Mr. Nelson, > > Without going to far let me ask you about that social security field in > your database file. > > Is that database file an externally defined file ? > Is the social security number an alpha field ? Or a numeric field. If > numeric is it Zoned, Packed, Binary ? > > Would you consider converting your Externally defined file to a different > format where you resolve those Leading Zeros ? > > Or better yet. > > It happens that I have worked with this wonderful set of utilities for the > last two days. > They are a way to get around the shortcomings of the creation of a .CSV > file > and I am happy to report that they work wonderfully. > > Try the Martin Rowe's utilities to create a .CSV file > Includes a front end to Edit the Field Mappings (say numeric fields or date > fields .. etc) > > Mr. Rowe has produced pretty clean, sharp and effective software to help us > ... iSeries developers with the oddities of the creation of a .CSV file > > Create a library dbg400 download and install the underlying code > > http://www.dbg400.net/dbg400.html > > And after that install the additional utilities EDTFLDMAP, CRTCSVDTA and > CRTCSVSTMF > > http://www.dbg400.net/crtcsv.html > > If you have any question please contact me directly. I am sure the > directions are pretty clear. > > Thanks again to Mr. Rowe for his contributions. > > > Regards > > > Jorge Moreno > Systems Analyst > Overseas Military Car Sales > Woodbury, New York > > > Paul Nelson Wrote .... : > > > > ... 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. > > > > > > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > >
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.