Teradata Cookbook

How to do it...

1. Open a notepad and create the following script:

.LOGON 127.0.0.1/dbc, dbc; /* Vaild system name and credentials to your system */.DATABASE Database_Name; /* database under which locked table is */erorfiles errortable_name, uv_tablename /* same error table name as in script */begin loading locked_table; /* table which is getting 2652 error */.END LOADING; /* to end pahse 2 and release the lock */.LOGOFF;

2. Save it as dummy_fl.txt.
3. Open the windows Command Prompt and execute this using the FastLoad command, as shown in the following screenshot:

4. This dummy script with no insert statement should release the lock on the target ...