Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> SQL Syntax Migration Reference> Teradata Syntax Migration> ACCESS LOCK
View PDF

ACCESS LOCK

ACCESS LOCK is used to allow the user to read the data from a table that may already be locked for the READ or WRITE.

Use the tdMigrateLOCKOption configuration parameter to configure migration of query containing the LOCK keyword. If tdMigrateLOCKOption is set to false, the tool will skip migration of the query and will log a message.

Input - ACCESS LOCK (tdMigrateLOCKOption=True)

LOCKING TABLE tab1 FOR ACCESS
 INSERT INTO tab2
 SELECT …
   FROM …
  WHERE ...;

Output

/* LOCKING TABLE tab1 FOR ACCESS */
INSERT INTO tab2 
SELECT … 
  FROM … 
 WHERE ...;