It used to be called "Conversion Reformat Utility;"  apparently, it's been
rehabilitated and can now be seen in public as "Sort."  Anyway, here's the
link:
http://publib.boulder.ibm.com:80/cgi-bin/bookmgr/BOOKS/QBKAQ100/CCONTENTS

The thumbnail sketch is that you write "sort specifications" that describe
the columns you want sorted.  You store those specs in a source file like
QFMTSRC.  You create your "output file" whether it be an addrout or a
tag-along and then invoke FMTDTA to make a sorted copy of your input file.
An addrout file is a file of record addresses - not data.  If you use
addrout files, you need to use a special F spec in your RPG program.
Tag-along sorts are where the sorted data "tags along" with the sort "key
fields."  This is generally a copy of your input file, although you can
include only the columns you wish to.  Note that FMTDTA does not operate on
field names, but column numbers.  You can do record selection as well as
sorting, again based on column numbers.

If you are writing new applications, may I suggest that you look at embedded
SQL first, and if that's not available to you, look at OPNQRYF.  Either of
these are more modern than FMTDTA, and will do the same things.

Buck Calabro
Billing Concepts Albany, NY

> -----Original Message-----
> From: Mary Lynn Riggins 
> Sent: Wednesday, July 21, 1999 11:44 PM
> To:   RPG400-L@midrange.com
> Subject:      FMTDTA
> 
> Does anyone have any information about the CL cmd: FMTDTA used to sort
> input
> files.  I have not been able to find any info and just curious as to how
> the
> process works.
> 
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].