Example: USING Request Modifier with TOP Operator - Advanced SQL Engine - Teradata Database

This example passes the value for n in the TOP n operator in its SELECT request using the INTEGER parameter a as defined in the USING request modifier.

     .SET RECORDMODE ON
     .IMPORT DATA FILE=employee.dat

     USING (a INTEGER)
     SELECT TOP :a *
     FROM employee;