TABLE FILE IPFILE1
PRINT SNO FNAME LNAME
BY FNAME NOPRINT
ON TABLE HOLD AS FILE1
END
TABLEF FILE FILE1
PRINT SNO FNAME LNAME
ON TABLE HOLD AS FILE2
END
-RUN
Output is exact in above cases. No internal sorting is observed in tablef
Still learning!

This message has been edited. Last edited by: <Toshu>,

It All depends on the sort order of IPFILE1 and FILE1.

If FILE1 is already sorted by FNAME then here will be no difference in the outputs.

Toshu,
As per your first TABLE command, you produce the FILE1 output, sorted by FNAME.
Then your TABLEF command just prints the fields in FILE1, so of course you get the same outputs.
If instead your TABLEF runs on IPFILE1, unless this file is presorted by FNAME, you should get different outputs.

Hi Danny/JG,
Input dataset: TS536W.FOCUS.IPFILE1

05TUSHAR SAXENA 123456
02NIREN KUMAR 321234
02RAM NAYAK 999999
04VINAY SINGAL 111111
01VENKAT DEVRA 000001
05TUSHAR MISHRA 123456
07NIREN KUMAR 000001
08RAM SINGH 000001
09VINAY SINGAL 111111
10VENKAT DEVRA 000001
11KAWALD SINGH 999999


FOCUS CODE:

TABLEF FILE IPFILE1
PRINT SNO FNAME LNAME
ON TABLE HOLD AS FILE1
-* I used without holding as well to check the outout in system log. It was same.
END

Output DATASET: TS536W.FOCUS.FILE1
SNO FNAME LNAME
--- ----- -----
5 TUSHAR SAXENA
2 NIREN KUMAR
2 RAM NAYAK
4 VINAY SINGAL
1 VENKAT DEVRA
5 TUSHAR MISHRA
7 NIREN KUMAR
8 RAM SINGH
9 VINAY SINGAL
10 VENKAT DEVRA
11 KAWALD SINGH

MASTER of IPFILE1:
FILE=FILE1 ,SUFFIX=FIX, DATASET='TS536W.FOCUS.IPFILE1'
SEGNAME=FILE1 ,SEGTYPE=S0
FIELDNAME =SNO ,E01 ,USAGE=I2 ,A2 ,$
FIELDNAME =FNAME ,E02 ,USAGE=A7 ,A7 ,$
FIELDNAME =LNAME ,E03 ,USAGE=A7 ,A7 ,$
FIELDNAME =ID ,E04 ,USAGE=A6 ,A6 ,$

Why the o/p is not sorted internally?
Although when using By, it is not sorting data, which is true for TABLEF.

Any suggestions please!

Toshu,

TABLEF does not sort. That is its raison d'etre.

Your file is a sequential file (SUFFIX=FIX) so TABLEF will read the records in sequence and output them in the same order.

What is it that you want to obtain?

FYI,

If the source is a relational table the BY fields are passed and the RDBMS sorts the results.

Thanks everyone! I got that.