Re: CPYFRMIMPF fails since V5R3

[Ron Adams <rondadams@xxxxxxxxx>]

CPYFRMIMPF was apparently re-written at V5R3 and has been a nightmare to 
deal with since. Personally, I have opend three problems with IBM and 
they've finally got it working for all of my situations, but it has not been 
pleasant. I would do a search thru the APARs and try to apply all PTFs 
relating to CPYFRMIMPF (at the moment there are 33 of them), then if it 
still persists, I would recommend reporting this to IBM so they can resolve 
the issue. Also, if this is a critical situation, there is a way to run the 
V5R2 version of the util by setting up a data area.


 On 9/13/05, Bill Meecham <BMeecham@xxxxxxxxxxxxxxxxxxxx> wrote: 
> 
> Don't know if this was suggested...check the CCSID. It can't be 65535.
> Change it to something like 37.
> 
> http://www-912.ibm.com/n_dir/nas4apar.nsf/0/0cd39ad7f981e5bc86256e540042
> 0e53?OpenDocument
> <http://www-912.ibm.com/n_dir/nas4apar.nsf/0/0cd39ad7f981e5bc86256e54004
> 20e53?OpenDocument>
> 
> ----- Original Message -----
> From: Steve <mailto:stephenrichter@xxxxxxxxx> Richter
> To: Midrange Systems Technical <mailto:midrange-l@xxxxxxxxxxxx>
> Discussion
> Sent: Tuesday, September 13, 2005 7:36 AM
> Subject: Re: CPYFRMIMPF fails since V5R3
> 
> cpyfrmimpf bombs on me when I code the EOR parm incorrectly. I used
> the default value for that parm when I should have said *CR - the
> result was pages and pages of machine code errors in the joblog. Then
> another file I used *CR instead of *CRLF and I got some sort of field
> conversion error.
> 
> -Steve
> 
> On 9/13/05, Titus Kruse < t_kruse@xxxxxxxxx <mailto:t_kruse@xxxxxxxxx> >
> wrote:
> >
> > Thank you for this! But I've read the documentaion to these PTFs and
> APAR
> > and they all don't match my problem. We will allthough install them.
> >
> > Titus
> >
> >
> >
> > < michael@xxxxxxxxxxxxxxxxxx <mailto:michael@xxxxxxxxxxxxxxxxxx> >
> schrieb im
> > Newsbeitrag
> >
> news:20050913032209.1cba8986f1dca4f8555220876195c2e0.c162a575de.wbe@emai
> l.email.secureserver.net <http://l.email.secureserver.net>
> <news:20050913032209.1cba8986f1dca4f8555220876195c2e0.c162a575de.wbe@ema
> il.email.secureserver.net <http://il.email.secureserver.net>> ...
> > > Check out these PTFs...SI18900 and SI18637 and this APAR...SE17667.
> > >
> > >
> > > > -------- Original Message --------
> > > > Subject: CPYFRMIMPF fails since V5R3
> > > > From: "Titus Kruse" < t_kruse@xxxxxxxxx <mailto:t_kruse@xxxxxxxxx>
> >
> > > > Date: Tue, September 13, 2005 5:00 am
> > > > To: midrange-l@xxxxxxxxxxxx <mailto:midrange-l@xxxxxxxxxxxx>
> > > >
> > > > Hi!
> > > >
> > > > I'm using CPYFRMIMPF to import a CSV-file to a database file for a
> > couple of
> > > > month now. Since we have updated to V5R3 the command fails with a
> lot of
> > > > MCH0601 messages. I think some input fields are longer than the
> > > > corresponding database-fields. But on previous releases this
> wasn't a
> > > > problem. And the documenation for the command also says: "Fields
> in the
> > > > from-file that are longer than the corresponding fields in the
> to-file
> > will
> > > > be truncated (on the right)." Creating the dataarea QCPFRMIMPF in
> QSYS
> > > > solves the problem but is no solution to me. Does anybody have
> another
> > idea?
> > > > Is a PTF available?
> > > >
> > > > T. Kruse
> > > >
> > > >
> > > >
> > > > --
> > > > This is the Midrange Systems Technical Discussion (MIDRANGE-L)
> mailing
> 
> 
> --
> 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.
> 
>