BTEQ - An Example for script structure in Teradata

Consider the user wants to update the address of an employee in Employee table and plans to increase the salary twice.
Employee table resides in the database named Company.

BTEQ script:
.SET SESSION TRANSACTION ANSI
.LOGON TDUSER/tdpassword

/* Updating details of emp_no 101 */
UPDATE Company.employee SET address='Rome' WHERE emp_no=101;
UPDATE Company.employee SET salary=2*salary WHERE emp_no=101;

 .QUIT