Re: CPYTOIMPF question

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.
>
>