Re: CPYFRMIMPF null fields

Jerry,

My solution has been to create a work file that has ALWNULL on all the
fields.  I then massage the data on the null fields to replace null values
with zeros or blanks (UPDATE FILE SET FIELD=' ' WHERE FIELD IS NULL and do
this for all the possible null fields).

Paul

-- 
Paul Morgan
Senior Programmer Analyst - Retail
J. Jill Group
100 Birch Pond Drive, PO Box 2009
Tilton, NH 03276-2009
Phone: (603) 266-2117
Fax:   (603) 266-2333
"Jerry" <jdraper@xxxxxxxxxxxxx> wrote in message
news:1105121768.41ded1e873b87@xxxxxxxxxxxxxxxxxx
> I have a .CSV file on the IFS that came from a Unix system (LF end of rec
> marker).  I get a copy error when using CPYFRMIMPF when it encounters null
> fields.  How do I handle this normal occurrance?
>
> TIA,
>
>
> Jerry Draper
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email:
MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>