cpyf error

[sudha]

I am facing error while copying records from flat file to dds file (Physical)file.

CPYF FROMFILE(lib1/file1) TOFILE(lib1/file2) MBROPT(*REPLACE) FMTOPT(*NOCHK)

error as below

Data mapping error on member

[DeadManWalks]

Re: cpyf error

where are you getting the flat file from?

[GLS400]

Re: cpyf error

do you have an error message ID?

My cpyf allows the copy but when it is brought up in wrkqry
I get the error "Data mapping error 1 running query."

If I window across (in wrkqry) I can see ++ in the columns that are in error.

Hope this helps
GLS

[B.Hauser]

Re: cpyf error

Are your sure it is a DDS described phyiscal file and not an SQL defined table?
It is not possbile to insert invalid data into SQL defined tables (not even with CPYF (*NOCHK), contrary to DDS described phyiscal files.
In this way, before copying the data you need to make sure there are no invalid data, for examples *Blanks in numeric fields.

Birgitta