Micro Focus Studio Enterprise Edition Test Server > Programming > Data Access > File Handling > File Handling Guide > MFSORT and MFJSORT Utilities > DFSORT and ICETOOL Emulation > ICETOOL Emulation > SELECT

SELECT

The following parameters of this ICETOOL operator are supported in MFSORT and MFJSORT:

>--SELECT--FROM(indd)--.-.--TO(outdd)-----------------.-.---------<<
                       | +--DISCARD(savedd)-----------+ |       
                       | +--TO(outdd)-DISCARD(savedd)-+ |                
                       |                                |
                       |   +---,-------+                |
                       |   V           |                |              
                       +-.-.-ON(p,m,f)-.-.--------------+                            
                       | +-ON(VLEN)------+              |
                       |                                |
                       +-.-ALLDUPS---.------------------+             
                       | +-NODUPS----+                  |
                       | +-HIGHER(x)-+                  |
                       | +-LOWER(y)--+                  |
                       | +-EQUAL(v)--+                  |                             
                       | +--FIRST----+                  |
                       | +--LAST-----+                  |
                       |                                |
                       +-.-------------.----------------+
                       | +-VSAMTYPE(x)-+                |
                       |                                |
                       +-.---------.--------------------+
                         +--UZERO--+

Limits and Restrictions:

Parameter	Restriction
`ON`	Maximum ON count of 20
`ON and ALLDUPS\|NODUPS\|HIGHER\|LOWER\|EQUAL\|FIRST\|LAST`	Mandatory keywords