Teradata Cookbook

How to do it...

1. Open a notepad and write the following script, with the table from which you want to delete the rows. Save the file as delete_ml.txt:

.LOGTABLE   Logtable_del;.SET ERROROUT STDOUT /* Output to file */.LOGON 127.0.0.1/sysdba,password;.BEGIN DELETE MLOAD TABLES Accounts_ml_del;DELETE FROM Employee WHERE Sal = 0; .END MLOAD;.LOGOFF;

2. Execute the following to execute the created mload script:

/*MLOAD execution*/mload < delete_ml.txt > ml_del.log