BTEQ - REPEAT with = (Equivalent) in Teradata

We can use the = Command When Importing a File instead of REPEAT.

The following codes are absolutely same.

1. With REPEAT
Example:
.LOGON localtd/dbc, dbc;
.IMPORT data file = sample.txt;
.REPEAT 3
using empno (char(4))
UPDATE tbl_employee SET salary=2*salary WHERE emp_no= :empno 


2. With '='

Example:
.LOGON localtd/dbc, dbc;
.IMPORT data file = sample.txt;
using empno (char(4))
UPDATE tbl_employee SET salary=2*salary WHERE emp_no= :empno ;
=2


Please note that, the number you want to supply with '=' must be n-1 while in REPEAT n.

.REPEAT 7
or
=6


This is because, '=' symbol already start its operation once it is encountered in the script.
So, it will continue the next repeat operations after performing a repeat operation always.