Re: Line-ending for IFS test stream file

[CRPence <crpbottle@xxxxxxxxx>]

On 03-Jun-2015 12:41 -0600, MichaelQuigley wrote:
> The whole process is that we export data from the IBM i using
> CPYTOIMPF to a delimited file--i.e., using DTAFMT(*DLM) and
> RMVBLANK(*TRAILING). Some of the character fields are all blanks. In
> the resulting comma separated file, these all blank fields are
> rendered as " "--i.e,. Quote,Space,Quote. The PC process which later
> uses the data doesn't interpret these as blank fields. So I wrote a
> little utility to take out the intervening space between the two
> quotes. <<SNIP>>

  IIRC using RMVBLANK(*BOTH), if acceptable for a non-blank datum, 
would resolve the described issue for a datum of all blanks without 
having to re-process the stream data output by the Copy To Import File 
(CPYTOIMPF) database export utility.