Issue with CPYTOIMPPF

[Mukund]

Hi,

In one of my applications where we interface JDE with an external application, we gather the data from JDE files and populate a PF in a format that the downstream application understands and then do a simple CPYTOIMPF operation in a CL program to write it into a stream file on IFS as an .XML file from where the downstream application picks up the information.

However, I noticed that the CPYTOIMPF command does not work consistently. Sometimes the data format in the XML file and the PF are identical however a few times the format in the XML file go haywire. I use the below command

CPYTOIMPF FROMFILE(PO204F) TOSTMF(&IFSPATH) MBROPT(*REPLACE) STMFCODPAG(*PCASCII) RCMDDLM(*LF) DTAFMT(*FIXED) STRDLM(*NONE) FLDDLM(' ') DATFMT(*ISO)

The AS/400 version we use is V5R3.

Has anybody in this forum come across a similar problem? If yes could you please share your ideas on how you resolved it.

Thanks,
Mukund

 

[jean_driscoll]

looking at the command, I would not use a space as delimiter as many text fields have spaces in them. Try a semicolon ( or something as space delimiter

 

[DBelcher48]

Mukund,

I have been working around this particular problem the entire week. We
upgraded to V5R3 over the Thanksgiving Day weekend and I was out most of
December on vacation. This week, obviously, everyone is excuting every
program that wasn't tested because I'm getting a ton of calls. The
behavior of CPYTOIMPF/CPYFRMIMF was changed at V5R3 and you need to
research the APARS SI16247 and II13784. The critical points to the
change are:

No conversion perform if TOFILE field has no CCSID or a 65535 CCSID
Record delimiter (RCDDLM) paramter change
Character strings containing a null character (X'00') allowed only
in binary fields

Douglas Belcher
KV Pharmaceutical
St Louis, MO
Opinions expressed are not necessarily those of my employer

_____

From: [email protected] [mailto:[email protected]]
On Behalf Of Mukund
Sent: Friday, December 30, 2005 1:25 PM
To: [email protected]
Subject: Issue with CPYTOIMPPF


Hi,

In one of my applications where we interface JDE with an external
application, we gather the data from JDE files and populate a PF in a
format that the downstream application understands and then do a simple
CPYTOIMPF operation in a CL program to write it into a stream file on
IFS as an .XML file from where the downstream application picks up the
information.

However, I noticed that the CPYTOIMPF command does not work
consistently. Sometimes the data format in the XML file and the PF are
identical however a few times the format in the XML file go haywire. I
use the below command

CPYTOIMPF FROMFILE(PO204F) TOSTMF(&IFSPATH) MBROPT(*REPLACE)
STMFCODPAG(*PCASCII) RCMDDLM(*LF) DTAFMT(*FIXED) STRDLM(*NONE) FLDDLM('
') DATFMT(*ISO)

The AS/400 version we use is V5R3.

Has anybody in this forum come across a similar problem? If yes could
you please share your ideas on how you resolved it.

Thanks,
Mukund

_____


The entire JDELIST thread
<http://www.jdelist.com/ubb/showflat.php?Cat=3D&Board=3D"W"&Number=3D"101 is available for viewing.

Looking for a job? Check out the Job Opportunites forum
This is the JDELIST World Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwards(r).

.

 

[JDEPrincess]

CPYTOIMPF uses SQL underneath and has been altered significantly with V5R3 in regards to CCSID as well as several other factors.

With this introduced complexity, several bugs were introduced.

Here is a list of links discussing changes to CPYTOIMPF:
http://www-912.ibm.com/s_dir/slkbase.nsf/0/2b92592e8b597ca586256eb6004d2405?OpenDocument

http://archive.midrange.com/midrange-l/200412/msg00307.html

http://www-912.ibm.com/ImprovedSearch/search.jsp?q=cpytoimpf and v5r3&action=fromoption&scope=apars

Note that the last link lists 29 APARs on V5R3 alone.

My recommendation is that you review these APARs and associated PTF recommendations and make sure you have them all loaded on your system.

Happy New Year Everybody!
A.D.