sponsored links

Collapse

Announcement

Collapse
No announcement yet.

cpyf error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • cpyf error

    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
    The Secret Of Achieving Your Goals Is Revealed Before Your Eyes.
    System Engineer

    Sudha...

  • #2
    Re: cpyf error

    where are you getting the flat file from?
    Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

    Comment


    • #3
      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
      The problem with quotes on the internet is that it is hard to verify their authenticity.....Abraham Lincoln

      Comment


      • #4
        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

        Comment

        sponsored links

        Collapse

        Working...
        X