Re: CPYTOIMPF - extra delimiter issue

[James Perkins <jrperkinsjr@xxxxxxxxx>]

Yep, just noticed that in the message I replied too. Getting the message
mixed. Thanks for catching that.

I've had LOTS of problems with the CPYTOIMPF prior to V5R4. Blake, since you
are on V5R3, I strongly suggest writing your own delimiter code that will
write directly to the IFS.

Someone out there, I want to say Marting Rowe?, has a free CSV program you
can download. I have used it before and it seems to work well. If you're a
Java guy you can easily code one in Java to except a result set. I've got
some examples of this if you need at all.

--
James R. Perkins


On Mon, Mar 2, 2009 at 13:50, Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>wrote:

> Blake said that CPYTOSTMF didn't work with SQL generated files.  (Which
> is a little misleading... CPYTOSTMF requires a source file or a file
> with only one field -- it doesn't matter if it's SQL generated, but
> typically SQL generated files have more than one field.)
>
> James, you are saying that CPYTOIMPF works fine.  And it should.  but
> it's not the same command Blake is having trouble with (CPYTOSTMF)
>
> It's really easy to get them mixed up, since they both start with CPYTO...