Re: cpyfrmimpf null dilemma ?

["Tim Truax" <truax@xxxxxxxxxxxx>]

Kirk,
I think this is going to be the route I will be forced to follow.  It's a
16,000,000 record file so Excel is out of the question.
It will have to be Access.  I will give that a shot.
Thanks,
Tim
----- Original Message -----
From: <kirkg@manageinc.com>
To: "Midrange Systems Technical Discussion" <midrange-l@midrange.com>
Sent: Wednesday, January 22, 2003 5:34 PM
Subject: Re: cpyfrmimpf null dilemma ?


> How BIG is the file? Is it a 1 time deal? Copying it into Excel or Access
> then to a proper CSV file then to the 400?
>
> It a pain but for a one time deal maybe it would do the job
>
>
> _____________________
> Kirk Goins
> Systems Engineer, Manage Inc.
> IBM Certified iSeries Solutions Expert
> IBM Certified iSeries e-Business Infrastructure
> IBM Certified Designing IBM e-business Solutions
> Office 503-353-1721 x106 Cell 503-577-9519
> kirkg@manageinc.com      www.manageinc.com
>
>
>
>
> "Tim Truax" <truax@telerama.com>
> Sent by: midrange-l-bounces+kirkg=manageinc.com@midrange.com
> 01/22/2003 01:55 PM
> Please respond to Midrange Systems Technical Discussion
>
>
>         To:     "ML - Midrange Email List" <MIDRANGE-L@midrange.com>
>         cc:
>         Subject:        cpyfrmimpf null dilemma ?
>
>
> Hey all,
> Trying to copy a very attractive and massive file that I got from a UNIX
> box
> to my AS400.
> However this "very attractive" file has the dreaded "nulls" disease.
> Them voids between the commas are killing this!
>
> Meaning
> ,,data,,data,,0,1
> ,data,,data,2,,3
>
> What shall I do to get this file to happily travel the "cpyfrmimpf" route
> to
> my matching AS400 database file ??
> Now the "cpyfrmimpf" is griping about the "nulls" ...any suggestions from
> you smart individuals is greatly appreciated ???
>
> Tim  :-)
>
> _______________________________________________
> 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/mailman/listinfo.cgi/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.
>
>
>
> _______________________________________________
> 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/mailman/listinfo.cgi/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.
>