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 ...;