AS/400 FMTDTA command issue

40 pts.
Tags:
AS/400
AS/400 commands
We used FMTDTA command to copy data from one PF to another PF. However, in the target file, one of the fields (length 8 packed decimal), got junk values like (+++++++++++). The file from which the data was copied had all correct values. Also we ensured that both the files (source and target files) have the same structure. Can anyone help me understand what exactly could be the problem due to which junk values are getting copied into target file.


Software/Hardware used:
Iseries
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    What are you using to view the data and see the ++++ ? If both files have the same structure there should have been no issue. Post your structure (DDS) if you have it and the copy command used.Something is not adding up.
    131,595 pointsBadges:
    report
  • GregManzo
    Why use FMTDTA? I haven't seen that used since 1981.
    If a simple re-ordering then a LF index and CPYF will do.
    If a summary sort then SQL with 'group by'.
    2,950 pointsBadges:
    report
  • ToddN2000
    Post your CPYF command. There may be another parameter you are not using like *NOCHK or *DROP. It may help us to understand what you are trying to do.
    131,595 pointsBadges:
    report
  • Splat
    Would you post your source?   
    12,865 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: