Sorting thru FMTDTA QFMTSRC

55 pts.
Tags:
AS/400 commands
AS400 Command
FMTDTA
In my application FMTDAT is used for sorting.
FMTDTA     INFILE((*abcdef) +                            (*abcdef) +                                (*avbgrf) +                                (*abcdef) +                               (*abcdef) +                                 (*abcdef)) +                                OUTFILE(abcdef) +                   SRCFILE(QFMTSRC) [strong]SRCMBR(abcdef[/strong]) +              OPTION(*NOPRT)

Code in SRCMBR   [strong]abcdef1[/strong]:

HSORTRE   69A        3X 256  I P    1   2NEC139            IAP   1   2NEC135            IAP   1   2NEC136

FNP   1   2        FNC   3  40        FDC   1 256        I P    1   2EQC145  IOP   1   2EQC147
What is the meaning of  FNP , FDC, I P, IOP, IAP etc. and what is the use of 2nd and 3rd column. How shorting is done here? Any help would be gratefully appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I believe this is a duplicate question.
Here is the same answer 😉

Here is a link to the FMTDTA manual.
All you questions can be answer here
http://publib.boulder.ibm.com/iseries/v5r1/ic2924/books/c0918260.pdf

Discuss This Question: 7  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.
  • TomLiotta
    Good answer! CharlieBrowne found the manual I was looking for in the earlier question. Tom
    125,585 pointsBadges:
    report
  • AnupamAs400
    Thanks a lot.....manual is really good....
    55 pointsBadges:
    report
  • jbapbecker
    Yeah, manual is superb...NOT!! Its not even there anymore! So frustrating the way they keep moving their links (IBM).
    80 pointsBadges:
    report
  • jbapbecker
    Can anyone shed any light on where it resides now?
    80 pointsBadges:
    report
  • GregManzo
    Better yet, don't even bother with sorting. Just create a physical file & a key (either on the PF or as a LF based over it), then just write data to the file & read it back via the key.
    This is *why* we have an integrated DBMS.
    1,585 pointsBadges:
    report
  • jbapbecker
    Yeah but you're missing the point a bit. I seriously doubt anyone is looking for the information to WRITE any new fmtsrc. However, there may still be a lot of legacy PGMs (as is my case) that need maintained or in fact re-written as you have mentioned..To do this though, you first need to understand what the legacy PGM is doing.
    80 pointsBadges:
    report
  • TheRealRaven
    The link in the 'Answer' doesn't get anything for me.
    21,845 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: