BTEQ - RETLIMIT in Teradata

It specifies the maximum number of rows displayed on the terminal or written to a file in response to a Teradata SQL statement.

Syntax:
.SET RETLIMIT ON | OFF

The RETLIMIT command applies to each Teradata SQL statement, not to Teradata SQL requests. Therefore, if a Teradata SQL request contains several Teradata SQL statements, BTEQ processes the specified number of rows for each statement.

Example:
.LOGON tdpid/username, password;
.SET RETLIMIT 5;
SELECT * FROM tbl_employees;

The above command will show only 5 records although all records are specified in SELECT.