Re: cpyfrmimpf null dilemma ?

[kirkg@xxxxxxxxxxxxx]

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.