Re: CPYF: blanks -> Null

I'm going to try some combination of *DROP & *MAP, and see what I can come
up with.

Thanks


date: Fri, 19 Feb 2021 14:51:30 -0500

from: smith5646midrange@xxxxxxxxx
subject: RE: [EXTERNAL] Re: CPYF: blanks -> Null

Justin - I'm assuming you have figured out by now the "easy answer" is
No. CPYF can't do it automagically via a parm or something.

I am assuming you are copying a file with a single field (aka flat file)
to a file with fields defined and using CPYF *NOCHK.

Maybe someone else can jump in here with an answer to this but would a
before trigger on the to file be an option so it replaces the blank with
null before the write? I'm not confident if a trigger will work that way.
It's been too long since I messed with them. If the trigger will work,
that you keep you from substringing your fields to build a fake record out
of your flat data just so you can do an SQL insert.