Re: CPYTOIMPF - extra delimiter issue

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

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...


James Perkins wrote:
> I've never experienced this. I just created an SQL table in QTEMP and the
> CPYTOIMPF command worked for me.
>
> For the main question, the CPYTOIMPF is working as designed. Since you are
> telling it that you want the quote to be delimited and your large string
> starts with a quote, it will qualify it with an additional quote as well as
> enclose the entire string in quotes.
>
> As others have suggested you can write the file directly to the IFS since
> you are already creating the delimited string.
>
> Your other option is to just leave the file as is in QTEMP and use the
> CPYTOIMPF command. I would tend to lean towards this method. With V5R4 they
> stick with the standards and it's really easy to use.
>
> James R. Perkins
>
>
> On Mon, Mar 2, 2009 at 11:51, <Blake.Moorcroft@xxxxxxxxxx> wrote:
>
> > Hello Rob...
> >
> > CPYTOSTMF does not work with an SQL generated table.  The CL program bombs
> > as soon as the command is run when it tries to access the table.
> >
> > Have a good day.
> >
> >
> > Blake Moorcroft
> > Developer - Corporate
> > Russell A. Farrow Limited
> > 1980 Ambassador Drive, PO Box 333, Windsor, Ontario N9C 3R4
> > Bus: 519-966-3003 ext. 566, Fax: 519-966-9870
> > blake.moorcroft@xxxxxxxxxx