RE: FMTDTA

["Tracy Ball" <TBall@xxxxxxxxxxxxxxxx>]

Ohhhhh!!  Of course I have used this stuff!!  This is OLD S/36 things.  I 
didn't remember it being called FMTDTA!  I certainly feel ridiculous!  Thanks 
for the trip down memory lane.

-Tracy 
 Ext. 3107


-----Original Message-----
From: Booth Martin [mailto:Booth@xxxxxxxxxxxx]
Sent: Tuesday, February 25, 2003 4:12 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: FMTDTA


// * 'SORT EXECUTING'                                       

// LOAD #GSORT                                              

// FILE NAME-INPUT,LABEL-APCHECK                            

// FILE NAME-OUTPUT,LABEL-APCHECKS,RECORDS-?F'A,APCHECK'?   

// RUN                                                      

     HSORTR     7A        3X  64                            

     FNC   2   8                       CODE & CHECK NUMBER  

     FDC   1  64                       RECORD               

// END                                                      

 

 

Tracy, that is Sys/36 OCL.  The non-// lines are what FMTDTA looks like
today, more or less.

The H line says "I am sorting records by a 7 character work field in
Ascending order and the output record will be 64 long"

The F lines say:  FNormalsortCharacter column 2 thru 8  (comment: Code
&Check Number)

FDataoutputCharacter Column 1 thru 64   (Comment: Record)



This is pretty close.  You can also omit or include based on column values,
you can create summary records,  and you can change values.



But as everyone says, this is old stuff.  There's some nifty new stuff out
there that FMTDTA can not do. 



---------------------------------------------------------

Booth Martin   http://www.MartinVT.com

Booth@xxxxxxxxxxxx

---------------------------------------------------------

 

-------Original Message-------

 

From: RPG programming on the AS400 / iSeries

Date: Tuesday, February 25, 2003 15:37:47

To: RPG programming on the AS400 / iSeries

Subject: RE: FMTDTA

 

I have never heard of the FMTDTA command, however, just looked it up. What
would a sample FMTDTA source look like? I believe I have had some instances
where this would have simplified a process.



Tracy L. Ball

The Jackson Group

Sr. Programmer/Analyst 

(317) 781-4600 ext. 3107







-----Original Message-----

From: Joel Fritz [mailto:JFritz@xxxxxxxxxxxxxxxx]

Sent: Tuesday, February 25, 2003 3:11 PM

To: 'RPG programming on the AS400 / iSeries'

Subject: RE: FMTDTA





FMTDTA is still the easiest way to sort a file by totally bizarre composite

keys like substrings of fields. We use it to shuffle file records for

selecting "random" samples. Here's a sample key that's similar to one we

use--check digit of account number, fourth position of ZIP code, fifth digit

of account number.



I'm not sure it's any faster than a sort query for sorting by conventional

keys. 



> -----Original Message-----

> From: Booth Martin [mailto:Booth@xxxxxxxxxxxx]

> Sent: Tuesday, February 25, 2003 11:37 AM

> To: rpg400-l@xxxxxxxxxxxx

> Subject: RE: FMTDTA

> 

> 

> Tried and true won't leave you bruised and blue.

> 

> Which is fastest when there's a need? FMTDTA still blows 

> away the new young

> bucks so far as I know.

> 

> yes, yes, the new stuff is good, no doubt about it, but lets 

> be kind to the

> old methods that built the empire in the first place.

> 

> 

> ---------------------------------------------------------

> Booth Martin http://www.MartinVT.com

> Booth@xxxxxxxxxxxx

> ---------------------------------------------------------

> 

> -------Original Message-------

> 

> From: RPG programming on the AS400 / iSeries

> Date: Tuesday, February 25, 2003 12:42:40

> To: 'RPG programming on the AS400 / iSeries'

> Subject: RE: FMTDTA

> 

> OPNQRYF? LFs? <g> Old school....... Now we've got SQL, Stored 

> procedures,

> and UDFs! <GDR>

> 

> Eric DeLong

> Sally Beauty Company

> MIS-Project Manager (BSG)

> 940-898-7863 or ext. 1863

> 

> 

> 

> -----Original Message-----

> From: Ric A. LuBell [mailto:rlubell@xxxxxxxxxxxxxxxxxxx]

> Sent: Tuesday, February 25, 2003 10:55 AM

> To: RPG programming on the AS400 / iSeries

> Subject: RE: FMTDTA

> 

> 

> Old science... use OPNQRYF instead, or build LFs as alternative.

> Sincerely, 

> 

> Ric LuBell

> 

> -----Original Message-----

> From: Venkatesh, Vijayendra (Cognizant) 

> [mailto:VVijay1@xxxxxxxxxxxxxxxxx]

> Sent: Monday, February 24, 2003 11:55 PM

> To: rpg400-l@xxxxxxxxxxxx

> Subject: FMTDTA

> 

> Hi all,

> Can any body let me know "What FMTDTA command does" . I 

> understand that it

> processes series of sort spec stored in the SRCPF.

> What does series of sort specs mean. Can you illustrate with 

> an example

> 

> TIA

> Vjiayendra