Guys,

Anybody having clue on the syntax to find no of rows in a master file.

<>

tks,
sam

Sam,

When you try and enter code or carat characters place it between [ code] and [/code] (no spaces) otherwise we will not see your entire post.

So you want to know how to produce the same output as Count(*) in Oracle?

Well -

SQL
  SELECT COUNT(*)
    FROM oracletable
   WHERE clauses etc.
;
TABLE FILE SQLOUT
PRINT E01/I9
END

will do it .... or -

TABLE FILE synonym_name
   WRITE CNT.fieldname/I9
or SUM CNT.fieldname/I9
or ADD CNT.fieldname/I9
or COUNT fieldname/I9
END

T

any clue on &LINES funda ??

F..

&LINES and &RECORDS are amper variables.
You get the result after the report

So

-SET &ECHO=ALL;
TABLE FILE synonym_name
   WRITE CNT.fieldname/I9
or SUM CNT.fieldname/I9
or ADD CNT.fieldname/I9
or COUNT fieldname/I9
ON TABLE HOLD
END
-TYPE &LINES

Will show you how many lines you have in the report, and then you can test if this is what you want.
PE if the result would be 10.000 you may decide to not print it, because that would print a little book.