Fastload question

General

Fastload question

Hi Teradata guru's,

I have a small question, when i am loading tables in to Teradata using Ab Initio, some of my tables say 30 tables were locked. To release the lock i am running an empty fastload script for each table. I dont have access to drop and recreate the table. My DBA advised me to write a batch mode script and run it in fastload, so that we can release the table locks of all the tables at once. Can any one help me out with the code of the batch mode script. Thanks all....

vamsi
1 REPLY

Re: Fastload question

You need to execute the fastload script without the DML statement .Remove the DML statement and still lock persists then you need to drop and recreate the table .