Updated on 2023-04-03 GMT+08:00

ACCESS LOCK

ACCESS LOCK allows you to read the data from a table that may have been 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)

1
2
3
4
5
LOCKING TABLE tab1 FOR ACCESS
 INSERT INTO tab2
 SELECT 
   FROM 
  WHERE ...;

Output

1
2
3
4
5
/* LOCKING TABLE tab1 FOR ACCESS */
INSERT INTO tab2 
 SELECT 
   FROM 
 WHERE ...;