Fastload Lock Release without table recreate option
I am on Teradata 13 version.I am looking for the options to release the fastload lock apart from dropping and creating the table . Can someone help me in releasing the fastload lock and i am getting "2652: Operation not allowed: tablename is being Loaded." message when i query the table . I have written a dummy script to release the lock but didn't help.
set record vartext ;
BEGIN LOADING DBTOOLS.TEST_1 ERRORFILES DBTOOLS.TEST_ERR1 , DBTOOLS.TEST_ERR2 ;